January 3, 2003 at 8:08 am
I have created with Visual Basic 6 an executable file (.exe) that launch some DTS packages.
Every packages has 4 global variables.
The program .exe receives 4 parameter that they will come used in order to value the global variables of every packages.
When I used the program to launch the package into local machine it's all right.
When I used the program to lauch the package on the other server it goes in error.
In the window of the executable program it comes visualized the following error message:
ExecDTS | Run_DTS | Load Package : DTS_Imp_Instr_Main
ExecDTS | Run_DTS [PKG LoadFromSQLServer] | [ERROR] Error in load DTS
Package: DTS_Imp_Instr_Main , Server: 10.254.84.209\pippo002 , User:
pluto
ExecDTS | Run_DTS [PKG LoadFromSQLServer] | [ERROR] Object variable or With
block variable not set (x5B, 91)
Why?
Someone can to HELP me??
Thanks, thanks.....
Flavio
January 3, 2003 at 9:45 am
Are you loading from the same server in both cases? Perhaps the server side package is not accessing the same package. Are you hard coding the server name? Is it (local)?
Steve Jones
January 24, 2003 at 8:24 am
Have you ever visited Plant Source Code? Check out this link for something that might help you with this issue - http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=29526&lngWId=1&txtForceRefresh=124200310111533621.
It may ask you to register - it's free so go ahead and register and you'll have all the free source code you need. I personally have registered to both sites and find them both extensively useful.
CLK
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply