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.
| Author |
Topic |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2012-09-24 : 08:49:27
|
| Hi All,I have created one package in SQL Server 2005 while Importing and Exporting and i have given the package name and selected "Do not store any senstive data".When i have opened this in Intelligence Studio i am gettign error in destination connection that SQL is Lock.Please suggest, I am transferring Excel to SQL |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-24 : 10:07:04
|
| The text "error in destination connection that SQL is Lock" doesn't sound familiar, but I am assuming you are paraphrasing. It helps to post the exact error message. Nonetheless, getting an error message is expected. Because you did not store passwords (which is OK), you will now need to open the conenction Managers node in BIDs and give the password/username to each connection that needs it so the connection(s) can be established. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
SSIS Package