import data
Are you actually using the same source csv file in prod and dev? Easy enough to open them both up in notepad (not Excel!) and see if there are quotes in both of them.Chuck
April 19th, 2012 4:32pm

Do you have same version of BIDS in development and Production. Open the package in production, now open the flat file connection manager and see whether the text qualifier (") is there or not? Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog BIDS is installed in Dev but not in Prod.
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2012 8:12am

Are you actually using the same source csv file in prod and dev? Easy enough to open them both up in notepad (not Excel!) and see if there are quotes in both of them.Chuck
April 28th, 2012 9:48am

I have created a ssis package. It first takes a .csv file and placed the data into a temp table in sql server. The temp table has varchar field data types All works fine in Development server. But in Production server the temp table shows the values with double quotes around them in the fields i.e. "17 sep 2012"... Do you know why this is the case please? Thanks
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2012 5:24am

Did you specify a text qualifier in the flat file connection manager? Try putting " as text qualifier and see if that helps.MCTS, MCITP - Please mark posts as answered where appropriate.
April 29th, 2012 5:54am

Yes, there is textqualifier as " I am puzzled why it works fine in Dev but not in Prod. i.e. the temp table takes the data from .csv and you can see the data in the temp table without " double quotes whereas in Prod you see the data in temp table with double quotes around the data in the fields. The temp table in both Dev and prod has the same datatypes. Any thoughts please?
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2012 6:06am

Do you have same version of BIDS in development and Production. Open the package in production, now open the flat file connection manager and see whether the text qualifier (") is there or not? Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog
April 29th, 2012 6:15am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics