dbTalk Databases Forums  

DTS LoadFromStorageFile in ActiveXScript Task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS LoadFromStorageFile in ActiveXScript Task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jason Horner
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.