Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSIS 2008 (SP1) -> SSIS 2008 (SP1)

Answered SSIS 2008 (SP1) -> SSIS 2008 (SP1)

  • Friday, March 15, 2013 1:41 AM
     
     
    Sign In to Vote
    0

    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.

    TIA,

    edm2

     

All Replies

  • Friday, March 15, 2013 1:52 AM
     
     
    Sign In to Vote
    0

    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 );

    edm2

     
  • Friday, March 15, 2013 5:03 AM
     
     Answered
    Sign In to Vote
    0

    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
     
     
    Sign In to Vote
    0

    Than you Piotr. I had no idea what the source of the issue was.

    edm2