February 5, 2004 at 10:03 am
Hi All,
I have created a DTS package(PKG) on SERVER A,
That PKG does -> downloads the file from FTP, save to local directory,change the extension,copy the data to a table,move the file to repository directory,format the data in a table.
It has global variables called,
LOCAL_DIR,FILE_NAME,REP_DIR,SCRIPT_DIR.
It is working on SERVER A but when i tried to execute that from SERVER B giving the error.
I have created a SP on SERVER B
in put parameters
LOCAL_DIR,FILE_NAME,REP_DIR,SCRIPT_DIR
When execute the SP giving the following error
DTSRun OnError: DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Disk not ready
Error on Line 10
CODE GETTING ERROR IS
LINE 9: Set obj = CreateObject("Scripting.FileSystemObject")
LINE 10: Set TextWriter = objFSO.CreateTextFile(DTSGlobalVariables("FILE_NAME").Value)
Any ideas?. Thanks in advance.
February 6, 2004 at 10:10 am
sounds to me like the environments in server A and server B are slightly different. Are you specifying the full filename including drive letter and path in your filename?
Do both servers have that driveletter available?
February 6, 2004 at 10:16 am
Yes, I am specifying the full path, but there is no Drive letter on server B that I am specifying.
February 9, 2004 at 12:38 pm
Hello S.
Just an observation but shouldn't Line 10 read:
Set TextWriter = obj.CreateTextFile(...
NOT objFSO?
Other Than that, your GlobalVariable drive or file name must NOT Exist.
RobbieD
Sunny Times....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply