This is definitely one of those "it depends" answers...

So much depends on your resources, commitments, future plans, deadlines and ramp up time.

Some shops just rewrite all their packages. That's one...

Hopefully, you're not still using the ActiveX Script Task in SSIS. It's deprecated and should not be used except temporarily for migrating DTS packages.

Try this:

http://sqljunkies.com/WebLog/knight_reign/archive/2005/10/05/17016.aspx

HTH,

K

No, that's not correct. The Excel connection manager is available on all editions.

K

By the way, there's a lot of really useful stuff in Donald Farmer's book.

Just nothing that happens to touch on this particular problem.

K

Try this:

http://sqljunkies.com/WebLog/knight_reign/archive/2005/12/31/17731.aspx

Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden

Only thing I can think of is that you didn't select the option to install SSIS during setup.

You might just run it again and try to install it.

"Okay, I accept that distinction... it is an SQL destination with that limitation; not an OLE-DB destination.  But, "Destinations" from that portion of the toolbox do not have success outputs,...

The destination does not work with remote hosts in this release

Are you talking about the OLEDB destination? Only the SQL Destination has this...

David,

Matt David had a look at your package and gave the following comments:

Kirk,

I ran this project and as far as I...

I've asked for the package and data so that we can isolate this and understand better what's happening. We take this very serious and will get to the bottom of...

Apparently, Ash blogged about this a while back with a different method for downloading from HTTP. He posted that here.

http://sqljunkies.com/WebLog/ashvinis/archive/2005/05/25/15653.aspx

K

Well, can't promise any such refunds, sorry.

It's a different animal than Donald's book. It looks like it will be hardbound and around 1600...

March, hopefully...

K

Just happened to do this as a sample for my book... Jamie told me about this post.

Here you go:

Public Sub Main()

  ...