Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-28 : 09:38:10
|
Colm writes "Hi All,
I need help with Global Variables when running a DTS Package server-side. I AM USING SQL SERVER 7.0.
I have currently designed a DTS package (which works) and have
successfully run it in the context of my machine. I.E. I press the play button within the package editor and it accesses files on my C: drive.
The next step is to perform a scheduled run which places it in the context of the server. (I am referring to the development server, I am no where near the live server yet).
I have changed all my file references to point to Server locations. (Not my C: drive).
This is when I get problems. My package uses Global Variables which work fine when running on my machine but the global variables do not seem to work when I run the package on the server.
My package is made up from 7 steps, some ActiveX scripts, some data sources and destinations and transformations.
The first ActiveX script runs a stored proc on the server which returns a value which I store in Global Variables.
A Transformation takes place and counts accepted/rejected records and places these in Global Variables.
The second ActiveX script needs to pass these totals to a stored proc and hence obtains them from the Global Variables.
Problem is that the Global Variables lose their settings at some point and the values seem to have gone when I need to access them. DTS thinks they store NOTHING.
Does anyone know of any settings that I need to change or bugs that I may have encrouched on.
I REPEAT THIS PACKAGE WORKS COMPLETELY AS IT SHOULD WHEN RUN IN THE CONTECT OF MY MACHINE. GLOBAL VARIABLES ARE HAPPILY STORED UNTIL LATER USE.
Any help would be a great benefit.
Regards Colm Bannigan." |
|
|
|
|
|
Promoting DTS packages to a server and Global Variables stop working