August 12, 2010 at 1:17 pm
Hello,
Please help me on this.
This is my config file for the connection manager.
<Configuration ConfiguredType="Property" Path="\Package.Connections[DLS].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>Data Source=MYSERVERNAME;Initial Catalog=DatabaseName;
Provider=SQLNCLI10.1;
Integrated Security=SSPI;
Auto Translate=False;
Application Name=SSIS-Package2-{2E40AF11-3F6B-47DC-993B-EF1F45D6ADD3}TS02/TSA.DBName;
</ConfiguredValue>
</Configuration>
when i execute the package it gives me an error, see below
The connection string format is not valid. It must consist of one or more components of the form X=Y,
separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager.
If i run the package without config files, it runs fine. The package has 3 execute sql tasks and delay validation is set to true.
Any ideas on this, Please!
August 13, 2010 at 12:33 am
The connection string is used to connect to a database using OLE DB, right?
My connection strings look the same, but I don't have the Application Name part.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 13, 2010 at 7:23 am
That's correct it's an OLEDB connection. My all other config files have the similar connection string and works fine but not this package...
I am using a bunch of execute sql tasks, for loop container and a global temp table. I configured the retain same connection and delay validation as required.
I tried removing the application name but it didn't work either. And i just noticied that the server name at the end of the application name is different from
the servername of the OLEDB connection manager.
Any thoughts on this one?
Thanks,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply