global variable not working

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

on my company's developement sql server, I created a DTS package with a
global variable. Then from an ASP page I pass a value to a stored procedure
which sets a global variable in the DTS package and then the stored procedure
executes the DTS package. It all works on the development server! The
problem I am having is that I have moved the DTS package up to our Test sql
server and tried running it again but for some reason it is not working.
Either the gobal variable is not getting set or I am not able to read it?
When I do try to read the global variable, I just get the default value that
I specify when I created it - not the value that I am passing to the stored
procedure. All of the code is exactly the same - I have changed nothing!! I
am working with our DBA on this but haven't been able to figure out why this
is not working. Does anyone have any ideas?? Is there some setting in SQL
Server that needs to be set??

thanks
Kurt
.

Relevant Pages

  • RE: Multiple loops in one package?
    ... this is not currently support in SQL 2000 DTS package. ... | I know how to loop through one set, but wasn't sure if there was an easy ... | Get next server from Server recordset --a ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Packages fail when executed from Jobs
    ... I have tried running the DTS package on the server whilst logged on as the ... DTSRUN.EXE or through the SQL Server Enterprise Manager. ... >> I am having trouble executing a DTS package from a SQL Job. ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS, .NET and remote servers
    ... Server A is running SQL 2000 and in domain X ... Server B is running IIS and host web-sevvice, ... I wish my web-service to trigger a DTS import on server A. The ... demonstrating the DTS package is loaded and accessible on Server B). ...
    (microsoft.public.sqlserver.dts)
  • Global Variable - Output Parameter not returning value
    ... I have SQL 2000 DTS package transfers data from one server to another ... In output parameter i have created Global variable with output parameter ...
    (microsoft.public.sqlserver.dts)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)