INF: ScriptPkg Tool Generates DTS Object Model Code to Help Use DTS Programmatically

• Microsoft SQL Server version 7.0
• Microsoft Visual Basic Professional and Enterprise Editions for Windows, version 6.0

SUMMARY

The ScriptPkg tool generates a script for a given Data Transformation Server (DTS) package to help use the DTS object model programmatically. The ScriptPackage tool is contained in the DTSDemo.exe file on \DevTools\Samples\DTS folder SQL 7.0 CD.

One quick way to verify whether an OLE DB provider or ODBC driver works with DTS is to use DTS Wizards to create and save a package that imports or exports data involving that provider or driver. Once you have saved a working package in SQL Server, you can use ScriptPkg tool to script the package to a text file. The script generated by this tool gives you code examples that you can use in your application to manipulate DTS object model.

This tool is especially useful for data sources for which OLE DB provider properties are not documented, such as DTSFlatFile provider for importing/exporting text files. The tools can also be used to help troubleshoot connection string problems with ODBC drivers and OLE DB providers.

MORE INFORMATION

Steps to Use ScriptPkg Tool

1. Open the compressed DTSDemo.exe file from the \DevTools\Samples\DTS folder SQL 7.0 CD into another folder.



2. Search for the Designer sub-folder and run the Visual Basic project, ScriptPkg.vbp.



3. Make an .exe file, ScriptPkg.exe, from the File menu in Visual Basic.



4. Design a DTS package using the SQL 7.0 Enterprise Manager and save it on local SQL Server.



5. Run ScriptPkg.exe and enter the package name. The tool writes a script file (packgename.txt) to the \TEMP folder.



6. Copy and paste selected portions of code into your Visual Basic application that uses the DTS object model. For example, you can load a Visual Basic DTS sample from the \DevTools\Samples\DTS folder and modify the source or destination properties to use the code generated by the ScriptPkg tool.

Additional query words: ScriptPackage

Keywords : kbDatabase kbSQLServ kbGrpVBDB kbDSupport
Version : WINDOWS:6.0; winnt:7.0
Platform : WINDOWS winnt
Issue type : kbinfo