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 2005 Forums  SSIS and Import/Export (2005)  DTS to SSIS

Author  Topic  e11icott Starting Member 1 Post Posted - 2009-08-17 : 09:41:30 Hello, I need to rewrite DTS package to SSIS. DTS has a Active x script part in some step. Could somebody help me how to rewrite this peace. What components to use and how to modify old code? Here is it: '********************************************************************** ' Visual Basic Transformation Script '************************************************************************ ' Copy each source column to the destination column Function Main() DTSDestination("DEPT_CODE") = DTSSource("dept") DTSDestination("DEPT_NAME") = DTSSource("dept_title") DTSDestination("STATUS_DATE") = "" If DTSSource("inactive") = 0 Then DTSDestination("ACTIVE_STATUS") = "Y" Else DTSDestination("ACTIVE_STATUS") = "N" End If DTSDestination("USER_NAME") = "FACTS1_USER" DTSDestination("MODIFICATION_DATE") = NOW() DTSDestination("DEVICE_NAME") = "DEVICE02" DTSDestination("FISCAL_YEAR") = DTSSource("fyear") DTSDestination("PERIOD") = "Q4YTD" Main = DTSTransformStat_OK End Function Thanks.