Soe Tun

Execute SSIS Package from Stored Procedure with Parameters using DTEXEC Utility

How to execute a SSIS package from a Stored Procedure by passing in your own parameters for the SSIS package variables using DTEXEC utility.

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/ZwM

Posted On Wednesday, February 24, 2010 6:25 PM | Feedback (10) | Filed Under [ SSIS ]

Mapping Stored Procedure Parameters in SSIS OLE DB Source Editor

I was getting the following error

The SQL command requires a parameter named "@ParameterName", which is not found in the parameter mapping.

component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0207014.

EXEC [dbo].[uspGetWhereUsedProductID] ?, ?

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/XmZ

Posted On Thursday, March 05, 2009 4:20 PM | Feedback (86) | Filed Under [ SSIS ]