DTSDestination equivalent in SSIS??

Question

Post reply

DTSDestination equivalent in SSIS??

faridh_khan

SSC Enthusiast

Points: 169
More actions
September 22, 2008 at 8:33 am

#131379

Hi,
I want execute the below code in SSIS Activex Script.
*****************
VB SCRIPT Function
*****************
Function Main()
DTSDestination("DBName") = DTSGlobalVariables( "gvDBName" ).Value
DTSDestination("LastUpdate") = Now
Main = DTSTransformStat_OK
End Function
The SSIS Activex Script is not taking the "DTSDestination". Do we have any equivalent in SSIS. If not, what is the best way to execute the above.

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

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

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

You need to get some SSIS training. It is very different from SSIS. Pick up a book ASAP.

This should be done using a derived column transformation.

VG-619426 Hall of Fame Points: 3914 More actions · Answer 2

ActiveXscript task will be removed in future vesrsion. So, we have to use script component transformation. As suggested it is different than DTS versions.Its better read about it and proceed.

you need to assign global variable value to a local variable and then assign local variable value to column.

Dim sDBName as string = Me.variables.gvDBname

Row.DBName = sDBName

Row.LastUpdate = Getdate() ---Verify this.

VG

faridh_khan SSC Enthusiast Points: 169 More actions · Answer 3

Hi VG,

Thanks for the reply.

I tried with your code in the Script Task on SSIS.

Dim sDBName As String = Me.variables.gvDBname

Row.DBName = sDBName

Row.LastUpdate = Now()

I am getting error like "Name Row is not declared"

and "Variable is not a member of script task".

Do i need to add any Inheritance or any Override method.

Could you please give me the whole code .

VG-619426 Hall of Fame Points: 3914 More actions · Answer 4

Hi,

I don't have complete code for you...You need to read more on this..I can help...

Anyway, what you have ahead of script component, what is input to your script component ?

You need to have columns defined for script component , like source - > script component - > Destination.

Did you declare variables at the package level ? Also, in script transformation editor, you need to add your global ariables at readonly variables.

VG