How can I:
1) Create a Job in 2005 to run my SSIS project? Specifically syntax and where I would place the all in the job's properties
2) Can I run an SSIS package from the command prompt? what would be the syntax
You should read BOL as it has extensive information on these topics.
1) ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/541ee5ac-2c9f-4b74-b4f0-13b7bd5920b0.htm
This is general info on agent and you would use the SSIS subsystem for running SSIS packages.
2) ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlcmpt9/html/89edab2d-fb38-4e86-a61e-38621a214154.htm
Matt
|||this is a dumb question but how do I run those paths to get to your URLs above?|||Open BOL and put the URL into the URL box.
No comments:
Post a Comment