In the past, when faced with this problem, I "chunked" the ttransmission. I wrote a front end procedure that first populated a small table consisting of key ranges only. The...

This Activex task script calls a child package, passing it the parent package's Global Variable. This worked. I don't see why you can't reverse the flow and get the child package's global variable...

I got this some time ago from this site:

Calculating distance between 2 points

Posted 2/16/2006 10:29:00 PM   David A. Long (Andy)

You can try to convert your Declinations into...

Sometimes I have not been able to run the DTS packages via OA_; sometimes it stopped working in production; I looked and looked and could never find the problem; finally...

Yes, please post the calling sequence. There is probably a discrepancy between the parameters in the call and in the SP.

Also review the following, especially the comments by LS

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=232301

Thank you for taking the time to help the rest of us.

Hector, I did not understand your post. You said that you had found a VB script that scripts out all DTS packages into a text file, but what you posted...

Thanks, Greg, the answers in the suggested thread,  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=232301, were very enlightening. I especially appreciated Jeet's stored proc that runs a package. But LS hit it on the nose,...

Thanks for the suggestion. I tried it but it seems that our system generates a new GUID each time we schedule a package. In the job comments it said that...

Thanks for sharing with us!

I am doing this as we speak. Not knowing a better way, I converted all the packages to .BAS files (Package.Save As, then in the Save DTS Package dialog, select Visual...

Thanks for your input, Jeff. I will begin working on this and will post a reply when I get it working. It might be a few days, but it's worth...

Thanks, Minh; I've been working on this. I ran the following in QA:

DECLARE @TARGETDIR varchar(1000)

SET  @TARGETDIR = '\\Plads15\Users\Curbina1\SQL\DTS\KONA\'

SELECT distinct 

 'exec master..xp_cmdshell '+'DTSRUN.EXE /S '

 + CONVERT(varchar(200), SERVERPROPERTY('servername'))

 + ' /E '...

I posted a reply, but I don't see it.