Wednesday, March 21, 2012

DTS Package to VB

One can save a DTS Package to a VB .bas file. Can you modify the VB
code and then reload the package and execute it? I can see an option to
save a package to vb but can't see an option to open a vb file as a
package.
RonI'm using .NET and could not get the VB program to compile using the
example in the DTS Help. I was getting a "Statement is not a valid
namespace" for the following statements:
Public goPackageOld As New DTS.Package
Public goPackage As DTS.Package2
I work with C# and Java and am not that familiar with VB.NET.
Any help appreciated.
Ron|||hi,
As far as I know it is not possible. As you said, oneself is be able to save
into .BAS file and then modify and save it again and even executing from VB
6.0 using dtspkg.dll. Why don't open it through sql server 2000/2005?
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)
"RonL" wrote:

> I'm using .NET and could not get the VB program to compile using the
> example in the DTS Help. I was getting a "Statement is not a valid
> namespace" for the following statements:
> Public goPackageOld As New DTS.Package
> Public goPackage As DTS.Package2
> I work with C# and Java and am not that familiar with VB.NET.
> Any help appreciated.
> Ron
>

No comments:

Post a Comment