How can use mapping in SSIS using Script in SSIS

Question

How can use mapping in SSIS using Script in SSIS

Dicha

SSC Enthusiast

Points: 178
More actions
May 16, 2007 at 4:08 am

#120019

This example i have in my DTS package..
Function Main()
DTSDestination("DATA")=YEAR(DATE) & "-" & RIGHT("0" & TRIM(CSTR(MONTH(DATE))), 2) & "-" & RIGHT("0" & TRIM(CSTR(DAY(DATE))), 2)
DTSDestination("BDNCAR") = DTSSource("BDNCAR")
DTSDestination("BDSITU") = DTSSource("BDSITU")
DTSDestination("BDMSIT") = DTSSource("BDMSIT")
DTSDestination("BDDTEM") = DTSSource("BDDTEM")
DTSDestination("BDDTEX") = DTSSource("BDDTEX")
DTSDestination("BDDTUU") = DTSSource("BDDTUU")
DTSDestination("BDDSIT") = DTSSource("BDDSIT")
DTSDestination("BDNVUS") = DTSSource("BDNVUS")
DTSDestination("BDNOM1") = DTSSource("BDNOM1")
DTSDestination("BDRCLI") = DTSSource("BDRCLI")
DTSDestination("BDNCLI") = DTSSource("BDNCLI")
DTSDestination("BDNATR") = DTSSource("BDNATR")
DTSDestination("BDNSEQ") = DTSSource("BDNSEQ")
DTSDestination("BDRCAR") = DTSSource("BDRCAR")
DTSDestination("BDMOED") = DTSSource("BDMOED")
DTSDestination("BDTANU") = DTSSource("BDTANU")
DTSDestination("BDANUI") = DTSSource("BDANUI")
DTSDestination("BDTEMI") = DTSSource("BDTEMI")
DTSDestination("BDCCAS") = DTSSource("BDCCAS")
DTSDestination("CMBDCLCP") = DTSSource("CMBDCLCP")
DTSDestination("BDCPRD") = DTSSource("BDCPRD")
DTSDestination("BDCCPR") = DTSSource("BDCCPR")
Main = DTSTransformStat_OK
End Function
I have to change and remake this package(dts) using SSIS package..pLease can any one tel me how can i solve this problem.
how can i create this kind of mapping in my SSIS project??
thank you dilsa

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

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

Tim Mitchell SSCoach Points: 15685 More actions · Answer 1

Dilsa,

It looks like this is a fairly simple mapping, with only the first value requiring any manipulation before going to the destination. I would use a Derived Column task to send the new value you call "DATA" to the destination. You don't need to script this kind of task in SSIS.

hth

Tim

Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices

mp83399 SSC Journeyman Points: 86 More actions · Answer 2

Yes very true......

This seems to be a like a very simple mapping. Just create a DataFlow task. Define a source and a destination and have a derived col transform in between. On the dest connection, map based on the specs you have in the old DTS package.