Lee,

Tasks using the same connections are run serially because only one task at a time can use a connection.  If you want to have tasks run in parallel you must have...

Jessica,

Can you elaborate on what log file you're concerned about?  Is it a database transaction log or a SQL Server error log?

Greg

Me too.  Good luck with this, Stephanie.  It sounds like you're suffering for someone else's screwup.

Greg

Those terms aren't used in SQL2000, so don't feel bad about that.  BTW, there are lots of good articles about migrating and upgrading to SQL2005 on this site and on...

Tasks are listed in Disconnected Edit in the order they were created, not in the order they execute.  Workflow controls the order of execution.  Is that what you're worried about?

Greg

Sounds kind of unreasonable to rush into a migration to SQL2005.  It can be a pretty big deal.

The common recommendation is to download and run the SQL Server Upgrade Advisor...

To each his own, but I don't get why you'd use a DTS package instead of a scheduled job with the backup commands in job steps.  Can someone tell me...

"I really wish all of us would learn to use the english language properly."

"irregardless"?!?

I don't think developers need access to master.  Hopefully they aren't members of sysadmin!

Replication provides a warm standby with no automatic failover, though I seem to remember a product from CA that might provide automatic failover.  Clustering and Database Mirroring are the only...

We use the procedure that Thomas described in our shop.  DTS packages are treated the same as stored procedures.  Developers and users test them in dev and test, then the...

Does the account that runs SQL Server Agent have access?  The package will be run in the security context of that account and it must be a domain account to...

Nirvana - Nevermind

Neil Young - Live Rust

U2 - Boy

REM - Document

Albert King - Baby, I'm in a Phone Booth

Your best bet with DTS is to import the file into a staging table that has columns corresponding to the logical fields in the flat file.  Then, you can you...

SQL Server gets it's time from the OS, so no patch is needed.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=339222

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=332998