DTSDestination("DATA")=DTSGlobalVariables("iMes").Value how can i change in SSIS

Question

DTSDestination("DATA")=DTSGlobalVariables("iMes").Value how can i change in SSIS

Dicha

SSC Enthusiast

Points: 178
More actions
May 14, 2007 at 6:47 am

#174333

i am having variable iMes
I have a data flow diagram with Datareader Source n oledb Destination.
Oledb have output column date ..And in data reader i dont have this column.
i have too add result to date from variable
in dts its like this
DTSDestination("DATA")=DTSGlobalVariables("iMes").Value
how can i write script in SSIS to use this function..
than you
dilsa

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Robert W Marda SSChampion Points: 13413 More actions · Answer 1

I doubt I have the complete answer for you but believe that you'll have your best luck in creating the column you say doesn't exist by using the data flow component Derived Column. I looked in there and it does allow you access to package variables. You might want to look at it. I haven't really used the Derived Column component but have read about it and it seems that it should be able to create missing columns for you.

Another thing I have learned is that if you do want to use DTSGlobalVariables("iMes").Value and find a place to use it then it would be this in SSIS:

Dts.Variables("iMes").Value

I hope some of this helps to point you in the right direction to find the solution you need.

Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems

Dicha SSC Enthusiast Points: 178 More actions · Answer 2

hi

thanks for reply..I found a solution. I have add Script Component..There i can add new output row ..

From the result of variable i add to new output result.

eg

Dim

myIntegerVariableValue As String = Me.Variables.iMes

Row.date1 = myIntegerVariableValue

thanks

take care

Francisco Rodriguez-252375 SSC Enthusiast Points: 162 More actions · Answer 3

Hi, paws.

I'm starting the conversion from SQL Server 2000 DTS to SQL Server 2005 DTSX.

So, as you can suppose, I got to the Scripting Conversion step.

So, I'd like to ask you, where can I find the corresponding values for the DTS variables and constants ?

I've found (in your blog, of course), that DTSGlobalVariables were substituted by Dts.Variables (i.e. DTSGlobalVariables("iMes").Value == Dts.Variables("iMes").Value == Me.Variables.iMes, by the way, which one is better ?)

But this are not the only to be changed ..

What about the return codes ?

How do you handle this ?

Can you help me ?

Do you know where could I find a tutorial for scripting the new DTS ?

Thanks a lot.

BR,