Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 How to read variables for creating constring

Author  Topic 

skk
Starting Member

8 Posts

Posted - 2009-03-16 : 11:07:15
Hi

I am creating the Connectionstring by reading database file name from a XML file which may change offten.

So i created a variable to read this variable and i am using this variable in Connection string.

But if i open the Package in different system it is looking for validate the connection string and failing eventhough i set property 'validateexternalmetadata' to false.

How can we avoid this?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-16 : 14:05:00
are you using expression builder to set value for connection string from variable?
Go to Top of Page

skk
Starting Member

8 Posts

Posted - 2009-03-16 : 15:25:07
No. I am using script task. i am reading from xml and assigning to variable
Go to Top of Page

skk
Starting Member

8 Posts

Posted - 2009-03-16 : 16:11:11
Sorry i didnt understand first.yes i am using expession for creating Connection string
Go to Top of Page
   

- Advertisement -