How to run DTS package/upgrade in SQL 2005.
Hi All,
I am following instrucation in the following doc to migrate dts package.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/SQL05InSrREAL.asp
In step 2.
- Right-click theDTS Packages folder in Solution Explorer and select theMigrate DTS 2000 Package option. This starts theIntegration Services Migration Wizard.
I don't see "DTS Packages" folder what am I doing wrong.
Thank you in advance.
Satish Patil
There is an alternate way:
Go to Microsoft SQL Server Management Studio
You should see "DTS 2000 Packages" folder.
Right click and select "Migration Wizard".
hth,
Nitesh Ambastha
You need to have installed DTS 2000 support ("Legacy Components") in order to use the Package Migration Wizard.
You can start the Package Migration Wizard from three locations.
- From SQL Server Management Studio. Connect to an instance of the SQL Server 2005 Database Engine, right-click the Data Transformation Services node in Object Explorer under Management\Legacy, and select Migration Wizard.
- From Business Intelligence Development Studio. Create or open an Integration Services Project, right-click on the SSIS Packages node in Solution Explorer, and select Migrate DTS 2000 Package.
- From the command prompt. Start DTSMigrationWizard.exe from the C:\Program Files\Microsoft SQL Server\90\DTS\Binn folder.
Thank you for quick response.
When Open or Import package by right clicking on "DTS 2000 Packages" folder, it throws "Could not load or assembly Microsoft.SqlServer.Dts80,......." error.
I have installed June CTP. I tried installing on another computer, I get same error.
Thx,
Satish Patil
Dough,
How do I install 'Legacy componenets' ?. I don't remember seeing this option.
Thx,
Satish Patil
My main point was that you need support for DTS, and that this support is a separate installation item under Client Components on the Feature Selection page (Advanced button) of SQL Server 2005 Setup. Installing Integration Services does not automatically install support for DTS. At the moment, this option is labeled "Legacy Components," but it may have had a different label in the June CTP...if so, it was more clearly labeled as the DTS 2000 runtime.
Installing Integration Services does install the Package Migration Wizard; however the wizard will not run without the legacy support components.
-Doug
I ran across this posting of mine from 3-1/2 months ago and need to point out that
it is no longer correct.
When you select the "Integration Services" checkbox for installation, all the backward compatibility files that provide run-time support for SQL Server 2000 Data Transformation Services (DTS) are automatically installed. When installing SSIS, you do not need to select "Legacy Components" explicitly to obtain DTS support (although selecting it does no harm).
Design-time support for editing DTS packages is a separate Web download.
The "Legacy Components" checkbox is still present in SQL Setup for those occasions when you might want to install DTS run-time support without installing Integration Services.
-Doug
Hi,
I just downloaded SQL Express 2005 and it looks like this feature is not available in the Express edition? Because I don't see this option in the install and and there is no DTS folder under 90.
Neil
njg at 2007-9-9 >
Hello njg@discussions.microsoft.com, Yep correct SSIS per se is not in Express. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Allan
> Hi,
>
> I just downloaded SQL Express 2005 and it looks like this feature is
> not available in the Express edition? Because I don't see this option
> in the install and and there is no DTS folder under 90.
>
> Neil
>
Doug,
Does it work for 64 Bit? Can you Edit DTS packages at all? Connection strings?
Thanks,
Tom
