Post reply

Is it possible to import all .dts files rather than one at a time?

  • February 15, 2008 at 11:14 am

    #186618

    I tried using the migration wizard to import .dts files but do not see them under the Legacy> DTS list. If I use the Import file wizard, I do. But I can only import one at a time. Any idea how I can import all .dts files and see them under the DTS screen?

    I found this great script to export them all from 2000 here

    http://www.databasejournal.com/features/mssql/article.php/3404001

    ¤ §unshine ¤

  • February 18, 2008 at 5:31 am

    #779297

    I think there was a third party tool I used when I did a migration from 2k to 2k5. Have you tried dtsbackup?

    Pretty sure I was able to make that work... though it was a long time ago now so can't remember how!!

    PS: I just tested it again and it does work...

    Kindest Regards,

    Frank Bazan

  • February 21, 2008 at 9:05 am

    #780707

    Awesome! It worked. I was beginning to think no one replied to these things... Thank you so much!!!! 😀

    ¤ §unshine ¤

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

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