Thanks for all the tips. I wrote a VB.NET application (very small) that does the job that I need.

Unfortunately, our network does not support that way of addressing the local PC.

I think I figured it out. The collation sequence I used in the format file did not match that of the database so I changed the collation sequence to...

Unfortunately, I cannot provide the input data as it is protected under HIPAA. I am sure that the data file itself is not the problem. The only...

No, I am not trying to make the data any longer. In some cases I just want to change the content or blank it out.

Thanks... It's just what I needed.

Thanks for the code... I think I may have to rethink my process for doing what I need to do. Obviously, the IF EXISTS and WHERE IN won't cut...

boy... that was fast... I didnt have a chance to edit my post before your replied but sadly that didn't seem to do the trick. I still get...

Perfect !!! Thanks so much. I am still learning all the ins and outs of SQL. You help is deeply appreciated.

I would also like to do a similar thing with the HEADERONLY but when I try to clone your code I get an error. Here is my code:

SELECT...

That works just great... Thank you for your input. it is much appreciated.

I did some digging around and found a tip that suggested that I need to have serveradmin rights in order for the copy to work.

I assigned the...

I am running SQLExpress on my local PC. I checked in Services for the SQL Server properties and the login is the Local system Account which I presume...

The connection is a trusted connection and the folders where the files are located have full control permissions for Administrators, myself, System, and users on the PC. ...

My experience with SQL Server reporting is not very good. I opted to use Crystal Reports. To me they are much easier to develop and manage.