I use a Transform Data Task to copy several tables from a Progress database
to a SQL Server database. Durring this process each table being copied uses
another license on the source database and then releases them all when the
DTS job completes. The problem is that sometimes there are not enough free
licenses available for the entire job and it fails.

Is there a way to force DTS to disconnect or give back licenses half way
through the job?

Thanks!

Mike

Whilst I have never had this problem does setting "Close connection on
completion" in the workflow properties of the task work ?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mike" <mbaith (AT) yahoo (DOT) com> wrote

I can't seem to locate "Close connection on completion" Where should I look?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Never mind I found it...

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Allan,

I just checked the box and now it is disconnecting after each one.

Thank you!!!!!

Mike

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote