SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

nsithole
Starting Member

USA
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

visakh16
Very Important crosS Applying yaK Herder

India
52309 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
SELECT *
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
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
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