It is my understanding that when a UNION is performed between two SELECT statements, it's internally running a DISTINCT. Is this correct?

Yes Internally sql will only return Unique values.

From...

Look at the column mappings in your Data Transfer Task, are you mapping a source column from the spreadsheet to this column in the table?

If so then the data in...

Please do not post the same question to multiple forums. Most people who like to help look in all the forums.

Direct all answers here.

http://www.sqlservercentral.com/Forums/Topic647237-148-1.aspx

May seem like overhead, but Create a numbers table with sequential numbers in it. It becomes very useful over time.

Check out this article,

http://www.sqlservercentral.com/articles/Advanced+Querying/2547/

Along with other forum post which has...

Your not giving us enough information.

How do we know which row is the first row?

The one with the value or the one that is blank.

Do you have an identity column,...

The only way I've been able to do this is create a Surrogate key in the destination table, and include it in the Data extract.

The Surrogate key from the extract...

Okay,

No you cannot compare rows for conditional formatting Only columns.

I have not found a way to do this, and I really have not needed to.

This may help you figure out how to do this. it is very easy

http://www.sqlservercentral.com/articles/Development/reportingservicesconditionalformatting/1423/

The way your describing your problem is confusing me.

It is failing because your trying to cast a String of spaces into a currency type. a string of spaces does not/cannot...

I don't think this has been done before.

You can't have an invoice lines without an Invoice.

But you want to require an invoice has Invoice lines when you insert the Invoice....

Thats fine that they are using the same location. But makes them unique?

How do you know what site file belongs to?

Not sure if it is allowed in 2008, I'm thinking not.

But as described above when modifying the Identity property of a column in SSMS, all it really does behind the...

Use that table that you found the duplicates in as a derived table, Join to it on the fields you believe are the unique ones back to the original table(s)

Select...

So your using VB Code to create Sql2000 DTS Packages, and your running those code generated Packages against a SQL2005 Server?

There are some issues running 2000 packages in 2005. Although...

Once again this will always be true, so it will be an infinate loopl

While(select count(prize_seed_id) from prizes_seeds)>0

Based off your code I don't think you need a while statement