Hi Phil,

Great question. First off, I just wanted to say that there is nothing wrong with the staging table approach. I just wanted to point out that...

I have no experience w/ the Checksum Transformation, but you could accomplish the same thing with the SCD transformation or by using lookups. That is assuming that you could...

OK, that's what I was hoping! You've got 2 options here and I'll go through them both seperately.

Option #1: SSIS import to staging table w/ SP driven...

If it is row counts that you are concernted about, you could create an audit/history table of sorts that you can use to insert 1 row for each time your...

From what I'm hearing, doing all of your validations within the SSIS pipeline is what I would do. I am a bit confused though as to your concept of...

I don't have examples of existing documents that I can give you, but documenting a DR setup is not much different than documenting a setup for any other environment. ...

I hope that I'm not adding to your confusion, but keep in mind that SSIS is a full fledged ETL tool so you don't really need to load a staging...

Any time SSIS throws the Error: "Cannot convert between Unicode and Non-Unicode String data types", it means that the source and target datatype values are not the same. SSIS...

I'm having trouble following you as well. You'll need to tell us a bit more about what you are trying to do. How is the data being extracted...

Do you have Integration Services installed on the box that you're trying to schedule it on?

Can you elaborate on the file type? Is the file fixed length columns, comma delimited, etc?

Removing the primary key is definately NOT the answer here. The primary key is there to prevent you from being able to create duplicate rows. Removing it will...

I'm surprised that no replies have been generated by this yet. I guess, if nothing else, my reply will bump your thread so that it is active again. ...

You've got a Primary Key constraint on your table and you are attempting to import a duplicate key. Can you post your table DDL for dbo.ThomsonEDData?

You've posted this to a SQL Server 2000 forum so you'll be limited to SCOPE_IDENTITY(). If this were SQL Server 2005 or up, you could (and should due to...