Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 firing a data transformation service repository package from a stored procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-14 : 13:01:00
david writes "hi!
how can I fire a data transformation service repository package from a stored procedure? this particular package ftps an excel file across the wan, drops a table, and imports the excel to the file, and then hits a web url to tell my web app to get the latest data.

so i have the entire process automated, the client handles it all, EXCEPT that I have to run the DTS package every week?

can anyone help me fire a data transformation service repository package from a stored procedure?

thanks,
david"
   

- Advertisement -