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 1:27:11 PM 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 8:52:44 AM)
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:

Blogs RSS Feed

MikeDavis's latest blog posts

  • SSIS Renaming and Moving Tasks
    3/4/2010 4:11:19 PM
    If you are like me you click the mouse a lot, and fast. I drive my mouse to the breaking point clicking around so fast on items, especially in SSIS, which is a graphical interface. But when clicking on the tasks in SSIS I sometimes end up in the rename function instead of opening the edit screen. There is an easy way to avoid this. Look at the image below: Double clicking in the red section will open the editor. Double clicking slowly in the blue section might start the rename function. If you d...
  • SSIS Excute SQL Task Fails with Executing the Query " " Failed
    3/2/2010 5:57:21 PM
    When running a package with an execute SQL Task it is easy to get syntax errors. If the tasks turns red, but still accomplished its work, like an insert statement and the error you recieve is: Executing the Query " " Failed ...  This is saying the query was blank. If you have a GO statement at the bottom of your SQL task an there is a space after it, that is the cause of your issue. Remove the space, or the entire Go statement.
  • SSRS 2008 Report Model with no Foreign Key and/or primary Key
    2/26/2010 9:57:11 AM
    When creating report models you might run into bad database designs where the tables have no foreign keys and/or no primary keys. This can be resolved in the report model DSV. I have created two tables, One with first names, the second with last names. Each has an ID column which is the row that matches the row on the opposite table. There are no primary keys and no foreign keys on either table.    In visual studio I created a report model project and selected the database with these two tables....
  • SSRS 2008 Change the Series Colors for Chart and Legend
    2/25/2010 12:48:27 PM
    In my last SSRS 2008 class I was showing the students the chart tools and used color as a series on a chart. It was the product color column from the AdventureWorks 2008 Production.Product table. The series automatically chooses colors based on the color pallete of the chart. This made the report confusing because the colors did not match the product colors.    One of my students asked if the expression could be used to change the color. So I tried and it worked. I placed the color f...
  • SSRS Expressions MTD Month to Date
    2/24/2010 1:46:53 PM
    If you have a report in SQL server reporting services that has start and end date parameters, you may want to have default dates to show the current month to date. The end date is easy, it is just the today() function. The start date needs to get the first day of the month, there are several ways accomplish this. Here are two code snippets that do this:   =dateadd( "d", 1-datepart("d", today() ), today() ) or   =DateSerial( year(today()), month(today()), 1) The first example subtracts the number...
Blogs RSS Feed

Latest community blog posts

  • Free and Discounted Microsoft Learning Resources
    3/15/2010 11:06:43 AM
    I was browsing the Microsoft Learning portal over the weekend and came across the following free or dicounted learning resources for SQL Server. Free Resources: Clinic 6188: What's New in Microsoft SQL Server 2008 for Enterprise Data Platform (1 hour)   Clinic 6189: What's New in Microsoft SQL Server 2008 for Business Intelligence (1 hour) Clinic 6190: What's New in Microsoft SQL Server 2008 for Database Development (1 hour) Clinic 6258: New Features Of Microsoft SQL ...
  • SQL Agent jobs
    3/14/2010 2:46:26 PM
    Recently I was asked to provide a list of all sql jobs on a certain server running between 2 and 3 in the morning.  We have quite a few jobs and it would be time consuming to look through each to determine the time of day each runs.  So I used the sysjobs, sysjobsschedules tables to return the job name and times the jobs run. There are several jobs related tables in the msdb database: sysjobs sysschedules sysjobhistory sysjobsteps syscategories   The table names are pretty self explanatory.  The...
  • Solving All Versus (Select All) SSRS End User Confusion
    3/12/2010 11:11:39 PM
    When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in report parameters.  Anytime you have a parameter that allows for multiple values to be selected then you will see a (Select All) option that Reporting Services adds that make for an easy way to check off each item in the parameter dropdown.   If you followed most of the defaults when developing you dimensions in Analysis Services you likely also have an opt...
  • DTS Runtime Required
    3/12/2010 10:49:40 AM
    Yesterday, I dealt with a client that was having issues converting his dts packages to SSIS 2008. He was using DTS xChange to convert the packages, but each time he tried to run the migration, he received the following error. "Can not load Tasks. Error : Unable to cast COM object of type 'System.__ComObject' to interface type 'DTS.CustomTask'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed d...
  • Missing AdventureWorks2008 Found
    3/12/2010 7:08:28 AM
    So I finally got through all the SSIS Class Labs including the Group Labs and decided to figure out why I didn't have AdventureWorks2008. I had previously tried to enable FILESTREAM according to some blogs I had read about it but had no success. Maybe I just understand all this a little better now but when I exactly followed these steps right out of the help file it worked for me: 1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and t...