DTS LoadFromStorageFile in ActiveXScript Task -
12-07-2004
, 01:11 PM
I have the following code in an active x script:
Dim oPkg
Dim UncFile
UncFile = " F:\Traverse\GetAndLoadFile.dts"
Set oPkg = CreateObject("DTS.Package")
oPkg.LoadFromStorageFile UncFile , ""
There is no password on the package
I have verified that the package exists at the file path on the server that
the code is running from
I recieve the following Error:
---------------------------
Package Error
---------------------------
Error Source : Microsoft Data Transformation Services (DTS) Package
Error Description : The filename, directory name, or volume label syntax is
incorrect.
The filename, directory name, or volume label syntax is incorrect.
---------------------------
OK
---------------------------
If I change the UncPath to a UNC Path : "\\Server\Share\package.dts"
I recieve the following :
---------------------------
Package Error
---------------------------
Error Source : Microsoft Data Transformation Services (DTS) Package
Error Description : The system cannot find the path specified.
The system cannot find the path specified.
---------------------------
OK
---------------------------
Does anyone have any ideas of a workaround for this? I can't use Execute
package because I need to set innerpackages variable dynamicly and I'm
calling the same package multiple times in parallel |