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 |
|
dlorenc
Posting Yak Master
172 Posts |
 Posted - 2010-10-25 : 19:26:46
|
| my .dtsx job goes across multiple corporate databases using the connection manager. as one of these databases using a sql server ID, I have the package passworded to the same password as this one database userID...this seems to get me over the ID password problem...now I would like to use my xp scheduler to run the job...(it is a bit of a pain to have my corporate DBAs' work thru the permissions across multiple databases and use one of the sql servers' scheduler...seems easier to do it myself (as my AD ID has all the permissions except this one database with the password...)...sooo... what is the correct dtexec commands to execute my .dtsx job?I started with 'dtexec /f "C:\Documents and Settings\My Documents\Visual Studio 2005\Projects\Daily Pull v4.dtsx"this just opens up studio (BIDS) and asks for the password...I tried adding the /P thepassword /U myloginnameonmymachine... didnt seem to work....??thanks for the help! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-25 : 21:28:29
|
| create a sql agent job of type ssis pkg, then right click it and script as create.that will show u the exact command with the correct switches. |
 |
|
|
dlorenc
Posting Yak Master
172 Posts |
Posted - 2010-10-26 : 10:34:33
|
| patience, please...1. As I am not a DBA on our enterprise systems, I do not have access to the sql server agent folder in SSMS when I open the server/databases involved...2. thinking I just needed to script it, I tried pointing SSMS to my local sql server...I still dont see the sql server agent options..?..3. What I do see in the object explorer is: Server; Databases;Security;Server Objects; Replication;Management (in mgmt are sql server logs and legacy))what am I missing? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-28 : 00:21:29
|
| ok, to the 1st post, you should remove the /p /u switches. unless the package is protected by sql authentication.what protection level did u use in the package? it should be "Storage"if you're manipulating data this should be passed on to the DBAs to deploy in most companies.Oh, what error message are u getting? |
|
|
|
|
|
|
.dtsx running as scheduled job in Windows Schedule