468,532 Members | 1,676 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,532 developers. It's quick & easy.

Help with DTS package running in Visual Basic .NET

Hi all,

I created a DTS package in SQL Server 2000 that creates several stored
procedures. I need to run this package as part of an installation program
for an application that uses the stored procedures. In the past I saved the
DTS package as a Visual Basic file, compiled the Visual Basic file in the
Visual Studio 6.0 environment and ran the executable during the installation.

I want to do the same thing using Visual Basic in Visual Studio 2005 but I
can't get past this compiler error:
error BC30547: Interface 'DTS.OleDBProperties' cannot
be indexed because it has no default property.

Below is the offending code:
oConnection.ConnectionProperties("Integrated Security") = "SSPI"
oConnection.ConnectionProperties("Persist Security Info") = True
oConnection.ConnectionProperties("Initial Catalog") = "SSM6000"
oConnection.ConnectionProperties("Data Source") = "SSM_6000_SWE"
oConnection.ConnectionProperties("Application Name") = "DTS Designer"

Any help would be greatly appreciated!

Thanks in advance,

Nov 9 '06 #1
0 1084

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Pattnayak | last post: by
reply views Thread by Brian | last post: by
5 posts views Thread by dm3281 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.