Friday, March 15, 2013 1:41 AM
I created an SSIS package under SSIS (Sql 2008 SP3), created a file connection, and successfully imported some data. Then I copied the package and same input data to a sql 2008 server with SP1 install. While the SSIS package worked fine on the SP3 server the same package fails immediately on data import on the server with SP1 installed. (I guess I shouldn't be surprised by that after all I was going from a higher to lower SP. Bad me.). When I create new file connections on either server the file connection manager Main page shows: Format: Text Qualifier : <none>. But the format shown for the copied connections is Format: Text Qualifier: _x003C_none_x003E_ and there is no option to change this back to none. Any ideas what is going on much appreciated.
Friday, March 15, 2013 1:52 AM
I found that by selecting the connection, pressing F4, I could manually change the Text Qualifier to <none>. And to my surprise after changing all text qualifiers to <none> the import routine began working! (Life doesn't get any better than that );
Friday, March 15, 2013 5:03 AM
It is side effect of the bug fix to 2008 SP1, introduced in 2008 SP1 CU6 to allow special characters in text qualifiers (http://support.microsoft.com/kb/977889).
SP1 CU6 and above allows to use such characters and it uses standard XML encoding for Text Qualifier.
Older SSIS versions are not able to decode it properly.
- Marked As Answer by edm2 Friday, March 15, 2013 7:49 AM
Friday, March 15, 2013 7:50 AM
Than you Piotr. I had no idea what the source of the issue was.