Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-24 : 10:07:40
|
| Doug writes "Is there a way to force a DTS package to use only one pair of connections to an odbc source. ie 1 connection to ODBC source and 1 connection to the sql server (7.0)?I run into in issue where I have one license to the odbc source and if I create a dts package using the wizard and attempt to import two tables, my license is exceeded and the second table import fails.Is there a way to force all dts packages to use the same two connections? or a way to create one dts package that would either import (drop/create and/or update) approximately 30 tables?Sql 7.0 Nt 4.0 sp 6aThanks for your advise.Doug" |
|
|
|
|
|
Problem with DTS packages creating mulitple connections to a odbc and exceeding license count