|
Title: Stored Procedure Transformation functionality in SSIS Post by: unknown 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. Title: Re: Stored Procedure Transformation functionality in SSIS Post by: Whoever on January 14, 2008, 11:10:49 am 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. 8) |