What's the equivalent "Multiphase Data Pump" in SSIS?

Question

What's the equivalent "Multiphase Data Pump" in SSIS?

previn1980

Old Hand

Points: 379
More actions
November 4, 2014 at 6:37 am

#312682

hi to all
I'm migrating a package from DTS to SSIS 2005.
A DTS package performs a data transfer from source file to destination table.
Precisely, this data transfer is implemented with a Multiphase Data Pump through an ActiveX script Task.
The activeX script Task has the following form:
Function PreSourceMain()
--INIZIALIZE VARIABLES
PreSourceMain = DTSTransformstat_OK
End Function
Function Main()
-- TRANSFORM DATA
Main = DTSTransformStat_OK
End Function
Function TransFailureMain()
-- DO SOMETHING
TransFailureMain = DTSTransformstat_OK
End Function
Function InsertSuccessMain()
-- DO SOMETHING
InsertSuccessMain = DTSTransformstat_OK
End Function
Function InsertFailureMain()
-- DO SOMETHING
InsertFailureMain = DTSTransformstat_OK
End Function
Function BatchCompleteMain()
-- DO SOMETHING
BatchCompleteMain = DTSTransformstat_OK
End Function
Function PumpCompleteMain()
-- DO SOMETHING
PumpCompleteMain = DTSTransformstat_OK
End Function
Function PostSourceMain()
-- DO SOMETHING
PostSourceMain = DTSTransformstat_OK
End Function
Please, can anyone tell me how to realize this (multiphase data pump) in SSIS.
Thanks in advance.

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

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

Phil Parkin SSC Guru Points: 246723 More actions · Answer 1

Via a dataflow, but the structure is quite different from DTS, so you've got a bit of a learning curve.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

previn1980 Old Hand Points: 379 More actions · Answer 2

thanks phil

yes, also I think that the DFT is better solution, but what do we use in the DFT to realize "Multiphase Data Pump"?

Do we need of other tasks (if yes, what ones) between source and destination task?

Derived Column Transformation task is necessary to performs transformation on input record, but the other phase, for example , Pre Source Phase, Post Row Transform Phase and so on.

thanks.

Phil Parkin SSC Guru Points: 246723 More actions · Answer 3

previn1980 (11/4/2014)
thanks phil
yes, also I think that the DFT is better solution, but what do we use in the DFT to realize "Multiphase Data Pump"?
Do we need of other tasks (if yes, what ones) between source and destination task?
Derived Column Transformation task is necessary to performs transformation on input record, but the other phase, for example , Pre Source Phase, Post Row Transform Phase and so on.
thanks.

It's a good question, and I'm not sure that there is a quick answer, because your question is so broad in scope.

Perhaps you could mention some specific tasks within the different areas? And then people here will be able to suggest how those things would best be implemented in SSIS. The products are so different that there isn't really a direct mapping from one to the other.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

previn1980 Old Hand Points: 379 More actions · Answer 4

phil, you are right but I was hoping that anyone here in the forums has had the same problem and he can help me in a more precisely way.

However I think that is very difficult to find anyone who had this problem and resolved it.