I found it! There was this weird character (?) in the data, so you are right about SSIS.

Thanks!

Good point about the Alter Table script. I was able to dump the data into a table with all NVARCHAR datatypes and then was easily able to push the data...

I'll check it out, thanks for your feedback.

On a side note... I am very surprised that SSIS is still (after all these years) one of the worst ETL tools...

Thanks for your response. I figured that was the case but just wanted to be sure.

BTW: Your signature is hysterical! I love it! Both cynical and logical 🙂

Thank you for your advice. I will go with the second loop as there is no performance hit. Plus I will only have to archive around 30 - 40 files...

Nice Luis! Fast as hell too!

Much appreciated 😀

Ok, figured it out....

You have to go to the data sources and reconfigure the security options. Inherit, Impersonate User, etc did not work, but when I typed in my full...

OK I found it....

Basically you go to add/remove programs and select remove on the SQL 2012 instance. You will then go through the steps and select what you want to...

Thanks guys! I appreciate the feedback.

Thanks Phil - So what is the standard? Craigs code seemed to work.

Just in case anyone else is having the same issue....

I have .NET scripts that pass values into SSIS variables and provider information was also listed in those scripts. If you...

Thanks Howard. That worked!

Thanks Howard. Much appreciated.

Yea, I saw this but I was wondering if MS had anything else. Surprising that the tool MS offers is only compatible with 2008 R2 and higher. One would think...

Thanks for all your responses. Perhaps I should raise this with MS? But, only God knows when they will get back to me. 😛

Enjoy your weekends!