Who is online?  146 guests and 0 members
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
  Rate This Blog Entry:  register  or  login

Author

MikeDavis MikeDavis (Member since: 10/27/2009 8:52:44 AM)
Mike Davis, MCTS, MCITP, Senior Business Intelligence Consultant at Pragmatic Works. He is an author on two Business Intelligence books. 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)

Leave a comment


 
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

  • "Drive" a great book
    8/31/2010 1:23:59 PM by MikeDavis  - Views: 2255  - Comments: 0
    If you only get a chance to read one book this year, it should be Drive , The Surprising Truth about what Motivates Us. This book has made me rethink how I am motivated and how I can motivate others. ...
  • My New Business Intelligence Book
    8/24/2010 12:59:48 PM by MikeDavis  - Views: 128  - Comments: 0
    My new book on Business Intelligence is available on amazon. You can pre order now and save. http://www.amazon.com/Knights-Microsoft-Business-Intelligence-24-Hour/dp/0470889632
  • Getting Previous Row in SSIS Data Flow
    8/20/2010 5:06:40 PM by MikeDavis  - Views: 277  - Comments: 6
    There is no native Transform built in to SSIS to get the previous row in the data flow. But with a little work you can do this and make it perform much better than a SQL cursor and you don’t have to u...
  • SQL R2 Map Change map type, Road, Aerial, Hybrid
    8/6/2010 8:50:52 PM by MikeDavis  - Views: 135  - Comments: 0
    With the new Map control in SQL 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If you want to allow your users to change the map type you would think you could map a parameter ...
  • MDX Scope with an If Then Exception or Filter
    8/5/2010 7:35:41 PM by MikeDavis  - Views: 314  - Comments: 0
    The scope statement in MDX is great for applying calculations to a certain area of a cube, also called a subcube. Dustin Ryan wrote a great article on the scope statement here . The issue I am going t...
  • MDX YTD not working due to format String
    8/2/2010 2:13:55 PM by MikeDavis  - Views: 193  - Comments: 1
    If you are using the templates for MDX calculations built into SSAS 2008 you might run into some strange issues. In the image below you can see the calculation is working for all years except for 2008...
  • SSIS Execute SQL task Error: No disconnected record set is available
    7/26/2010 2:07:19 PM by MikeDavis  - Views: 226  - Comments: 0
    SSIS Execute SQL Task Error : No disconnected record set is available for the specified SQL statement. If you get the error in SSIS that says: [Execute SQL Task] Error: Executing the query "INSERT INT...
  • Microsoft Business Intelligence Certification Pro Test 70-452
    7/23/2010 8:56:20 PM by MikeDavis  - Views: 234  - Comments: 1
    I just took the Microsoft Business Intelligence Certification Test 70-452. This is the pro test and the second one after the MCTS 70-448. I have a lot of experinece with the BI world so the test was n...
  • Going to SQL Saturday 40 South Florida
    7/20/2010 3:43:55 PM by MikeDavis  - Views: 159  - Comments: 0
    I will be at SQL Saturday in South Florida on July 31st, 2010 Hope to see you there. http://www.sqlsaturday.com/eventhome.aspx?eventid=47 The South Florida SQL Saturday will be help on July 31st, 2010...
  • SSRS Nulls in a Matrix
    7/14/2010 2:02:00 PM by MikeDavis  - Views: 164  - Comments: 0
    In a recent SSIS class one my students ask me, if you are reporting off a table and using it in a matrix, does the matrix show null rows. The answer is yes. Here is an example table and the resulting ...
  • SSRS Hide or Show, Some or All Columns on a Report
    7/7/2010 6:34:34 PM by MikeDavis  - Views: 801  - Comments: 2
    Multiple value parameters are a common tools used in SSRS. You can use this tool to select which columns show on a report. You will need to create a multiple value parameter and place an expression on...
  • SSIS Performance with Multicast
    6/28/2010 8:16:32 PM by MikeDavis  - Views: 351  - Comments: 0
    If you have two or more records on the same row, and need to write each record on its own row in a destination, you have two choices. You can do this in series or parallel in a single data flow in SSI...
  • SSAS Different Dimension Granularity
    5/28/2010 3:12:54 PM by MikeDavis  - Views: 3007  - Comments: 0
    In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example, if you have budget measures and actual numbers. If you are trying to budget you...
  • Call AS400 program from SSIS
    5/20/2010 12:56:23 PM by MikeDavis  - Views: 389  - Comments: 0
    If you need to call an AS 400 program from an SSIS package this can easily be accomplished with an Execute SQL Task. This can be made even easier with two variables and an expression too. The AS400 pr...
  • Convert Address to Spatial Data - Geocoding for SQL Server R2
    5/5/2010 2:25:13 AM by MikeDavis  - Views: 548  - Comments: 0
    If you want to use the new mapping feature in SQL server R2. You may want to get the Spatial data for the address data you have. There are several websites that can do this for you. Here are a few: ht...
  • Loop Through Excel File in SSIS
    5/5/2010 1:22:49 AM by MikeDavis  - Views: 1536  - Comments: 2
    You can loop through excel files using SSIS. This will use the For Each Loop container and a Data Flow task. First create a variable named strExcelfile as a string variable; you can leave the value bl...
  • SQL Saturday Jacksonville May 8 2010
    4/27/2010 1:16:12 PM by MikeDavis  - Views: 369  - Comments: 0
    I will be speaking at SQL Satruday in Jacksonville on May 8 2010. Hope to see you there. http://sqlsaturday.com/38/eventhome.aspx
  • SSIS Bulk Insert Task Error File Not Found
    4/14/2010 5:11:23 PM by MikeDavis  - Views: 897  - Comments: 0
    When using the Bulk insert task in SSIS, you might encounter an error stating that The File Does Not Exist or The Path Specified Cannot be Found. This is usually due to the fact that the file must be ...
  • XML Task in SSIS
    4/6/2010 6:54:51 PM by MikeDavis  - Views: 1122  - Comments: 0
    The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML. In a previous blog I showed how to use a web service task to get the city and state when entering a zip code...
  • SSIS Web Service Task
    4/6/2010 6:49:44 PM by MikeDavis  - Views: 1348  - Comments: 0
    The Web Service task in SSIS can be used to call a web service command to perform a needed operation in your package. The results of most web services will be in XML Format. You can save these results...
  • SSIS Skip Certain Files in a For Each Loop
    3/26/2010 6:31:53 PM by MikeDavis  - Views: 1689  - Comments: 2
    When running a For Each Loop through a set of files, sometimes you will have specific files that you do not want to load. For example, I have a set of files named: Abc.txt Mno.txt Rts.txt Wln.txt Xyz....
  • SSIS Renaming and Moving Tasks
    3/4/2010 4:11:19 PM by MikeDavis  - Views: 652  - Comments: 3
    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 o...
  • SSIS Excute SQL Task Fails with Executing the Query " " Failed
    3/2/2010 5:57:21 PM by MikeDavis  - Views: 593  - Comments: 0
    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: Executi...
  • SSRS 2008 Report Model with no Foreign Key and/or primary Key
    2/26/2010 9:57:11 AM by MikeDavis  - Views: 773  - Comments: 0
    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 table...
  • SSRS 2008 Change the Series Colors for Chart and Legend
    2/25/2010 12:48:27 PM by MikeDavis  - Views: 1624  - Comments: 0
    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 ...
Blogs RSS Feed

Latest community blog posts

  • Pirates of PASS: Curse of the Elections Process
    13 hours, 35 minutes ago by sqlchicken  - Views: 7869  - Comments: 3
    Pirate Code: They're more like guidelines really... The last few weeks we've watched the drama unfold in regards to the PASS BOD elections. We've seen people attack criticize the NomCom, the board, PA...
  • What are plan guides?
    9/2/2010 1:34:14 AM by indupriya  - Views: 6265  - Comments: 0
    Just a while ago I was watching a video on sqlshare Creating a Plan Guide for a Parameterized Statement By Andy Warren . Only then I heard about plan guides. I didn't know what plan guides were. Here ...
  • Did You Know..
    9/1/2010 8:22:35 PM by britmccullar  - Views: 6879  - Comments: 0
    Unfortunately, I don't have one big topic to write about in this post, so I decided to share some observations from the past few weeks - little things that might be of interest in the next report you ...
  • Creating a PerformancePoint 2010 Data Source
    9/1/2010 3:23:11 AM by DevinKnight  - Views: 2800  - Comments: 0
    In a previous post I wrote about getting started with PerformancePoint 2010. In that post you learned about what PerformancePoint is and where to open in in SharePoint 2010. Your next steps are to con...
  • Rock the Vote - Outlook Voting Buttons
    8/31/2010 5:46:06 PM by ChrisAlbrektson  - Views: 6023  - Comments: 1
    So today at the office I was faced with one of the more common and important questions that come up regularly and that was ‘Where are we going for lunch?’ This usually in tells a few minor arguments a...
  • Avoiding dynamic SQL - COALESCE( ) and your parameters
    8/31/2010 3:00:38 PM by KeithHyer  - Views: 7137  - Comments: 1
    Problem: Everyone that's programmed a system that users will interact with has run across a statement like this one in the fact-finding stage. "I want to be able to search on phone number. I can't ima...
  • "Drive" a great book
    8/31/2010 1:23:59 PM by MikeDavis  - Views: 2255  - Comments: 0
    If you only get a chance to read one book this year, it should be Drive , The Surprising Truth about what Motivates Us. This book has made me rethink how I am motivated and how I can motivate others. ...
  • An other Example of Calculation-Dimension
    8/31/2010 12:47:44 AM by Qazafi  - Views: 4104  - Comments: 0
    Recently one of my clients would like to see their Revenue figures represented some of the time as a positive (+VE) value and some time as a negative (-VE) value. They would like to have the ability t...
  • Template Parameters - Little Time Savers
    8/30/2010 8:45:36 PM by KeithHyer  - Views: 13373  - Comments: 3
    Lately, I've been enjoying various shows on the Science channel about Time and Space. No one yet understands exactly what time is yet - still, everyone wants to save some. I'd like to show how one mig...
  • Pragmatic Works Shines at 2010 Jacksonville Code Camp
    8/30/2010 3:24:25 AM by timmurphy  - Views: 2876  - Comments: 0
    I attended the 2010 Jacksonville Code Camp Sataurday and really was impressed with Pragmatic Works. The entire Business Intelligence stack was covered by speakers from PW including Brian Knight, Adam ...
  • Keyboard Shortcut to List All Column Names for a Database
    8/30/2010 2:51:25 AM by timmurphy  - Views: 532  - Comments: 1
    One of the hardest things about starting a new project is getting to know the database with which you are working. Here is a quick way to make a list of the all columns along with the name of the corr...
  • MDX Puzzle #7
    8/29/2010 9:40:12 PM by PatrickLeBlanc  - Views: 4190  - Comments: 2
    I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up a little with one that is a little more challenging. I have to be honest, this puzzle was sent to me by o...
  • Restarting SQL Server using the GUI
    8/29/2010 4:23:50 PM by briankmcdonald  - Views: 4545  - Comments: 2
    Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but in development or on your local desktop instance I restart my SQL Server instance fair...
  • Jax Code Camp - My Presentation and Projects
    8/28/2010 10:52:08 PM by briankmcdonald  - Views: 908  - Comments: 1
    First and foremost, I want to thank everyone who attended my presentation today. It got off to a late start due to the prior presentation running over and a little setup issues set me back a little bi...
  • SSRS Interactive Sorting
    8/27/2010 7:52:27 PM by SMcDonald  - Views: 574  - Comments: 0
    The other day I was creating a report and it needed some sorting capabilities. I said to myself, "Self, there may not be a lot of begginers that know how to add sorting capability". What I would like ...
  • MDX Puzzle #6 - Solution
    8/27/2010 6:15:17 PM by PatrickLeBlanc  - Views: 176  - Comments: 4
    Puzzle #6 should not have presented too much of a challenge, it's intentions were to introduction you to the ORDER function that is available in MDX. Ok, so this is what I started with: This is a very...
  • Jax Code Camp 2010
    8/26/2010 9:28:34 PM by BradSchacht  - Views: 74  - Comments: 0
    This Saturday is Code Camp in Jacksonville, FL. There are a lot of great speakers lined up, some of which you may have seen at other events such as SQL Saturday. If your free on Saturday come on out a...
  • Adding a Bing Map Layer
    8/26/2010 2:07:20 PM by ChrisAlbrektson  - Views: 174  - Comments: 0
    With the release of the SSRS 2008 R2 reporting developers now have a new tool that they can use when creating reports. The new tool I am talking about is the new map wizard. With this you can easily s...
  • PASS Elections Portal
    8/25/2010 9:31:01 PM by sqlchicken  - Views: 87  - Comments: 0
    If you've been under a rock the last few weeks you may not know that PASS is currently undergoing their board elections process. I'm not going to rehash the entire saga here but this is just a quick p...
  • Code Camp in Auckland New Zealand -- 29th August 2010
    8/25/2010 9:11:47 PM by indupriya  - Views: 100  - Comments: 0
    The MS Communities Code Camp & Technology Summit is a Free , non-commercial event, open to everybody with an interest in any of the technologies being discussed. Development This year we will be r...
  • Changing of the Guard
    8/25/2010 8:23:15 PM by sqlchicken  - Views: 91  - Comments: 2
    A few weeks ago Andy Leonard ( Blog | Twitter ) announced that he was stepping down from his position as PASS Regional Mentor. It is with great humbleness and excitement that I can officially say I'll...