July 1, 2009 at 3:59 am
hello everyone,
Im pretty new to SSIS and working on it from yesterday for ETL job. I have gone through the post ( http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspx?CommentPosted=true#commentmessage - thank you andy)and successfully completed update/insert. However using Ole Db Command doesnt guarantee performance when bulk updated. I have saw blogs discussing that we need to use Execute SQl task in conjunction with stag table to have a good boost in performance. I was trying to incorporate this Idea for delete and was trying to insert result of lookup in to temporary table (which i call stag table). However , Ole DB destination doesnt allow temporary table in the source drop down this is due to the fact the temp table are accessed only during that particular session. I have also set retainsameconnection and delay validation on connection manager. Im still out of luck to specify temp table as source for insert . Any help will be much appreciated..
July 1, 2009 at 9:52 am
A staging table is not a temporary table it is a permanent table which is used to get the data into the SQL Server database and then you use T-SQL to massage the data to fit the database design. AS you have found you cannot use a temporary table as destination in SSIS.
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 1, 2009 at 1:29 pm
hi jack,
At last I did create a table and used it.
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply