Sorry, yes I know how to read the history. Remember the process hangs so I do not get an error message it is a 5 minute process and I...

Where would I find those log files that I can read. They might

Thank You for your help that solved the problem.

I am actually running under Network Services and not Local Systems account. It takes my Id which has permissions to the network servers. My thinking is that I...

I guess I am confused on permissions. I think you hit the problem on the head however I am the user for SQL SERVER AGEnt so I should be...

Yes I can run the package from business intelligent studio or I can run it from integration Servives from with in SSMS. In both cases it works greate with...

Thank You for the response and I follow exactly what you said and the package will work if I run it under integration Services GUI and it the package is...

I appreciate the support and the ntext solution worked.

The problem still exists and it is all because it has unicode characters and Sql Server does not know how to deal with them. I found some code to...

Thank You for your response on confirming my problem. Apparently I had a corrupted install. For other reasons I had to reinstall SQL Server 2008. AFter...

OK thanks

Thanks for the information that I liked the approach and got my process to work.

Thank you for the responses I got the BCP process to work

That was my original try was to use bulk insert, the previous note is where I need to go with the file because the bulk insert fails with the...

I tried that first, but I can not seem to get BCP to work. When I type in the command the machine just flashes and doesn't appear to do...