I think you wont have any problems but of course always is good to have a backup of you DTS pkg.

Here is a good article about transfering DTS pkgs...you should...

kjackson in the msdb database you can find all information for a pkg.

Inside the pkg right click under properties also you can see some information Pkg GUID and version.

JFB

Yes Borisbase, you need to create multiple conections and run it in parallel.

Johnny

It's not a problem to rename tasks and steps but I think will be tedious to rename objects for a pkg with 30 o more steps...

Just an opinion.

Johnny

Just for information in DTSStep_DTSActiveScriptTask_1 is a propertie ExecutionTime make sure is zero.

Johnny...

Make sure you clean the objectc at the end before start using again.

Check this example

http://www.databasejournal.com/img/spExecutePKG.sql

Johnny...

This is what I found

Johnny....

The ActiveX Scripting Host, used by all tasks that have ActiveX script capability, may become unregistered. This can lead to one of the errors below:

"ActiveX Scripting...

Inside the pkg--> mouse right click -->Disconnected Edit-->Here is all the properties for the connection and for the steps, inside each connection you can find the time out propertie.

Johnny...

Here is a complete library

http://www.sqldts.com/default.aspx?6,105,225,0,1

Johnny

Here you have more resource in how to execute a pkg from ASP

http://www.sqldts.com/default.aspx?6,104,207,7,1

Have fun!!

Johnny

You can call pkg from a main pkg using activeXscrip

Johnny...

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

Dim oPkg

Set oPkg = CreateObject ("DTS.Package")

oPkg.LoadFromSQLServer "sqlServerName", "sa", "pwd", , , , , "Child Pkg"

oPkg.Execute

oPkg.Uninitialize()

Set...

Schedule a Pkg is an issue

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074

Also make sure you SQLagent has an administrator permission.

Johnny...

Yes, you can using the File Transfer Protocol Task or http://FTP.exe(check BOL for how to use FTP).

Johnny..

After you have the connection, here is an example in how to import range from excel using DTS

http://www.sqldts.com/default.aspx?6,101,243,0,1

Johnny...

Ok now I see what are you trying to do.

To track that you need to create a ActiveXscript task after the FTP task to check if files exist in the...