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)
 What's the equivalent "Multiphase Data Pump" SSIS

Author  Topic 

dancko
Starting Member

1 Post

Posted - 2014-11-24 : 04:53:47
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.

And, especially, is it possible to realize (multiphase data pump) in SSIS.

Any suggestion or idea is very very appreciated!

Thanks in advance.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-24 : 09:20:59
There is no equivalent in SSIS and no need for it.

Rethink your problem and decide what you need to do (where does the data come from, where it is going, what do you need to do to it between source and destination?) Then we can help design a SSIS solution for it.
Go to Top of Page
   

- Advertisement -