home  »  Blogs  »  MikeDavis  »  DTS Packages in SQL Server 2005 or 2008 64bit

DTS Packages in SQL Server 2005 or 2008 64bit

change text size: A A A

posted 11/12/2009 by MikeDavis

If you are running SQL server 2005 or 2008 and are on a 64 bit machine and want to view DTS packages in management studio, you will need to do several things. This is a repost of Brian Knight’s blog, mine is just the 64 bit version.

Download the DTS designer components in Feature Package for SQL server 2005 December 2008, even if you have 2008. There are older version of the components so make sure you get the December 2008 version. (SQLServer2005_DTS.msi)

Download the Backward compatibility components from the same site. Make sure you get the 64 bit version (SQLServer2005_BC_x64.msi).

Install them both.

Then use the copy command below to move the files. You will need to save these copy commands in a text file with a .BAT extension. Then run the bat file from inside a command prompt. Run the command prompt as Administrator. Notice these files are in the 32 bit Program files directory(x86). Afterward you will be able to import and open DTS packages in SQL server 2005 and 2008. I ran this on Widows 7 64 bit.

COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\semsfc.dll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\
COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\sqlgui.dll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\
COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\sqlsvc.dll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\
COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\Resources\1033\semsfc.rll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033
COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\Resources\1033\sqlgui.rll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033
COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\Resources\1033\sqlsvc.rll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033

tags: DTS Packages SQL Server 2005 2008 64 bit
To rate this blog entry please  register or login

Author

MikeDavis MikeDavis (Member since: 10/27/2009)
Mike Davis, MCTS, Senior Business Intelligence Consultant and Trainer at Pragmatic Works. He is an author on Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups across the US, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

View MikeDavis 's profile

Comments (no comments yet)

Post a comment

Comment (No HTML)  

Type the characters:
 *
 
   

Join Business Intelligence Developer Network for FREE Today!

It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.

enter your email address:

MikeDavis's latest blog posts

  • SSIS expression First day of next year
    2/3/2010
    If you just want January 1 of the next year here is the easiest way to do it. If you want a different year just change the "+1" to a different number. For example: if you want 2 years ago change it to "-2". This number could also be a variable to make the...
  • Iron Chef Data Warehouse Edition SQL Saturday SSAS
    2/2/2010
    For those of you who did not make it to SQL Saturday in Tampa you missed the best presentation ever. It was an Iron Chef like competition between Brian Knight and Adam Jorgensen . They went head to head in an attempt to build a data warehouse from a unive...
  • Microsoft Business Intelligence Certification, SSIS, SSAS, SSRS
    1/30/2010
    I just passed the Microsoft BI certification test 70-448 on SSIS, SSAS, and SSRS. It was a tough test and cover all aspects of the Microsoft BI stack. I used a lot of different study materials. Here is my assessment of the study materials I used and which...
  • Multi Value Parameters from Stored Procedures in SSRS
    1/26/2010
    When using a stored procedure to call data in SSRS (reporting services) you will need to pass the parameter from the report to the stored procedure. This is easy when you are passing in a single value. When you want to use a multi value parameter you will...
  • Change Data Source View Name with XML in SSAS, SSIS, SSRS
    1/25/2010
    In a recent Data Warehouse Quick Start I was helping a company build a cube. They wanted to change the Name of the Data Source View. I knew this would cause a lot of other items to break in the project. One of the employees gave me a tip. Hit Ctrl+F and s...

Latest community blog posts

  • Marcus Day 1 in SQL Training
    2/8/2010
    Today was my first day in the SQL training offered by PragmaticWorks. Though I am challenged, it is an excellent environment to learn new information. I am enjoying the laid back atmosphere and the willingness to help as many times as necessary to get wha...
  • Paul My First day
    2/8/2010
    My first day was interesting espceicially for a person that has a legacy systems background. I am experienced using cobol, cics, vsam and have very little experience with current technologies.  A couple of times I struggled on parts of some exercises, but...
  • ashleyknight Pragmatic Works Foundation First Day
    2/8/2010
    This blog is a great way to exhale after our first day of class. This non-profit organization provides a great opportunity for those interested in entering the business intelligence world. Fit with a clean, new lap top and a positive teacher, we have been...
  • timmurphy Foundation Day 1
    2/8/2010
    Devin just finished pouring as much as he could into our brains. It started easy and progressed to more difficult as the day went on. At this rate we will know everything about the known universe by Wednesday. Thanks Brian for giving us this great opportu...
  • MCao First Day
    2/8/2010
    I can describe the first day in one word, WOW! I feel like I am back in school but this time around I'm learning so much more in so little time. Today was more of a refresher of everything I learned in school but this time I actually think I will remember...