October 26, 2010 at 10:18 am
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!
October 26, 2010 at 10:22 am
Do you have Integration Services running on your computer? You need it to run SSIS packages on your computer.
Also, try running DTExecUI. You can use it to build the command line text for you.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 10:35 am
yes I do...and I get this far with dtexecui...
dtexec /f "C:\Documents and Settings\user\My Documents\Visual Studio 2008\Projects\Daily Update\Daily Update\EMS_SCORECARD_Daily Pull v4.dtsx"
If I dump that on a cmd line..it just opens my VS BIDS...??..asking for the package password...??
if I give it the package password..it just opens into the desktop visual editor...??
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply