Hi
I'm calling a DTS package from a VB application and about every 1 run
in 4 it fails with the follwoing message "-2147467259 - Connection
failure has Occurred in LoadTables"
The steps to run are as follows

From the VB application

deConnection.sp_rundts_package

Stored procedure does

EXEC Master.dbo.xp_cmdshell "DTSRUN /S /E /N Loadalltables_ECD_DEV"


Works some of the time but not always....Anyone got any ideas?

The connections is done as below (where sServer and sDB just give
database location/name from an INI file)

sConnect = "Data Source="
sConnect = sConnect & sServer & ";Integrated Security = SSPI;Initial
Catalog="
sConnect = sConnect & sDB
deConnection.Connection_Asb.ConnectionString = sConnect
deConnection.Connection_Asb.CommandTimeout = 3600
deConnection.Connection_Asb.ConnectionTimeout = 3600
deConnection.Connection_Asb.Open

Cheers
Shaun

What does the package log say?

"shaun" <shaun (AT) paradisii (DOT) co.uk> wrote