What's the equivalent "Multiphase Data Pump" SSIS

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources