Ok, thank you, I now have a better handle on my options. I need to decide if I am going to change the table or go the conversion route.

I have gone the SSIS route for this. I'm using this as a guide. http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/61987/

I use a for each loop container to insert files into a table from...

Thanks for you reply.

I end up getting the "cannot convert between unicode and non-unicode data types" error on a particular field.

If I do set the file to unicode would my...

I have been using this forever.

http://www.accessmvp.com/DJSteele/DSNLessLinks.html

I can't say its the best but it has worked well for me. It easy to relink your tables if you add a...

I know I'm late to this party but does this code traverse subdirectories?

Thanks

There are some real pros here who will help if you provide create table statements and insert statements.

Without that I'll provide untested air code, that is quite possibly...

If you could post the table structure and some sample data that would help.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Jeff,

Thanks for the code and education on Inline Table Valued Functions! That should work.

I considerd a calendar/date period table but since there was no business days or holiday requirements I...

>>Does anyone know the purpose of those tables that were created in the front end and if it's, or will be, an issue?

I have never seen this and no I...

I'm happy with SSRS 2008 R2. It's been out quite a while and seems pretty mature. I understand earlier adopters were not quite so happy. I like the fact that...

Operator error, product is working as designed.

In my proc there were two select statements embedded in if clauses. The fields were not aliased consistently in the two select statements.

I resolved this by placing one tablix within another. Using the wizard lead me to this outcome. The outside tablix was grouped on the company name. The inside tablix shows...

I have tried that and the problem is the same 'first' name appears on every page. This would work in a single page report showing one company, but not a...

I do sometimes format in tsql. Its quick and dirty if you want to send out an sp_send_dbmail email using an html string in which case there is no front-end...

This doc is old but should give you some background.

http://www.dell.com/downloads/global/power/4q03-mis.pdf