By design all views are being converted into tables in destination database during export wizard in sql server 2005. How can I deselect all views or ignore all views to be copied over since only tables copy is needed. When I try to deselect one view it deselect all of the objects in wizard? I would have been okay with views copy but problem is that it tries to create new tables with same name as already exists in destination database and there is where it fails. Any advice on it? Is it a bug? since it says "Choose one or more tables and views to copy --> but it does not give me option to do so. I can either select all of them or none.Frenk

Also, during merge , how would i avoid copying over duplicate records. In other words, Do not copy if same record exists in Destination table?Frenk

I see both tables and views in my data import export wizard and each item has a check-box along it which permits to select each individual one. If you do not see them, can you post a screenshot here?Arthur My Blog

A Data Import Export Wizard needs to run with the "Write a Query to Specify the Data Transfer" option in which you would need to use a join, a sub-query or a merge T-SQL statement to achieve the prevention of duplicates. Besides, since this is a SSIS forum, why don't you look into how we merge data using SSIS: http://www.sqlis.com/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspxArthur My Blog