All geek questions in one place

Open .BAS DTS package in SQL 2000?

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

+3
source share
3 answers

Actually, this is possible, although it is inconvenient:

Running a DTS package saved as a Visual Basic file

+4
source

No, this is impossible to do. Saving to a .BAS file is only one way. However, you can compile the file with VB6 and run it as an executable from another DTS package. You can also change it, perhaps by adding CL options to use it as a standalone program.

EDIT: () - MSDN, . +1.

+3

Yes, maybe follow the link in the previous answer. Another little thing ... when you uncomment the goPackage.SaveToSQLServer file, you can use the flags parameter to indicate a reliable connection, for example:

goPackage.SaveToSQLServer "(local)" ,, DTSSQLStgFlag_UseTrustedConnection

Thus, you do not need to set a password in your code.

+1
source

Source: https://habr.com/ru/post/1699481/

More articles:


All Articles