I used redgate's data generator to populate the column with dates. The years were all random, and I wanted to go in and change all the years to either...

Kingston is the man. Thank you sir!

Kingston - Yes there are many February 29 service_dates in the data.

Lynn - I have tried both and it did not help. Thanks for the thought!

Yes, the datatype is datetime for service_date

Sure, I have added an attachment with the top 10,000 rows service_dates. Thanks!

Thanks Drew, I really like the Cross Apply method. Much easier to read. I wonder how performance differs between the two methods...

Thanks Lowell. I wish I would provide actual data but due to regulatory compliance laws I cannot. I am actually not dealing with orders, upcs, or msrps...it just...

Thanks for taking the time to help Lowell - much appreciated!

I am not very familiar with Row_Number or the Partition By functions in T-SQL, I am going to have to...

CHKDSK came back normal.

Yes, the SQLIO is failing on the step where it first creates the workfile. For some reason it is creating the work file when I run the batch script...

Seems like a reasonable work around if your only goal is to get the SQLIO test to run, but I am more worried about the root cause of the issue....

The C: drive has 131GB free right now, so should be good there. However, it seems to create the data file and then throws an error when it gets...

That is a good idea, but how do I make sure the error is raised before any of the no match output rows are added to the database?

I could do that, but I am loading about 30 different files on this package all with different layouts. I would have to create 30 additional "error" tables and...