Wednesday, March 21, 2012

How can i achieve the functionality of External Procedure Transformation(Informatica) in SSIS

Hi,

I worked with informatica before and bit new to SSIS,

i have one simple question..

How can i achieve the same functionality as External Procedure Transformation (Informatica) in SSIS?

like..i want to use a DLL in my package which contains some set of business rules.

Please let me know.

Charles

Charles Luke wrote:

Hi,

I worked with informatica before and bit new to SSIS,

i have one simple question..

How can i achieve the same functionality as External Procedure Transformation (Informatica) in SSIS?

like..i want to use a DLL in my package which contains some set of business rules.

Please let me know.

Charles

Charles,

Its possible to build your own custom tasks and compoenents that implement whatever business rules you require. Go here in BOL for more info:

Integration Services Developer InfoCenter
(http://msdn2.microsoft.com/en-us/library/ms137709.aspx)

You may also wish to look at using the script component and script task. They also enable you to incorporate your own business rules however they are not as portable as custom tasks or custom components. But they ARE easier to build than custom tasks/components.

-Jamie

No comments:

Post a Comment