I have some DTS packages that load a flat file to the SQL 2000 database
and then to a AS 2000 cube. I want to migrate this to SSIS on SQL 2005
and AS 2005 kindly explain the procedure for the migration.

Thanks
Karen

Karen,

Use the DTS Migration wizard. You can start the wizard either from SQL
Server Management Studio (SSMS) or from SQL Server Business Intelligence
Development Studio (BIDS). If you start it from SSMS, expand the Management
folder, then expand Legacy. Right-click on Data Transformation Services and
choose Migration Wizard. If you start it in BIDS, you need to first create a
project of Integration Services type. Right-click on the SSIS Packages folder
in Solution Explorer and choose Migrate DTS 2000 Package.

Migration may not be perfect as some DTS features are not supported in SSIS.
With some packages, you are better off creating them from scratch in SSIS.

Hope this helps.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk




"KarenM" wrote:

Charles,

Many thanks for your advice. Can I install the SQL 2005 instance on the
same server running SQL 2000.

Thanks
Karen
Charles Kangai wrote:

Hi Karen,

You can install a named instance of SQL Server 2005 on the same box as SQL
Server 2000, if SQL Server 2000 is already the default instance. For now, you
can develop your packages and perform your migrations on that system.
However, when you come to deploying the packages, deploy to a different
server as SSIS does not support named instances.

Hope this helps.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk


"KarenM" wrote: