Hi this is is a weird issue that I'm hoping has an easy answer.
So I'm importing a tab delmited text file with quotes for text qualifiers. I've set it all up in SSIS 2008 set the "Text Qualifier" in the Flat File connection to: ".
Everything imports fine when I run in debug mode from Visual Studio but when I build it and try to run the .dtsx file from SQL 2008 using DTExec the Text Qualifier is ignored and the quotes are imported in. This has only been happening recently. Any ideas?