July 17, 2007 at 1:19 pm
I would like to save/load a DTS package in a scheduled job into/from a structured storaged file.
Any input will be greatly appreciated.
July 17, 2007 at 2:13 pm
You can only execute a package in a job. Use DTSRun in a job step making sure you include the 'F' argument to specify the file path.
Ex: dtsrun /Ffilename /Npackage_name
Greg
Greg
July 17, 2007 at 11:59 pm
If the package has multiple versions you have to specify the version number tooo.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 18, 2007 at 11:47 am
The processes of saving/loading DTS packages can be easily carried out. What I would like to do are to schedule such saving/loading as scheduled jobs.
Thank you all for your kind inputs.
July 18, 2007 at 11:53 am
You will need to use VBSCRIPT and use DTS Object model to save/load the package. Use VBSCRIPT subsystem of SQLSERVERAGENT.
* Noel
July 18, 2007 at 2:36 pm
Sorry SQL ORACLE, I completely misunderstood your question! Luckily, Noel knows what your trying to do.
Greg
Greg
July 19, 2007 at 8:22 am
Noel,
Sounds interesting. Can you point us to where we can see some examples, articles, posts, etc. of this? Thanks.
July 19, 2007 at 9:25 am
Here is one link.
http://www.databasejournal.com/features/mssql/article.php/3417651
More inputs will be welcome.
July 19, 2007 at 11:01 am
Hey, Carlos!
What the oracle has done is point you to an example of using the COM for DTS packages. To understand this a little better, you might want to look at the msdn site.
http://msdn2.microsoft.com/en-US/library/aa176226(SQL.80).aspx
This location documents the whole mess that is DTS. (That mess which I so dearly love) The first link on the page goes right into the object model.
You might be able to do what you want directly in T-SQL using the OA_ procedures, but you're probably better of writing it outside of T-SQL in VB6.
Good luck!
jg
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy