problem exporting data from sql server to a txt or csv file

• Michael Riedmueller

  SSC-Addicted

  Points: 429

  More actions

  January 16, 2007 at 4:43 am

  #683429

  Hi,

  I do not know of any limits in the number of fields usable. Even if there are, 50 fields cannot be a problem.

  I found on the other hand that some changes are not automatically passed on to the file when you have specified a connection to an already existing file. Then you may have to manually add the columns to your destination in the extended editor.

  If you want to have SSIS create a file with all fields then you need to obey a certain sequence when creating the destination, connection manager and connection to the last step processing your data.

  Then SSIS may create fields for each column and map them accordingly.

   

  Regards,

  Michael

• pinky

  SSCommitted

  Points: 1997

  More actions

  January 16, 2007 at 8:04 am

  #683488

  Hi,

  i am using sql server 2000. I am doing this via DTS. i tried just giving 26 fields and it was able to read with no problems. so i am guessing that the number of fields matters for a txt or a csv file.

  Any ideas?

• Michael T

  SSC-Addicted

  Points: 479

  More actions

  January 16, 2007 at 10:21 am

  #683540

  Hi,

  I just created an export to text DTS (with 62 columns by using the "Export Data..." wizard, and the DTS works correctly.

  Michael

• pinky

  SSCommitted

  Points: 1997

  More actions

  January 16, 2007 at 12:19 pm

  #683580

  Thanks Michael for your reply.

  I am able to do this via Import/Export wizard. I was using DTS designer to accomplish this and was facing problem. Thanks again for your help.

• luciano barretta

  Mr or Mrs. 500

  Points: 563

  More actions

  January 17, 2007 at 3:46 am

  #683679

  hi pinky,

  try using wizard and bywizard save your dts. then you can check the difference between the one realized by wizard and your one.

  i've exported table with more than 50 fields without any problem...

  Luciano