Thanks for you help!

Thanks again steveb,

I have another question? Could I shorten my code by using the "left" and "right" functions? Are there any performance or potential problems?

select cast(left (yrqtr ,4)...

Thanks,

Now how do I change it back to int? Because in SSIS I'm doing a lookup transformation and the data types need to match?

My goal is for them to be SSIS packages. I used the migration wizard in BI development studio. It said that it was successful but I can't find...

Can/should I delete the object audit_tr_200710231434316620 from system?