Who is online?  157 guests and 0 members
Home  »  Blogs  »  BrianKnight  »  Designing DTS Packages in SQL Server 2008

Designing DTS Packages in SQL Server 2008

change text size: A A A

posted  11/7/2009 12:31:07 PM  by BrianKnight

One of the specialties of Pragmatic Works is upgrading DTS packages to SSIS but we were recently quite frustrated when we tried to use the advertised DTS Designer inside SQL Server 2008. The error you’ll receive is the following (even after you install the components).

SQL Server 2000 DTS Designer components are required to edit DTS packages.
Install the special Web download, "SQL Server 2000 DTS Designer Components"
to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)

We found a series of bugs trying to open a DTS package in the DTS Designer for Management Studio in SQL Server 2008. For some reason, Microsoft only developed a SQL Server 2005 flavor of the installer that sets up the designer. So, to install DTS Designer for SQL Server 2008, you must follow the below steps:

1. Install the 2005 DTS Designer from the following location: X86 Package. If you install the earlier build of the DTS Designer which the Microsoft documentation points to, it will not work unfortunately.

2. This installs the DTS Designer into the 2005 directories so you’ll then need to copy the files over to the 2008 directories. Make sure Management Studio is closed when you run the following commands (we create a batch file to do this typically). Make sure you also replace the path with your own drive and path:

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

After you open Management Studio again, you should be working. I wish it was simpler but hopefully this post saves you the time that spent on it.

  Rate This Blog Entry:  register  or  login

Author

BrianKnight BrianKnight (Member since: 10/22/2009 5:15:12 PM)
Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of 10 SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.pragmaticworks.com.

View BrianKnight '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

BrianKnight's latest blog posts

  • Planning Technical Sessions
    8/24/2010 2:29:30 PM by BrianKnight  - Views: 231  - Comments: 2
    evin and I just wrapped up an all day session that was filmed live called Knight's BI Summer School . While the session was only 6 hours on camera after you take out lunches and breaks, I thought it'd...
  • SSRS Action to Open a URL in a New Window
    8/13/2010 10:47:19 AM by BrianKnight  - Views: 271  - Comments: 1
    When developing reports in SSRS, you will often want to click on a given value and go to a URL on the Internet. This is an easy concept in SSRS with Actions with the "Go to URL" option as shown in the...
  • BIDN Contest Winner Announced
    7/29/2010 1:09:35 PM by BrianKnight  - Views: 177  - Comments: 1
    Congratulations to Brian McDonald who has triumphed as the winner of this month's Zune contest. Brian achieved more than 700 points on BIDN over the past 30 days and was also promoted to Jedi Knight s...
  • Microsoft Business Intelligence Summer School
    7/14/2010 3:11:19 PM by BrianKnight  - Views: 369  - Comments: 0
    Microsoft Business Intelligence Summer School Upgrade Your Resume in 1 Day In this full-day virtual workshop, you'll learn from author team Brian Knight and Devin Knight how to build a data warehouse ...
  • Community Participation Contest Half Over
    7/12/2010 8:34:13 PM by BrianKnight  - Views: 223  - Comments: 0
    The contest for the ZuneHD is about half way over ( http://www.bidn.com/blogs/BrianKnight/ssis/784/zune-contest-for-community-participation-in-july). So far, you can see the contest is a close one wit...
  • Management Studio Trick with Query Writing
    7/6/2010 7:33:20 PM by BrianKnight  - Views: 370  - Comments: 5
    It's always funny when I go 12 years in this industry and don't know some basic trick about writing T-SQL until weeks ago. So, in today's installment of Doh' that's Cool, I wanted to share with you a ...
  • Fast Track Presentation Slide Deck and Resources
    6/30/2010 5:27:37 PM by BrianKnight  - Views: 381  - Comments: 0
    Thanks to all who attended the Implementing the SQL Server Fast Track presentation this week. If you missed it, you can see the recordings here: https://www1.gotomeeting.com/register/933664848 or down...
  • Zune Contest for Community Participation in July
    6/29/2010 2:47:08 AM by BrianKnight  - Views: 404  - Comments: 5
    I was looking through the event bags from TechEd and it looks like we bought an extra Zune HD (16GB). So, I need to find an interesting way to give it away! I decided a great way to give it away is to...
  • Loading Flat Files Faster in SSIS with FastParse
    6/28/2010 12:41:14 AM by BrianKnight  - Views: 562  - Comments: 0
    Most of us have used SSIS to load a flat file into a destination. A little known fact about the Flat File Source which is used to do this is that as it loads data into a destination it validates any n...
  • Upcoming Free Education from Pragmatic Works
    6/27/2010 11:58:04 PM by BrianKnight  - Views: 447  - Comments: 0
    It's been a great month of free education from Pragmatic Works. The recordings from the previous ones are now posted and I have one on Tuesday on SQL Server Data Warehousing Fast Tracks. Check out all...
  • Why not use an SSIS SQL Server Destination
    6/24/2010 3:17:48 AM by BrianKnight  - Views: 879  - Comments: 5
    Once upon a time, in SQL Server 2005, the SQL Server team was working tightly with the SQL Server product team to reserve a special spot of shared memory for SQL Server for SSIS to dump into and then ...
  • Notes from PowerPivot Example
    5/25/2010 6:59:18 PM by BrianKnight  - Views: 585  - Comments: 1
    We had a bit of an impromptu session today during today's webinar. You can find the recording for that session at http://www.PragmaticWorks.com and click Webinars. Here's my scripted demo which shows ...
  • Parallel Data Loads in SSIS Article Posted
    4/27/2010 2:24:49 AM by BrianKnight  - Views: 655  - Comments: 0
    For those who attended the webinar last week, I mentioned some code on how to do a parallel load in SSIS. I started to write this in a blog post but it was so long, that I had to make an article out o...
  • April Webinar Series
    4/20/2010 1:19:46 PM by BrianKnight  - Views: 625  - Comments: 1
    April Webinar: MVP Series In these sessions you will learn how to design a data warehouse, load it using SSIS, place a cube on top of it using SSAS and report against it using SSRS. Finally, you'll se...
  • SQL Server 2008 R2 Managament Studio Object Explorer Missing
    4/5/2010 1:44:17 PM by BrianKnight  - Views: 1060  - Comments: 2
    I've been using SQL Server 2008 R2 in beta for about 6 months with no issues but today, I had a strange one I'd have to share. In Management Studio, I was adjusting my open windows and at some point O...
  • SQL Server 101 Webinar Series
    2/22/2010 5:11:32 PM by BrianKnight  - Views: 1204  - Comments: 1
    February SQL Server 101 Series New to SQL Server or trying to enter the field? This webinar series will walk you through the Microsoft SQL Server stack so that you can become a DBA or Business Intelli...
  • SQL Saturday and PASS
    2/2/2010 4:54:40 PM by BrianKnight  - Views: 1534  - Comments: 1
    I wanted to post this letter that just went out from PASS. As it reads, Andy, Steve and I are excited to announce that we have gifted one of our prized brands, SQL Saturday to PASS to grow the brand w...
  • SQL Lunch Code - Scripting in SSIS
    1/19/2010 1:27:25 PM by BrianKnight  - Views: 956  - Comments: 0
    Thanks for all who attended my SQL Lunch session! There was a few questions that reoccured. One was about the free components I showed. The free component was Task Factory and can be downloaded from h...
  • SSAS MDX Year to Date (YTD) Calculation Example
    12/18/2009 9:13:36 AM by BrianKnight  - Views: 5280  - Comments: 1
    Often times, you want to analyze sales using a year to date view as shown below: While you can do this in an MDX formula in SSRS, you might find this calculation valuable enough to store a server-side...
  • Watch the BIDN.com Twitter Feed
    12/17/2009 10:38:49 PM by BrianKnight  - Views: 824  - Comments: 1
    We're moving fast at the BI Developer Network (BIDN.com). In an effort to make sure you get your BI questions answered, we've installed a new twitter interface that if your question in our forums does...
  • A Simple Twitter Console Application
    12/17/2009 2:16:00 PM by BrianKnight  - Views: 1059  - Comments: 2
    I've been working this week to automate the BIDN.com's twitter connectivity and to do so, decided to build a quick Twitter interface to communicate with BIDN. I needed a simple console application tha...
  • The Need for More Data on Unknown Members
    12/7/2009 7:50:35 AM by BrianKnight  - Views: 710  - Comments: 1
    As ETL developers, we typically lump anything that's NULL or something we can't find an ETL lookup match on to -1 or "unknown". We would first of course have to create an Unknown record in each dimens...
  • MDX Example Code
    12/1/2009 11:06:37 PM by BrianKnight  - Views: 1487  - Comments: 5
    After promising a dozen people a dozen times that I'd do this, I finally posted my MDX examples that use during my sessions http://www.bidn.com/files/ . You'll need to have the AdventureWorks cube ins...
  • Microsoft BI Video Resources
    11/29/2009 11:27:01 AM by BrianKnight  - Views: 1048  - Comments: 2
    I just stumbled upon a great resource for Microsoft BI believe it or not, on the Microsoft website. The first one is a list of short concise videos about how to implmement BI: http://www.microsoft.com...
  • BI xPress 2.0 Launch
    11/13/2009 8:37:40 PM by BrianKnight  - Views: 596  - Comments: 0
    I'm excited to announce the new version of BI xPress 2.0. It has a new feature called a Package Builder. The Package Builder will allow you to capture components of SSIS into a template that you can r...
Blogs RSS Feed

Latest community blog posts

  • Pirates of PASS: Curse of the Elections Process
    14 hours, 24 minutes ago by sqlchicken  - Views: 8219  - 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: 6266  - 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: 533  - 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: 4193  - 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: 178  - 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...