Run DTS package from Access form

[jbphoenix]

I'm trying to run a dts package from an access form. Here is the code I have but i'm getting an error.

Dim dtsPackage As New DTS.Package
dtsPackage.LoadFromStorageFile "C:\POS.dtsx", ""
dtsPackage.Execute

Run-Time error -2147220220 (80040504) The Specified file is not a Package Storage File.

 

[SQL_Hell]

Hi there

.dtsx is a SSIS package not a DTS package, far easier to put the DTS / SSIS in a job and run sp_start_job instead