There are three options: BCP, OpenRowSet, and SSIS(or DTS).

The Import/Export Wizard in SSMS uses SSIS and is a good choice for one time exports or imports. If you need...

You can do it if Enterprise Manager was or is installed on the machine where you've installed SSMS because the information is written to the registry.

In the Registered Servers window...

You don't necessarily need to have linked servers to be able to access data on other servers in DTS, but you haven't given enough information to give any more advice....

Yes, that's useful for SQL 2000. You don't need it in SQL 2005 because Database Mail uses SMTP and doens't require a mail client.

I believe you can get that from the default trace. Security events are in the 104 - 114 range. You can also set up a server DDL trigger...

Please don't cross-post in multiple forums.

See responses in this thread: http://www.sqlservercentral.com/Forums/Topic717297-145-1.aspx

Are you using a stored procedure in the package? If so, this thread may help: http://www.sqlservercentral.com/Forums/Topic171035-9-1.aspx#bm341953

This is usually the result of executing the package as a different login than the one that created the package. When you run the package in BIDS, you're running...

You can send an email from a job step by using xp_sendmail (SQL 2000) or sp_send_dbmail (SQL 2005). In both, use the @query argument to specify the stored procedure....

You need to put a Data Conversion Transformation or a Copy Column Transformation between the source and destination. That's what specifies the movement of data from the source table...

If the destination connections in the package are using Windows authentication, then yes, you need to have access to the destination server although it's not the owner of the package...

If you're still talking about copying data with SSIS, just use a query in the Data FLow task that compares the current time with what's in the datetime column in...

There isn't any way to actually combine packages. You'll have to add the tasks and workflow for one of the tables, say Psalesorder, to the package for Customer table.

Another...

You could query the sysjobschedules table in msdb which contains the next run date and time for all jobs. Something like this would get the job names also:

select name,...

The security principal at the database level is called a user, not a login. I think that's what confused the previous posters. I've used a version of this...