Each time I try to call another pkg the process fails.
I am using the following logic to call the next pkg.


' ============= Call another DTS pkg ==============
const DTSSQLStgFlag_UseTrustedConnection = 256

' == Call the pkg which will read each file and process it.
Set oPkg = CreateObject( "DTS.Package")
oPkg.LoadFromSQLServer
"PII350","","",DTSSQLStgFlag_UseTrustedConnection, "","","","IN_UPDATE_DAILYD
ATA_INPUT_FILES_tblRawDataTempHold"


Everything works fine until I add the line:


oPkg.LoadFromSQLServer
"PII350","","",DTSSQLStgFlag_UseTrustedConnection, "","","","IN_UPDATE_DAILYD
ATA_INPUT_FILES_tblRawDataTempHold"

Then the ActiveX script fails. What I am doing wrong? I've looked at the
LoadFromSQLServer line over and over and I cannot see any syntax errors.
Any ideas on how to troubleshoot this?

Change it to

oPkg.LoadFromSQLServer

"PII350",,,DTSSQLStgFlag_UseTrustedConnection,,,," IN_UPDATE_DAILYDATA_INPUT_
FILES_tblRawDataTempHold"



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Donald Pickering" <donpick1 (AT) hotmail (DOT) com> wrote

Thank you for your help.
I finally solved my problem. I had Option Explicit set and I didn't have a
variable dimensioned. I expected ActiveX to tell me if a variable wasn't
dim'd . Apparently it doesn't do that; it just fails.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote