SSIS - CONNECTION STRINGS ISSUE
I am migrating a sql2005 SSIS package to sql2008 version but I need a clarification on the connection strings. In 2005 version, I have the following which works fine: Data Source=SALESDB\SQL2005,5533;Initial Catalog=DAILYSALES;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False; But after migration to 2008, I created the 2008 version using SQLNCLI10.1 from connection manager(instead of SQLNCLI.1) and I got the following: Data Source=SALESDB\SQL2008,5533;Initial Catalog=DAILYSALES;Provider=SQLNCLI10.1;Integrated Security=SSPI;Application Name=Location_Data_Load-{531332AE-4C87-4077-8481-1CF896D2E576}SALESDB\SQL2008,5533.DAILYSALES;Auto Translate=False; This looks complex to me even though it may be working in dev. Please, does any one know why package/application name, id and duplicate server name were included in the connection string? If I remove them, will there be any impact? I tried this: Data Source=SALESDB\SQL2008,5533;Initial Catalog=DAILYSALES;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False; and it seems to connect (though I haven't tested the entire load package. Thanks
March 9th, 2011 6:25am

It should not make any difference. In fact, you conceivable could edit the Connection String tag of all your Packages in the XML code doing a simple Find and Replace and it would work, but I don't usually recommend editing code for simple stull like this. You should be fine with the edited version of the Connection String.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2011 7:23am

It is fine. In fact, several SSIS experts recommend editing the "Application Name" property to allow easy identification of the connections in this package when examined using Profiler or other SQL tools. Talk to me now on
March 9th, 2011 6:35pm

Thank you all. From your comments, I guess I can remove this part: Application Name=Location_Data_Load-{531332AE-4C87-4077-8481-1CF896D2E576}SALESDB\SQL2008,5533.DAILYSALES; so that I can have only this as the connection string: Data Source=SALESDB\SQL2008,5533;Initial Catalog=DAILYSALES;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False; Thank you.
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2011 3:56am

This in an interesting post. I would like to rename the "Application Name" in an SSIS package to a shorter name because it makes a configuration table entry for the configuration file connection string too long to save (over 256 characters). This post says that its a property. Hmmm, can't seem to locate this property. Where do I find it?
November 9th, 2012 1:10pm

Click on the Connection Manager in question, then look in the Properties pane (usually on the right-hand side). Look for the Connection String property. You should be able to manually edit that as required. Hope that helps.Todd C - MSCTS SQL Server 2005, MCITP BI Dev 2008 Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2012 7:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics