dbTalk Databases Forums  

Upgrading from DTS package in vb6 to vb.net

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


Discuss Upgrading from DTS package in vb6 to vb.net in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jim
 
Posts: n/a

Default Upgrading from DTS package in vb6 to vb.net - 08-12-2004 , 01:37 PM






This may not be the right fourm. Need a little help.

I am converting an MSSQL Server wizard generated Export DTS package to
vb.net and need the default for a connection object. Here is the code giving
me the problem.

'UPGRADE_WARNING: Couldn't resolve default property of object oConnection.

goPackage.Connections.Add(oConnection)

UPGRADE_NOTE: Object oConnection may not be destroyed until it is garbage
collected. Click for more:
'ms-help://MS.VSCC.2003/commoner/redir/redirect.htm?keyword="vbup1029"'

oConnection = Nothing

--
Jim

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Upgrading from DTS package in vb6 to vb.net - 08-12-2004 , 02:04 PM






In message <C16DFC21-BBD6-4AAE-9C36-1EBFB022D31B (AT) microsoft (DOT) com>, Jim
<Jim (AT) discussions (DOT) microsoft.com> writes
Quote:
This may not be the right fourm. Need a little help.

I am converting an MSSQL Server wizard generated Export DTS package to
vb.net and need the default for a connection object. Here is the code giving
me the problem.

'UPGRADE_WARNING: Couldn't resolve default property of object oConnection.

goPackage.Connections.Add(oConnection)

UPGRADE_NOTE: Object oConnection may not be destroyed until it is garbage
collected. Click for more:
'ms-help://MS.VSCC.2003/commoner/redir/redirect.htm?keyword="vbup1029"'

oConnection = Nothing

Converting a DTS Package from Visual Basic 6.0 to Visual Basic .Net
(http://www.sqldts.com/default.aspx?264)

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

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



Reply With Quote
  #3  
Old   
Jim
 
Posts: n/a

Default Re: Upgrading from DTS package in vb6 to vb.net - 08-12-2004 , 03:53 PM



Darren,

Great referances, but do you know what the default property of a
DTS.Connection2 is. That seems to be the issue that I can't get resolved.

Thanks

"Darren Green" wrote:

Quote:
In message <C16DFC21-BBD6-4AAE-9C36-1EBFB022D31B (AT) microsoft (DOT) com>, Jim
Jim (AT) discussions (DOT) microsoft.com> writes
This may not be the right fourm. Need a little help.

I am converting an MSSQL Server wizard generated Export DTS package to
vb.net and need the default for a connection object. Here is the code giving
me the problem.

'UPGRADE_WARNING: Couldn't resolve default property of object oConnection.

goPackage.Connections.Add(oConnection)

UPGRADE_NOTE: Object oConnection may not be destroyed until it is garbage
collected. Click for more:
'ms-help://MS.VSCC.2003/commoner/redir/redirect.htm?keyword="vbup1029"'

oConnection = Nothing

Converting a DTS Package from Visual Basic 6.0 to Visual Basic .Net
(http://www.sqldts.com/default.aspx?264)

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

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



Reply With Quote
  #4  
Old   
Darren Green
 
Posts: n/a

Default Re: Upgrading from DTS package in vb6 to vb.net - 08-13-2004 , 02:28 AM



Have a quick think about it and it doesn't make a whole lot of sense for
what it is saying, and you don't get an error so forget about it.

"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote

Quote:
Darren,

Great referances, but do you know what the default property of a
DTS.Connection2 is. That seems to be the issue that I can't get resolved.

Thanks

"Darren Green" wrote:

In message <C16DFC21-BBD6-4AAE-9C36-1EBFB022D31B (AT) microsoft (DOT) com>, Jim
Jim (AT) discussions (DOT) microsoft.com> writes
This may not be the right fourm. Need a little help.

I am converting an MSSQL Server wizard generated Export DTS package to
vb.net and need the default for a connection object. Here is the code
giving
me the problem.

'UPGRADE_WARNING: Couldn't resolve default property of object
oConnection.

goPackage.Connections.Add(oConnection)

UPGRADE_NOTE: Object oConnection may not be destroyed until it is
garbage
collected. Click for more:
'ms-help://MS.VSCC.2003/commoner/redir/redirect.htm?keyword="vbup1029"'

oConnection = Nothing

Converting a DTS Package from Visual Basic 6.0 to Visual Basic .Net
(http://www.sqldts.com/default.aspx?264)

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

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





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.