![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |