Globar Variable in DTS:: Urgent

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)

Globar Variable in DTS:: Urgent

Author

Topic

chandanmathur
Starting Member

1 Post

Posted - 2007-12-31 : 09:23:30

I am creating a DTS Package to copy data from text file to table, and result along with time etc has to entered in a log table created by me.

I am trying to use Global Variables for the same.. I have set the value of the global variable by going into Package Properties, but when I try to use the variable as:

update Employee_Logtable
set End_DT = getdate () ,
No_of_Rows_Loaded_by_Package = (select count (*)
from Employee_Description ) ,
Status_Message='successfull loading'
where Name_Package= ?

it is not substituting the value of ? to the global variable..

(I want something like this:

update Employee_Logtable
set End_DT = getdate () ,
No_of_Rows_Loaded_by_Package = (select count (*)
from Employee_Description ) ,
Status_Message='successfull loading'
where Name_Package= <<<MY GLOBAL VARIABLE>>>

)

I am a new user in DTS.

Can anyone please help me out. Its urgent.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2007-12-31 : 09:36:29

Did you map the global variable correctly to parameter value in Input parameters tab? what was the error you got?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources