SSIS Question - Error in Connection Manager 1

[sqlsadie108]

Hi, I am in the process of converting a DTS pkg to SSIS. In the connection manager I get this error when I click on "columns":

The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding text qualifiers in data. Parsing columns that contain data with text qualifiers will fail at run time.

Yes, the text file is delimited by "". From what I can tell this is not supported? Yes or No?

If no, can someone please guide me as to which task to use to convert the "" to another delimiter?

THANKS VERY MUCH

 

[mrdenny]

Yes delimited columns are supported. In the defination of the connection to the text file you can tell it that it's delimited.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mrdenny]

You may want to check out forum1555.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sqlsadie108]

Ok, thanks!

My other post was related, I seem to have figured it out now... I cannot reuse the old connection manager connection from the DTS migration, I need to create a new one - the new one does not give me the error about the double-quotes