Does the collation at the database level override collation at the column level?

Excellent points. 
I will definitely go the stored procedure route. 
Thank you for all the feedback. 

Regards,
Jonathan

Thank you this is very helpful.

Regards,

Jonathan

Thank you much appreciated.

Regards,

Jonathan

Thank you,

I was able to use the xml out put as a source to pull into SQL Server tables.

Regards,

Jonathan

Mean max min values of numeric columns.

Wow that is not good as the size of data will get quite large.

Thank you for the feedback. I will have to continue to research the options as far...

The queries are updating lookup tables that do not have a value by using a subquery to the lookup table.

I like that idea of using a computed column as...

Very interesting I did not think of that at all.

The query was passed on to me to call from a package.

I will have to ask the creator more questions...

Thanks so much guys this is greatly appreciated....

Indeed.

I was able to use a C# script to read line by line and remove NUL value characters from the file.

Now I'm able to load the files into...

Basically I have to see about removing the NULL character from the files in some type of preprocess...

So it looks like the file has \0 when I search within Notepad++ when changing the Search Mode to Extended

Continuing to search