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 |
|
gkrasny
Starting Member
2 Posts |
 Posted - 2008-02-18 : 09:48:39
|
| Hi, i am having a problem when i tried to execute a SSIS package from a job in sql server 2005First of all, when i create a new connection in the designer, i complete with server, user and password, and test connecion succesfull.Then, i execute all the package and it works fine.After building it, i tried tu execute the package using the file that it ve just been created into bin folder, but the connecttions didnt have the tag password, so after user id i add ;password=xxxx in every connection and it works fine. But every time i wantex to execute, i have to write the password.Also i tried openeing the text file that the DTS created, but when i open it again, the password wasnt there.Finally, i tried to create a job that execute this file, and i have to write the password as i did when i execute directly from the file, but i couldnt run. It has an authentication problem. If i open again the step configuracion, the password is not there. The same that happen every time, but now i can run the packageAny idea?Thanks a lot |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-18 : 13:04:44
|
| Possible to use windows authentication? Tried with package config file? |
 |
|
|
gkrasny
Starting Member
2 Posts |
Posted - 2008-02-26 : 12:10:04
|
| Its impossible to use windows authentication.i tried with package config file, but it didnt works or may be , i am doing something wrong.i create a new package config file por every connection, but it was the same. It always use the connection that i create using the wizard, and the package it was created, but nothing.It seems that i created, but something is missing so i can make the connection to use it and read the user, password, etc from there. |
|
|
|
|
|
|
|
|
SSIS Losing Password