|
Home > Archive > MS SQL Server DTS > March 2006 > Calling the same stored proc multiple times to execute diff DTS Pk
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Calling the same stored proc multiple times to execute diff DTS Pk
|
|
| DeniseMe 2006-03-29, 8:27 pm |
| Hello!
I have a stored procedure (FL_LIGenerateNextPk
g) which I call to set the
global variables of a DTS Pkg and execute it (Pkg A). Pkg A then runs a
couple of stored procedures and after they have successfully completed, it
calls FL_LIGenerateNextPkg
again, passing different parameters to it to
execute a new pkg (Pkg B). Pkg B then does about the same thing and so on
and so forth for about 15 DTS pkgs get generated and executed. For some
reason this process is now just stopping without error at seemingly random
spots. I am wondering if this has something to do with the fact that I am
calling the same stored procedure so many times to generate different dts
pkgs from within the dts pkgs it generated the call before? Thoughts? Not
sure if I am thinking down the right path to correct this!
Thanks in advance,
Denise
| |
| DeniseMe 2006-03-30, 1:30 pm |
| Nevermind this post. I was not error handling properly and have figured out
why it was just seeming to "stop" with no error returned. Now that I have
got the error, I'll have to find a way to resolve that (which is just a space
issue, so shouldn't be a problem). Thanks Much! Denise
"DeniseMe" wrote:
> Hello!
>
> I have a stored procedure (FL_LIGenerateNextPk
g) which I call to set the
> global variables of a DTS Pkg and execute it (Pkg A). Pkg A then runs a
> couple of stored procedures and after they have successfully completed, it
> calls FL_LIGenerateNextPkg
again, passing different parameters to it to
> execute a new pkg (Pkg B). Pkg B then does about the same thing and so on
> and so forth for about 15 DTS pkgs get generated and executed. For some
> reason this process is now just stopping without error at seemingly random
> spots. I am wondering if this has something to do with the fact that I am
> calling the same stored procedure so many times to generate different dts
> pkgs from within the dts pkgs it generated the call before? Thoughts? Not
> sure if I am thinking down the right path to correct this!
>
> Thanks in advance,
> Denise
|
|
|
|
|