Hello,

I exported a package to vbscript. Then I tried to paste the code back into
a new package using the "ActiveX Script Task". However, this didn't work.
Is there any reason why this wouldn't work since it was created by the DTS
package?

--
Thanks in advance,

Steven

In article <OopuqNBaDHA.388 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Steven K
<sckeels (AT) lucent (DOT) com> writes
I am not aware of any Export to VBScript functions or tools how do you
do this, or did you export to VB, and get confused? The two are not the
same language at all.

SQL 7.0 came with ScriptPkg, and SQL 2000 Enterprise Manager has a Save
As VB option in the Save As dialog. The VBScript code will be
significantly different, primarily because VB is strongly typed language
and VBScript is not. You should still be able to convert VB to VBScript
with a bit of effort.

Why create a package in ActiveX Script at run-time. Would it not be
easier to develop, debug and maintain as a normal package. This package
could then be executed from an ActiveX Script Task or through the
Execute Package Task.

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