Put an ADO destination in a package under R2, move it to a 2008 (non-R2) system, and it won't run, complains yada yada about some connection. This article documents a workaround:
My questions are two. First, if I do this workaround, does it still work the same, does it still use bulk insert when possible?
Second, isn't a more elegant workaround possible, just loading the newer ADO driver on the 2008 (non-R2) system? Or will that break a bunch of old 2008 packages or have some other nasty side-effects?
View Complete Post