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