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 |
|
murrayb3024
Yak Posting Veteran
79 Posts |
 Posted - 2005-03-24 : 15:53:18
|
| I went out to SQLDTS web site and read the article on Looping in a DTS package. I took the sample they had out there, and implemented it into a package I am building. I finally got that working. My problem is that in another package I built I would run a Stored Procedure before finishing that would Delete out records based on some criteria. When I try to add the Execute SQL Task into the loop it doesn't run. I get the following error:Cannot execute a Select QueryI am able to run in this same stored procedure in 3 other packages, just not this one. Is there something I am missing? |
|
|
murrayb3024
Yak Posting Veteran
79 Posts |
Posted - 2005-03-24 : 16:59:37
|
| Nevermind, I was using the wrong connection in it. |
 |
|
|
|
|
|
Problem running a SP in a Loop...