very good suggestions- Thanks!

Question regarding recompilig the sp- sp_recomplile 'spName' will recopile any give sp.  Creating the sp with "WITH recompile" causes the sp to be recompiled each time it is...

the sql is very straight forward:

Truncate TableName

insert into TableName (FieldList)

Select Fields

From TableA a

   Join TableB b on a.Acct_id = b.Acct_id

The sql being run in query analyzer is identical to that...

I've tried the Shrink/Backup approach without success.  It never goes below the size allocated in the database properties.  To backup the log I’m using:

BACKUP LOG @DBName, WITH...

I found the answer at

http://support.microsoft.com/default.aspx?scid=kb;en-us;318819

On the Workflow properties of the dts package, checking "Execute on main package thread" fixes the issue.  The package now runs and quits...

I found the answer at

http://support.microsoft.com/default.aspx?scid=kb;en-us;318819

On the Workflow properties of the dts package, checking "Execute on main package thread" fixes the issue.  The package now runs and quits as...

I ran this from a command window.  The dts package ran its last step but would not return to the command prompt.  The last message was:

DTSRun = Package execution complete.

A blinking...

thanks!  I was trying to make it to difficult!