Man, ...

You guys are good!!!  Thanks Mike, Michael, and Luke.

Hi Back -

I'm sure the answer is "use a Dynamic Properties Task" - but not being the adventurous type, I would probably find a way to do this all...

OK Folks:

The answer was "apply the service pack" - I believe this was SP3 and if you run it from your client...

Hi Hans

Do you completely remove the Connection for DB1 - and then add a brandy new connection for DB2?  Are you using the vanilla SQL Server Connection in the...

Thanks for the feedback so far.  Kamlesh, without "writing a book" about our environment, let me say the following:

The two servers dedicated to DTS jobs have about 25-30 jobs...

Durn!  Looks like you'll have to write script code on the transformation.  Sorry!

I'm new to DTS too but doesn't the Keep NULL Values check box do this??

Hi Chris - I had to go home and go to sleep for a while.  OK, so suppose you have imported from the file to a staging table whose columns...

Chris - Very well.  In the ftp file - how are the fields coming in?  Fixed format or delimiter (e.g., comma) separated?  Do you have both numeric values AND text...

Hi Chris - A few questions first.  Going back to the beginning - you say you get the mainframe ftp'd to you.  Are you sure the data in the file...

Thanks Tal -

Right on the money.  It was security.  I appreciate the response.

Steve -

You can use xp_cmdshell to execute just about anything (given you have the permission).  Don't know if this would violate 'best practices' to call from a trigger??

HTH

Angela

Thanks for staying with me as I dig this out of BOL.  The stored procedure sp_autostats proves you right on the money.  If you just follow sp_autostats with the...

Thanks Angela

I've looked at BOL.  And after digging around I do see that at least SS will not automatically update stats that it has also automatically created (I think...

And here are a couple more:

http://www.sqlservercentral.com/scripts/contributions/407.asp

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