Stored Procedure Transformation functionality in SSIS

Home

Help

	Welcome, Guest. Please login or register. Did you miss your activation email?	July 31, 2010, 02:35:58 am
		Login with username, password and session length

Data Warehousing Community Forum > ETL Tools > DTS/SSIS > Topic: Stored Procedure Transformation functionality in SSIS

Pages: [1] Go Down

« previous next »

Author

Topic: Stored Procedure Transformation functionality in SSIS (Read 1510 times)

unknown

DW Apprentice

Reputation: +7/-0
Offline

Offline

Posts: 44

Stored Procedure Transformation functionality in SSIS

« on: January 10, 2008, 10:48:51 pm »

Hi,

Very new to SQL server Integration services and I worked with informatica earlier.

I have one simple question. In Informatica 7x, we are having a in-built External Procedure Transformation by which we can execute a procedure.

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

Please let me know.


	Logged

Thanks
Unknown

Whoever

Administrator

Reputation: +34/-0
Offline

Offline

Posts: 113

Forum Don

Re: Stored Procedure Transformation functionality in SSIS

« Reply #1 on: January 14, 2008, 11:10:49 am »

Quote from: unknown on January 10, 2008, 10:48:51 pm

External Stored Procedure Transformation (Informatica) in SSIS

SSIS treates Stored Procedures no different than any other query. It even lets you parametrize simple SQL queries.

You can use the "Execute SQL Task" to execute it as a part of the workflow.
Or the "OLE DB Command" transformation to execute it as a part of the data flow.

And yes, you can execute SP's and queries on any kind of RDBMS from SSIS as long as you have ODBC connectivity to it. Cool


	Logged

You don't get it. I built this place. Down here, I make the rules. Down here, I make the threats. Down here, I'm God.

Pages: [1] Go Up

Data Warehousing Community Forum > ETL Tools > DTS/SSIS > Topic: Stored Procedure Transformation functionality in SSIS

« previous next »

Jump to: