check if table has records
My current ssis package will perform data transfer from Source A (Excel FILE) to Target Table B. I want the ssis package to check if Target Table B has any records that are
there in excel file as well; if no records, perform regular data transfer else perform data transfer for only those records that do not exists in Target Table B
Thanks & Regards, Bhavika
April 7th, 2011 2:24am
Use a lookup transformation with Excel data and Target table and Error output of lookup(Excel data which is not present in target table ) connect to destination .
hope this helps!!!!!!!Cheers, Shailesh
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2011 2:35am
Can you please elaborate on what you said . How to use Look up etc.. as i am new to SSIS. and even on the Error output thing. Thanks !!Thanks & Regards, Bhavika
April 7th, 2011 2:41am
Check
this . You can get many more on www.Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2011 2:54am
Search the WEB. There are even
video's available.
Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com
April 7th, 2011 3:03am
Step 1. Excel Source
Step 2 Use Lookup choose target table
Step 3 In lookup - > columns tab choos the primary key column.
Step 4 Go to configure error output -> choose error = ignore failure
Step 5 use conditional split - chooe the column--write condition like ISNULL([ID])
Stpe 6 use oledb destination choose the respective Precedence constraint.
/R.
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2011 3:11am
Step 1. Excel Source
Step 2 Use Lookup choose target table
Step 3 In lookup - > columns tab choos the primary key column.
Step 4 Go to configure error output -> choose error = ignore failure
Step 5 use conditional split - chooe the column--write condition like ISNULL([primary key column])
Stpe 6 use oledb destination choose the respective Precedence constraint.
/R.
April 7th, 2011 3:12am