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 - 2001-09-21 : 10:11:35
|
| SamHS writes "Can you explain/enlighten me as to how I might go about accessing and executing my Stored Procs in DTS. I'm using SQL Server 2K, running on Windows 2000 Server - and need a one button does all solution for a series of data transformations. As I understand it, I can't use 'GO' in a proc, so thought DTS would be an ideal way to automate transfer in, manipulation, then transfer out of large amounts of data. I already have 12 DTS packages - each specifically dealing with transferring one type of data in, then a further 8 USPs to integrate the data and create the corerct tables, and I want to link it all together into one DTS so only one packages needs to be executed for the whole lot to trundle through. Please also bear in mind that these things have to happen in a specific order - so being able to establish dependancies is important.Thanks - and do I win dome merchandise now?SamHS" |
|
|
|
|
|
Executing a USP in DTS