Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 What's the equivalent "Multiphase Data Pump" SSIS
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dancko
Starting Member

Italy
1 Posts

Posted - 11/24/2014 :  04:53:47  Show Profile  Reply with Quote
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.

Edited by - dancko on 11/24/2014 05:21:03

gbritton
Flowing Fount of Yak Knowledge

2780 Posts

Posted - 11/24/2014 :  09:20:59  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000