Friday, March 9, 2012

how to create a DTS with parameters and call it fom a SP with the associeted paramete

Hi,
I've create a DTS package with 2 global parameters, I need to call this DTS
from a Store Procedure and pass the 2 parameters.
How Can I do that in T-SQL ?
If it's not possible, what I want to do is the following :
Copy data (with a date filter) from one table to another (on another SQL
server) in T-SQL. Is there a way to do that in TSQL ?
Thanks for your help,
H. MAILLARD.You can execute DTSRUN via xp_cmdshell or use the sp_OA* procs to execute a
DTS package from Transact-SQL. See http://www.sqldts.com/default.aspx?210.
Hope this helps.
Dan Guzman
SQL Server MVP
"Herve MAILLARD" <rvmaillard@.newsgroup.nospam> wrote in message
news:%237V6QFzHFHA.1860@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I've create a DTS package with 2 global parameters, I need to call this
> DTS
> from a Store Procedure and pass the 2 parameters.
> How Can I do that in T-SQL ?
> If it's not possible, what I want to do is the following :
> Copy data (with a date filter) from one table to another (on another SQL
> server) in T-SQL. Is there a way to do that in TSQL ?
>
> Thanks for your help,
> H. MAILLARD.
>
>

No comments:

Post a Comment