I left the header row alone. I deleted half of the first data row and all the other data rows.

Interesting! I never would have thought of that. Thanks for you help.

I ended up restoring from backup which resolved the problem. Case closed. Thanks.

My SQL Server service account has access to E:\SQL_Data.

xp_CmdShell is already in the mix....

DTLoggedExec is what I really want but I usually refrain for 3rd party software.

So I can do something like the below.

I'd prefer to only have...

Is VMs physical to virtual (P2V) process and option?

>>and then in SSIS I can also put the farm name in another column

Can you use the extended properties of a database.. Right-click on the database and go to extended...

Ok then it sounds you have left the realm of SQL Server. Maybe this.

http://www.freewaregenius.com/2009/07/30/how-to-split-a-very-large-text-or-csv-file-by-a-specific-number-of-lines-rows/

Or back the situation up to a single recordset and explain to us what you...

The rownumber idea looks like a great way to start. At some point it seems you are going to have to perform the file creation process an indeterminate number of...

If you post your data properly you are more likely to get someone to help you.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Whats the data access mode of the OLE DB Source set to?

Try simplifying your query as a troubleshooting tactic. Try it with just the select. Then try it without all the unions. Maybe one of the selects within the unions is...

UNION will remove duplicates. If you know there will be no duplicates the you can use UNION ALL and increase performance.

Thanks. It seems the lesson here is if you just need the count, use @@ROWCOUNT. If you want to do something with the details of the inserted records, then use...

This below is not performing very well because of there being multiple joins for each record to be deleted. There would be 9 join records when there are 3 records...