I don't think what you're trying to do will work. You'll probably have to split out your COUNT into a CASE statement:

CASE WHEN Year = '2005'

THEN COUNT(2005)

ELSE 0

END as...

Are you able to log in to the new server to verify that it can connect to the other server? I've had this problem before and for some odd...

There's the option of starting a job that runs the DTS package through a trigger. Alternatively, set up a trigger to populate a table and a job that runs...

Enough to say that while some things are similar (creating a global variable or reading from a file), there are enough differences that you'll really want to do a lot...

That's amusing (though the development method sounds eerily familiar in some aspects). Reminds me of a story from http://www.thedailywtf.com where a guy went in to discuss some...

As above - if you need to run the package from a stored proc, you'll either need to do something via command-line to call DTSRun or you can "schedule" a...

While this may not be the solution you are looking for, have you considered using Reporting Services to do this? Populate a table with the data. Set up...

Well, if you've already got the file, you can use a component from http://www.sqldts.com to do FTP uploads. Ideally the filename won't change. If it does...

May want to look into VB.Net if you're going to code with the CLR and/or SSIS. For the rest, it depends on what you need to do. There...

If I remember correctly, SQL Server is able to use the PK/FK relationships when it computes query plans to produce plans that are a little more effective.

I can see that...

I think we're using the product from http://www.zipcodedownload.com

If I'm not mistaken, we get the Zip+4 Premium or the Zip Commercial - quarterly updates. Zip+4 runs ~ $400/year...

We get quarterly updates for a couple of hundred dollars a year. Using DTS and some scripting we can automate that without too much trouble. Now if you're...

Well, you can create a job and run sp_startjob with the job name to kick it off, but you will want to test it to see how well that works...

On a related note - working with Excel into and out of SQL databases is a little harder in SSIS due to the Unicode/Non-Unicode translations. If you have a...

It's cool, but it makes it really difficult for large models. Perhaps more of an effort to fit items on screen instead of one large row for items and...