June 9, 2009 at 1:23 pm
I am trying to schedule a job to produce a flat file from a SQL Server table. The table has one column defined as a nvarchar(306).
The SSIS package has a simple data flow where Input column is defined as a datatype of string[DT_STR] with the output going to a text file.
When I execute the package through SSIS, it works perfectly, and I get the results I'm expecting. But when run the same SSIS package through a scheduled job, I get double quotes around my value on each line.
It's hard to believe the job running the SSIS package is putting in the double quotes. Any thoughts on where the double quotes are coming from and how to prevent them.
I am running SQL Server 2005 SP2 Enterprise.
Thank you very much.
June 9, 2009 at 6:18 pm
If you check the properties for your destination flat file connection, has Text Qualifier been set to {none} - but in angled brackets (they won't render here)?
You could also set the TextQualified property of the column to False in the Advanced section of the Flat File Connection Manager Editor.
June 9, 2009 at 7:51 pm
Thank you for your reply - The text qualifer is in "" and in Advanced Properties the TextQualified = False.
I noticed on the Flat File Connection Manager when I click on "Columns", the quotes are there - that almost implies since this is supposed to be reading the source column out of the database that the database values are surrounded by quotes. But they are not.
I'll keep looking and post back my findings. Again, thanks for taking the time to respond.
June 9, 2009 at 7:59 pm
So if you set the text qualifier to None, does the problem go away?
June 9, 2009 at 8:07 pm
you are correct the angle brackets don't render here. Sorry. The field is set as none with angled brackets
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply