Selected rows loading from source

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Selected rows loading from source

Author

Topic

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2010-03-30 : 08:16:59

I have a raw file, which contains 10 rows but i need to load only those rows which DON'T ALREADY EXIST in my target table ???

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2010-03-30 : 08:29:22

You probably want to read up on NOT EXISTS.

Here's a link which deals with the requirement you mention.
http://weblogs.sqlteam.com/peterl/archive/2009/06/12/Timings-of-different-techniques-for-finding-missing-records.aspx

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources