There were quite a few different distribution disks for SQL Server 2000, and Reporting Services did not come out until late in 2003.  Is there any possibility that you used...

you could have two databases with the same names if they were in separate named instances.

"Also, the article seems to describe a classic Slowly Changing Dimension scenario - and SSIS includes a wizard that builds those processes very easily including full handling of inserts and...

splitting the dataflow with a multicast doesn't tell me that the update or insert was successful, and since there is no success output on the destination there is nothing to...

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,...

What tremendous service!

Just a few comments before I get back into it and see why that solution I sent did not fail for you.  The first thing...

Are you using SSL?  I never saw your exact error; but there are a group of them that people seem to get repeatedly.  There is a very good book on...

It seems pretty obvious to me that 35 is not a limitation since that path itself is 36 (if I counted right) and that is the standard location.  I would...

Are you using Mixed-mode authentication on your SQL Server?

I am most appreciative of the offer to help from Kirk and additional input from Donald.  I will also investigate the alternative method suggested by Donald for handling my...

ipconfig returns your IP address.  I cannot imagine any configurations where it would not return your IP address.  Try using ipconfig /all and ipconfig /?

if the DB is on your...

I would re-run the installation script.  I am sure there is an easier way; but sometimes getting the job done is what is important.  Remember to backup the encryption key...

I found that that connections to Sybase worked smoothly when on the same box and/or on the same subnet; but when on a different subnet that they required the "commlinks=tcpip"...

Will there be a "beta" copy like Farmer's book on Scripting?  Funny, it was only $14.95 for the book with a retail of 24.99... and the two day shipping was almost...

I am guessing that it will not work... at least not from the templates installed in the IDE.  The features just aren't there in the earlier RS.  You might get...