If your unsure which ones where deleted, then you cant delete them, ask for a full export every time, not just an incremental update, then you can just upload the...

Use a merge command, load the incremental data into a staging table the use merge to insert update or delete based on the unique column(s) of the row.

Poor Performing SQL Part 1 - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

Poor Performing SQL Part 2 - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Visio, Sybase Powerdesigner, sure if you do a search on Google (other search engines available) you will be able to find more.

Yeah you could look at the merge transformation data task to do what you need, but will have to ensure you handle the updates correctly.

Use linked servers

Either create a Link on destination to the source, or a Link on the source to the destination.

Then just change the srcipts to match.

If link done on the...

Use linked servers

Then you need to do a two stage approch, load new data using left outer join, then update anything where the data modified dont match.

For new rows

INSERT INTO DestinationDB.DestinationSchema.DestinationTable

SELECT

Source.Col1,

....

....

....

FROM

SourceDB.SourceSchema.SourceTable Source

LEFT...

But do you have anything which tells you when a row has been updated, or do you not bother about shipping over the updated rows?

Do you have any timestamp columns or something which identitifes when rows where updated, created etc?

Image stores the 16 byte pointer data in-row, the actual image data is farmed off to the the large object tree and the pointer details which pages make up the...

Duplicate post, all replies here please.

SQL has one built in, which you can get to by creating the database diagram in the database diagram under the database object in SSMS.

1 ForEach loop with 1 flat file connection, grabs the files from a sub folder, changes the connection string of the ffc at loop time.

The issue now comes down with...

Bhuvnesh (12/13/2012)

---

during my testing or learning on Full text search , i found below queries are returning different results .can you please guide me why

select [BusinessEntityID] , [Name] from...