Post reply

DTS import Wizard- Where are the files stored

  • August 30, 2007 at 4:00 am

    #176468

    Have just imported my DTS packages from SQL 2000 into SQL 2005.  I can see and run the packages in Intergration Services, but how do I edit them.  I guess I use the SQL Server Business Intelligence Development Studo but where has the wizard stored the imported DTS files so I can edit them?

    Or am I thinking this is only a one way conversion and you are unable to edit anything.

  • August 30, 2007 at 5:12 am

    #730382

    Kevin,

    if you want to edit SQL 2000 DTS packages you need to install SQL Server 2000 DTS Designer Components which you can download here: http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

    BIDS can only edit SSIS packages. The packages are either stored in your msdb or on the file system. The default location would be your my documents folder, but if you can find them there search for files with a .dtsx extension.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • August 30, 2007 at 6:56 am

    #730411

    Thanks Markus, now I can start to make my changes

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply