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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-20 : 08:16:58
|
| Tom writes "I'm using SQL7 and this is my first DTS Package. I have eight years experience with Access VBA, two years with T-SQL and 2 days with DTS and VB Script. My question...Can I call a stored procedure from a DTS Package, if so how? I want to include a sequential Batch No in each import I've written the stored procedure that will increment a counter that is saved. I would like to call it and get the next value at the appropriate time.OR... Am I approaching this backwards, Should the stored procedure call the DTS package passing the Batch No as a parameter?Any input appreciated.Thanks MuchTom" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-01-20 : 10:55:12
|
| You're going about it the right way. You can call a sp with DTS, use the 'execute sql' task.Jonathan{0} |
 |
|
|
|
|
|
Using Stored Procedure in DTS Package