Ok, this is an interesting approach and a good attempt, but it is not a good way to do this.

From the code, the ID is always 'PW' followed by a...

The easiest way to see the result is to run it both ways and compare the execution plans. I tend to run both in a single batch - this...

I would guess the larger file is unicode and the smaller is ascii. Check the character sets of the output files.

You cannot do this:

[font="Courier New"]SELECT @Rows = COUNT(*) FROM @tblname[/font]

To do this, @tblname would have to be a table variable. In your case, it is...

You should get a book or search around this site and search google for how to use SSIS to transfer data. What you are doing is fairly simple and...

There is no FIRST function in MSSQL.

You can use a CROSS APPLY to do this pretty easily, but it will generate a loop when it runs, so it may not...

It will depend on the dynamic SQL and the case statement methods used.

I would imagine that the author found a situation in which they are correct. However, this is...

Why aren't you using a data flow task?

Think from the other direction - if there were no rows, delete the file.

Get the rowcount during your data flow and put it into a variable. In the control...

I would not take this approach. You are getting dangerously close to making yourself responsible for a tape backup failing - and you may simply have no control over...

That will depend on a lot of factors.

Usually, most of the work is done at the Analysis Services end, so the memory needed on the client end is not much....

Good catch.

You could do this using a variable.

You can control your package flow through the use of expressions in your flow connectors. Since a package does not have to be...

This has been hit or miss for a lot of people. I have had good and bad experiences with virtual servers and SQL 2005 and I do not use...

I agree - avoid using hints - they are a last resort. NOLOCK, in particular, is a commonly misused and misunderstood hint and should rarely be used.

I did notice...