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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics