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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  I can't map a global variable with a query output

Author  Topic  bagha Starting Member 5 Posts Posted - 2005-06-17 : 15:01:23 Here's my problem : My DTS was working fine. But now I added one more step and it stopped working. I added an 'Execute SQL Task'(Task1) in my DTS. The SQL query in 'Task1' is a simple one, like : Select count(*) as MCount From Table1 Now all I want to hold the value of MCount in a global variable(say gv1) in my DTS. I mapped the output parameter 'MCount' with 'gv1' and selected the output parameter type as 'Row Value'. All other steps are running fine but at this particular step I'm getting an error saying : Global variable '3' was not found. (Note : The no. of rows in Table1 is 3. If no. of rows changes in Table1,the messgae will change accordingly showing that number instead of 3) Please help.