Vlad,

   Look into the sqlbulkcopy object. If you used FillSchema to populate the columns of the datatable from the source table in SQL, you should be able to assign the...

Antares,

   Your suggestion seems to have solved my problem! Many many thanks. I have been trying to figure this one out for about a week. I guess the moral(s) of...

Antares,

  I am going to try your suggestion. I will let you know if it solves my problem.

Thanks!

Paul,

  Thanks for the suggestions. Two points however:

1.) Its not 'failing' during the disconnect. It is failing when I try to connect to any subsequent SQL Server.

2.) I am not...

Thanks for the suggestion. I changed the flow but unfortunately still get the same messages. I print out the login info for each server to make sure it is correct...