In a nutshell, there are two databases. One old. One new. One way of transferring data is by hand or having someone enter it into a spreadsheet.But of course, if you have thousands of tidbits, products, or blog entries, you're going to want to transfer data directly.SQL Server Integration Services is the answer (a.k.a. SSIS). Previously it was called DTS (Data Transformation Services) and this was easy for me to understand but later found it hard to manage. SQL Server 2000 has been out for...what 9 years now? Well now I'm at the situation where I want to transfer data from SQL Server 2000 to SQL Server 2005. You'd think it would be straightforward. Select the wizard, choose your fields, and import the data to your new home.So basically, after screaming my ass off trying to setup SSIS. All I want to do is create an ETL (extract, transform and load data) package but there is no option to select "Integrated Services Project" and it's a pain in the ass. I know I'm running the right software to do this:

SQL Server Developer Edition

VS Studio.NET 2005

After combing the net for 3 hours, I finally found a link hidden in Microsoft's site that should help.
http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en 

God help me. Let's see if this works.