DTS and SSIS exporting flat file formats.
Hello, When DTS exports data to flat file the format is the following: (Having for Column 1 and column 3 quotable is checked and for Column 2 not) "Column1", "Column2", "Column3" "DataVal1", DataVal2," DataVal3" In DTS we see that thow Column2 is NOT quotable the header is "Column2" (quotable). But in SSIS the quotable option is also affecting on header row: "Column1", Column2, "Column3" "DataVal1", DataVal2, "DataVal3" Is there any option to export file in SSIS with DTS format.
July 9th, 2009 7:15am

What's the datatype for Column 2?Please click the Mark as Answer button if a post solves your problem!
Free Windows Admin Tool Kit Click here and download it now
July 9th, 2009 9:04am

Actually in DTS it does not matter the column data type though it is int, varchar, or datetime. DTS exports columns headers of all types in quotes.
July 9th, 2009 9:21am

So I need SSIS to do the same. Export columns headers of all types in quotes.
Free Windows Admin Tool Kit Click here and download it now
July 9th, 2009 9:23am

In your flat file connection manager,make sureyour text qualifer is set to" (double quote). When you export, that will cause your columns and data to be wrapped in quotes.JPPlease click the Mark as Answer button if a post solves your problem!
July 9th, 2009 9:29am

Yes, in SSIS in "Text qualifier" field I set double quoted, but with that I'm just setting the symbol for all columns qualifier. The option that define whether the column must be quoted or not is in "Flat File Connection Manager Editor" -> "Advanced" and then for each column there is boolean "TextQualified" option.
Free Windows Admin Tool Kit Click here and download it now
July 9th, 2009 9:42am

And data type is String for all columns. (:
July 9th, 2009 11:32am

Hi NURMS,SSIS do not have an option to qualify only column names and not the data in those columns. I think the best option for you would be to turn off the TextQualified flags for such columns and then add quotes manually if you really need them.Thanks,BobThis posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
July 16th, 2009 6:38pm

Hi NURMS, SSIS do not have an option to qualify only column names and not the data in those columns. I think the best option for you would be to turn off the TextQualified flags for such columns and then add quotes manually if you really need them. Thanks, Bob This posting is provided "AS IS" with no warranties, and confers no rights. Although this post is quite old, I still found it, so I thought I would correct it for others who might also land here. Incorrect. It is possible to qualify only column names and not the data, however, I suspect that the actual problem being presented here was misunderstood. One problem is that when the text qualifier is set to double quotes, the output will have 2 sets of double quotes around only the header items, with a single set around the row data. This solution for each situation is below. To remove double sets of quotes: 1. On the 'Flat File Connection Manager Editor' (General) section - Place the desired text qualifier for row data in the 'Text qualifier' field. 2. On the 'Flat File Connection Manager Editor' (advanced) section - REMOVE the double quotes around the column name in the 'Name' field. (This is the second set, with the text qualifier from the general section being the first set. To achieve qualified headers with non-qualified row data: 1. On the 'Flat File Connection Manager Editor' (General) section - Delete the value from 'Text qualifier' field. (Or type none) 2. On the 'Flat File Connection Manager Editor' (advanced) section - ADD double quotes around the column name in the 'Name' field. (This will become your only qualified column names and row data will not be qualified since there is none set. Keywords: UPDATED SOLVED SSIS qualified column names flat file text output
July 19th, 2012 11:46am

As previously stated, although this is an older post, I'm sure it will find someone deep in the trenches of a DTS to SSIS conversion project. For those of you who are going through this process (as a result of DTS no longer being supported) I wanted to share some useful information. Pragmatic Works has developed a great tool called DTSxChange. This product converts DTS to SSIS 2005/2008 will very little effort. In light of this, DTS xChange will automatically convert most of your tasks, variables, connections and other package level settings automatically. I have included the link to a video tutorial below. Best of luck. Upgrading DTS Packages to SSIS http://pragmaticworks.com/Resources/webinars/WebinarSummary.aspx?ResourceID=408 Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz
Free Windows Admin Tool Kit Click here and download it now
July 27th, 2012 4:28pm

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

Other recent topics Other recent topics