I want to run a DTS package in T-SQL
Posted on 2006-05-19
Okay all, I'm pretty dense with SQL Server (2000) outside of just regular T-SQL for select, inserts, updates, etc. I've done some stuff using cursors (wowee!) and have created tables, etc., but all this other stuff like creating and scheduling jobs, MTS, DTS, whatnot.
I am working on a conversion process to bring some data from Excel into SQL Server. I have struggled through help files, etc., enough to local DTS package (ConvertFTEPositions) that does the conversion.
I have a T-SQL procedure I run after the DTS package that goes through and does a lot of work with the data that was just loaded. It is an ongoing process. Is there some way (and I need specifics) to execute the DTS package from within the stored procedure. Will the execution of the package be synchronous? In other words, I want to wait until execution of the package finishes before continuing with the steps in the procedure?
p.s. I'm sure it is a simple question for some of you experts, but for me it might as well be on how to drill for oil on the moon. Lots of points up for grabs.