Can anyone show me an example of a connection string to an sql database with:
2.An instance name
3.A login user name
I can't seem to form one.
Here's is the one that is not working:
"Data Source=LMHT-SQ12DEV\\UATITDEV;Initial Catalog=SSIS_CONFIG;Integrated Security=False;User ID=Smith;Password=#####;Provider=SQLNCLI10.1;"