You can do it but you can't just right-click on the package and schedule it like you could in Enterprise Manager. You'll have to explicitly create a job and...

Sure. You just have to use a Transfer Data task for each table.

In my experience, db_datereader and db_datawriter were not enough to modify stored procedures in SQL 2000 unless the developer is the owner of the procedure. Our developers are members...

It's been a while - about five years - but I used DTS to copy data from Oracle to SQL Server. If you're using SQL 2005, you'll want to...

When you removed the rows manually, you used DELETE FROM which will work on a table referenced by a foreign key constraint, while the Import/Export Wizard uses TRUNCATE TABLE. ...

In that case, I suggest you set the parameters for sp_add_job, sp_add_jobschedule, and sp_add_jobstep with data selected from msdb.dbo.sysjobs, msdb.dbo.sysjobschedules, and msdb.dbo.sysjobsteps. If you run it every day, you...

We allow developers to create and run packages in a dev environment but only DBAs can move it to and schedule it in production.

The easiest way to copy jobs is to script them as CREATE JOB statements on the source instance and run the scripts on the destination instance. You can click...

How frequently you backup the t-logs depends on how busy transaction-wise the database is. Hourly works for most of our OLTP databases.

You can shrink the file once you have...

To emphasize what Vee said, if you do transaction log backups frequently enough, log file growth should be manageable. Keep in mind that a log backup won't shrink the...

No. You have to move the logs separately. If you log to SQL Server, the data is in msdb- sysdtspackagelog, sysdtssteplog, sysdtstasklog. if you log to an...

It's listed under system views in each database.

Have you tried using the scripting function in Enterprise Manager?

I installed it on my workstation and ran it against all of our SQL Server instances over the network. It had no noticeable affect on performance of either the...

If the database uses the full recovery model you could try one of the log reader/recovery tools. I hear RedGate has a free downloadable tool.

If the database uses the...