I am very new to the SQL 2000 package and would like some help with DTS.

Can I use Stored Procedures and, if so, how?

I created DTS package, added a SQL connection and added an Execute SQL Task,
but the only thing listed are tables and views.

Thx

In the Exec SQL Task just type in the code to execute the procedure, e.g.

EXEC dbo.MyProc @Fred='Whatever'


--
Darren Green
http://www.sqldts.com

"Billy" <Billy (AT) discussions (DOT) microsoft.com> wrote