HOW? Saving a "Package2" as Visual Basic

#1

It seems most DTS package manipulations are available
programmatically, but I am not finding this one. Thanks for any clues
(or confirmation it just isn't there!)

Best regards - Lee Gillie - Spokane, WA

#2

You are correct, there isn't a programmatic method for saving a package as a
VB file. This feature is implemented internally by the Package Designer not
through the object model.

--
--Brian
(Please reply to the newsgroups only.)

"Lee Gillie" <ANTISPAMIFICATION_lee (AT) odp (DOT) com> wrote

Quote:

It seems most DTS package manipulations are available
programmatically, but I am not finding this one. Thanks for any clues
(or confirmation it just isn't there!)

Best regards - Lee Gillie - Spokane, WA

#3

In message <#aEmRzN1DHA.4060 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Brian Lawton
<lawton (AT) rdacorp (DOT) com> writes

Quote:

You are correct, there isn't a programmatic method for saving a package as a
VB file. This feature is implemented internally by the Package Designer not
through the object model.

....but you could dig out a copy of ScriptPkg, and sample tool that

shipped with SQL 7.0. This is a VB program that generates VB code for a
package, but will need updating for SQL 2000, but this shouldn't be a
major job.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

HOW? Saving a "Package2" as Visual Basic

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

HOW? Saving a "Package2" as Visual Basic - 01-06-2004 , 07:04 PM

Re: HOW? Saving a "Package2" as Visual Basic - 01-06-2004 , 11:12 PM

Re: HOW? Saving a "Package2" as Visual Basic - 01-07-2004 , 02:16 PM