none
Exporting SQL Table into fixed width text file RRS feed

  • Question

  • Hi Guys,

    Iam not able to figure out a way on how to export the table columns into a text file and where every field has a fixed field position.I tried using fixed width i.e no column delimiters but every time I do it all the rows are coming in a single row rather than multiples rows !!! Is there any way around this

    I tried to use a method as given in this url :http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/ ...but the example shows a method using tabs which is not quite helpful for in my case

    any help would be really appreciated

    Thanks,

    Saturday, June 13, 2009 6:35 PM

All replies