"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:
> > 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:
> >
> > > 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
> > >
> > >
>