Check out Frank Kalis site.  He has done extensive testing on this subject and my memory seems to want to confirm that your memory is right

You can't dynamically change the in the connection like that.  You have to use dynamic sql (including the following code) to make this work.

If you need to run this cod...

Nice idea Steve, a trip in space would be a great space for any geek .

Definitly.  My idea will be the best approach in this context.

You can use fileexists as the best approach in the case where you only want to check if 1 file...

That one I like, except for the thrash part .

Edited 2007-07-06.

How about a free plane ticket for next year (or rebate, as the ticket prrice is drstically different from one person to the next)?

I'd do it the other way around.  List all files that are in the directory(ies) and send this into a table.  Then you can do a left join to find...

Not likely, but it would potentially avoid many others!

Thanks Steve.

2005.

Check out the link in the aswer for more details of all the version names of every MS products ever written.

Nice to know.  I'm glad we're finally moving to 2k5 here at my current client.  It's gonna be a lot of fun to master this new tool

Agreed, your ego is telling you to do this.  However your ego seems to be up to date with technology and it would be nice for the site to be...

Picture link is broken Steve... No comment on the article as I've not read it, yet .

You can't imagine how happy I am to have bowed out of this one after day 1.  I wish I could compute the time I saved by not reading that...

Gonna save Jeff some typing.

You still don't need a cursor for that conversion.  Use temp tables and batch convert the data before final import.