July 21, 2008 at 10:12 am
I am importing an Excel spreadsheet into a SQL Server 2005 database using an SSIS package. I need to execute a stored procedure for each row in the spreadsheet as it is imported. Any thoughts?
July 21, 2008 at 10:37 am
You can use the Execute OLEDB Command to do this.
What are you doing in the stored procedure?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 21, 2008 at 10:43 am
I am passing a value from one of the Excel columns to a proc, and the proc will execute an API that will update another application.
July 21, 2008 at 10:53 am
It sounds like the OLE DB Command task it what you want then.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply