My Blog List

hotinit.com. Powered by Blogger.

Search This Blog

VB Connection String for SSIS

Monday, 6 June 2011

   Dts.Variables("OLEDB_Source").Value = "Data Source=" & Dts.Variables("CenterServerName").Value.ToString & ";User ID=" & Dts.Variables("CenterDBUserName").Value.ToString & ";Password =" & Dts.Variables("CenterDBPwd").Value.ToString & ";initial Catalog=" & Dts.Variables("CenterServerDBName").Value.ToString & ";Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False;Auto Translate=False;"

No comments:

Post a Comment

 

Blogger news

Blogroll

Most Reading

8.6/10