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)
 How to call Stored Procedure in DTS

Author  Topic 

ammy
Starting Member

7 Posts

Posted - 2005-05-30 : 06:33:36
hi all
anybody knows how to call the stored procedure in DTS from SQL Server Database?
or
how to create package for the calling the stored procedure?

ammy

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-05-30 : 06:44:08
The SQL task, or Execute SQL task, something like that.



Damian
Ita erat quando hic adveni.
Go to Top of Page

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2005-05-30 : 06:44:35
You can execute a stored procedure using the Execute SQL Task. What are you trying to do?

Mark
Go to Top of Page

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2005-05-30 : 06:45:36
Well sniped Merkin!

Mark
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-05-30 : 06:58:22


5 Years of practice


Damian
Ita erat quando hic adveni.
Go to Top of Page

ammy
Starting Member

7 Posts

Posted - 2005-05-30 : 08:57:01
Hi Mark
Actually i want to used my user defined function in stored procedure

thanks for the reply
ammy
Go to Top of Page
   

- Advertisement -