This is a little beyond me.  Check these threads to see if you they help:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=129223

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=54&messageid=132608

Greg

Teresita,

In Enterprise Manager, expand Management and right-click on SQL Server Agent.  The account shown as the Service startup account is the one that needs to have access to the network...

Martin,

That's just about the best article you'll find.  I've used all three methods (detach/attach, export/import, backup/restore) to move databases and they all work.  You may get other suggestions for how...

Mike,

You could create a DTS package that runs the stored procedure in an Execute SQL task, then on success export the data from the table to Excel with a Data...

Do a search on SQL Server Central for "long running job" and explore some of the articles and suggestions in the forums listed.  Several people seem to have figured out...

Can you post the error message?  Is it related to executing the package itself or something that is contained in the package?

More details about the error will help to pinpoint...

You wouldn't call the stored procedure or Execute SQL task from the Transform Data task.  Both DSP's and my solutions depend on the source data being in a SQL Server...

Could he mean to refresh the data in the database i.e. copy data from a production database?  I'd say you should reply to the email and ask the developer exactly...

Brad McGehee has a site with good advice on performance tuning:

http://www.sql-server-performance.com/

Greg

According to Books onLine and my 'Professional SQL Server 2000 DTS' book, you can designate an entire directory to FTP by clicking the double arrow (>&gt

I think you're on the right track looking at authentication.  Scheduled jobs run under the security context of the Windows account specified for SQL Server Agent.  It probably doesn't have...

Was the DTS package created by the Copy Database Wizard?  The only thing I can think of is you don't have the necessary permissions in the msdb database on the...

You could also put both INSERTs in a single stored procedure or Execute SQL task.  Insert the Employees table, then use the SCOPE_IDENTITY function to get the new ID value...

You can't turn off logging.  Your best bet is to ensure that Tempdb has a large enough initial size and is set for automatic growth.  See "Optimizing tempdb Performance" and...

There's a section of SQL Server Central for member contributed freeware.  Select "Resources" then "Products and Books" on the navigation bar at the top of the page.

Greg