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 |
kshinningstr
Starting Member
24 Posts |
Posted - 2005-08-01 : 11:22:29
|
Hello Everyone! I am using DTS Package to load in data from txt file to staging tables. After the staging tables are loaded in, I need to fire of 6 stores procedures to generate other tables. How do I go about doing that? Should I create a trigger??Please Help...my project deadline is coming very soon.Thanks,Sherry |
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-08-01 : 11:50:01
|
Use a job? Make each one execute each?Personally I would create a stored procedure that uses xp_cmdsheel to execute a bcp to load stage, then execute all of the sprocs from within that stored procedure.You can also use an sql task in the DTS package and after succesful execution, just do EXEC SPROCNameBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
|
|