This won't be easy... but I cannot speak for the custom source componet aspects.  It seems to me that in a custom component that you could use one or more...

that chart just says the "advanced transforms" aren't available in standard edition.

duh!  of course that works.  How simple.  Thank you Jamie.

"Use the Force, Luke!"

I would like to see YOUR version that is "slightly denormalized"... Having been on both ends... a user/manager whispering in my ear "let's eliminate all those messy...

This is great stuff!  I want to thank you all; but I don't want to curtail your comments either.  This is why we hang out in places like this

not sure what you mean by a "driver error"... or what "didn't work" means... both dtsrun and dtexec work on my desktop... I don't have any migrated packages to test...

search this site with the keywords "download excel" and there are about 15 posts on the subject over the past two years... did not see anything specifically for sharepoint; but...

Well, it turns out that there is an automated backup feature that may help you recover if you crash while editing in Visual Studio 2005.  It is set to purge...

I read this both places you posted it and tried to do some research on it... there did not appear to be anything at sqlis.com and I couldn't find anything...

can you connect in the other direction?  Can the server be pinged?  Are you in a domain?  both the old 2000 servers and this one?  what authentication are you using?

have you tried reinstalling with "a valid copy of" as the message suggests?  I'm not trying to be silly... seriously, perhaps your copy is corrupt.  Try downloading a fresh copy. ...

you tried re-installing what software?  Can you install the "tools" only on the client?

don't think so... I seem to remember that it forces you to uninstall the earlier one when you go to install the newer one.

If you are using SSIS you can do the convert on the select statement.  that's pretty smart

very nice use of graphics.  good subject.  I am sure it will be useful at some point.  Thanks!