SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Execute SQL Task
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

9 Posts

Posted - 10/19/2013 :  19:48:45  Show Profile  Reply with Quote
New to SSIS.

I imported data from 3 sources(XML,OLED-DB&Excel)into OLE-DB destination, Now how do I go about moving the same data into a Staging Table to perform error handling.

I dragged the Execute Sql Task &DFT in control flow.Then EXcel Source,Data conversion& OleDB destination in DFT. What is confusing me is that I have a connection type (OLEDB),created a database for my Staging Table and a SQL statement "Delete from (Table Name).When I execute this, no data goes to staging table and data in Source table gets deleted .I get this error, which i fail to figure what I am missing.

[Execute SQL Task] Error: Executing the query "Excel_Mortgage_Borrower"
failed with the following error: "Could not find stored procedure 'Excel_Mortgage_Borrower'.".
ossible failure reasons: Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.

I am using BIDS 2008. I cant find a solution in google. Anyone with a link on how to import data to a staging table. Is it OK to just import data from one database to another WITHOUT using Execute Sql Task

Noreen sithole

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 10/20/2013 :  03:20:29  Show Profile  Reply with Quote
to import data to table inside execute sql task just use query like

INSERT StagingTable
FROM SourceTable

to insert from Excel you need to use distributed query methods like OPENROWSET
the error looks like you dont have stored procedure created in the database used in connection or you're using wrong connection parameters

SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000