Search code examples
sql-serverdts

Open a .BAS DTS Package in SQL 2000?

You can save a SQL Server 2000 DTS package as a VB .BAS file. Is is possible to open a .BAS file in SQL Server Enterprise Manager (or some other way) to add the DTS package to the server? Initally, it appears that SQL Server only lets you import .DTS files.

Solution

  • Actually, it is possible although it's fiddly:

    Running a DTS Package Saved as a Visual Basic File