could try this maybe:

WITH cte AS

(

SELECT

[SomeID],

[Invoice_id],

[Invoice Date],

[Division\Buyer],

[etc...]

FROM [SomeTable]

WHERE RowID = 1

)

SELECT

[SomeID],

[Invoice_id],

[Invoice Date],

[Division\Buyer],

[etc...]

[other fields...]

FROM [SomeTable]

LEFT JOIN cte ON [SomeID] = [SomeOtherID]

Your best bet would probably be Books Online

See This Link on BOL

It might not go into too much detail, but it does give a nice overview and samples. For more...

well that's not too bad is it? you just put the double quote as a text qualifier, so it removes them?

as for my question, I'll see if i can get...

anyone happen to have any insight on this one? been looking around and haven't been able to find much information.

I think your problem is that SSIS is not finding the spreadsheet properly because you are using variables. Try putting Delay Validation to true, on the Excel Spreadsheet Connection Manager...

Never used those programs, but as a suggestion, maybe you could try putting the script into a batch file, and then using the Execute Process Task to execute the batch...

Union/Merge and Merge Join are not the same operator. If you were to map them to SQL Server commands, Union and Merge corresponds to the UNION operator, while Merge Join...

Probably a given, but I assume your values are not in a decimal, float, money, or some other non-integer data type? If they are, then your comparison using greater than...

There should be more errors in your log that you can post, to let us narrow down the potential problems.

But, from my experience using the Excel Destination, I can almost...

yeah you could write a custom script to do this, by taking EXCEPT on both sides, and UNION to see the ones which are the same. it is kinda nice...

An ugly way of doing it, which would still work, would be to divide your task into three data flow tasks.

To start off with, you would define your flat file...

Well, as sorta a general rule-of-thumb to apply to most of your tables, I'd say you could start by dropping any index on the RID column, and replacing it with...

The way I usually handle these sort of problems, is to split the query in to two parts.

In the first part, you can make a temp table to store the...

It sounds like what you're really looking for though, would be something like SQL Server Reporting Services or SQL Server Integration Services, depending on the nature of the tasks.

Those two...

wish that the culture of education in India wasn't so dead-set on fact memorization over comprehension of topics. really paints a bad image for what would otherwise be a collection...