Calling a DTS standard task/custom task from a T-SQL Stored procedure 
Author Message
 Calling a DTS standard task/custom task from a T-SQL Stored procedure
Is it possible to call a DTS standard task or a custom task from a
T-SQL stored procedure as a OLE stored procedure. If so can you please
point me to some sample of calling a DTS task from a OLE stored proc.
I am not keen on running a package from T-SQL which I can imagine can
be done from xp_commandshell calling DTSrun. I am wondering is it
possible to call just a DTS task from OLE stored proc.

Thanks
Belinda



Sat, 16 Jul 2005 20:05:12 GMT
 Calling a DTS standard task/custom task from a T-SQL Stored procedure



Quote:
>Is it possible to call a DTS standard task or a custom task from a
>T-SQL stored procedure as a OLE stored procedure. If so can you please
>point me to some sample of calling a DTS task from a OLE stored proc.
>I am not keen on running a package from T-SQL which I can imagine can
>be done from xp_commandshell calling DTSrun. I am wondering is it
>possible to call just a DTS task from OLE stored proc.

>Thanks
>Belinda

You can call a package from OLE, but tasks cannot be used on their own.
You could build the entire package dynamically in memory through OLE
calls, but it would be messy to code. It only needs to be a simple
package with a single step to host a single task task. Set task
properties etc then execute the package.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com



Sun, 17 Jul 2005 01:09:01 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DTS Custom task in C# and threading model of DTS C# custom tasks

2. Error Assigning Task object to Custom Task object while calling DTS APIs in VB.NET

3. Using a Dynamic Properties Task to set a Custom Task in DTS

4. Calling a DTS Custom task from a VB Program - Executable or VB Script

5. DTS Transform Data Task fails in job where DTS Execute SQL Task does not

6. Returning an error from a DTS Execute SQL Task calling a Stored P rocedure

7. Output parameter not listed for Execute SQL task that calls stored procedure

8. dts SQL task executing stored procedure

9. Register DTS custom task without DTS Designer

10. documenting TSQL code from DTS exec SQL tasks?

11. calling procedure with parameters from DTS/ActiveX task


 
Powered by phpBB® Forum Software