Like I said, you can do this by creating an SSIS package. Since you're going to do this often, you could save the package and run it when you...

Are you looking for a tool other than DTS? I assume you know that DTS is capable of doing all you've described.

The Import/Export wizard in SQL 2005 does not include the Transfer SQL Server Objects task like the SQL 2000 version did. The task is only available when you create...

If these are legacy DTS package, not SSIS packages, you can save them as VB files and search them with a text editor. There are scripts in the Script...

NDAs are also common for employees of government entitities. I work for a tax administration agency and we have to sign a nondisclosure agreement with annual refresher training on...

In SSMS, create a new job with a new job step. Set Type as "Transact-SQL script (T-SQL)" and type your T-SQL directly in the Command box. Alternately, you...

The run_date and run_time columns in sysjobhistory show when the job started. Look at sysjobschedules and sysschedules for schedule data. You might also want to look at sysjobactivity.

I'm not sure exactly what you're asking. By 'job time' do you mean the time a job started executing? By 'frequency type' do you mean the job...

Since that article was written in 2004, it has been changed to Integration Services Project.

Steve Jones has said that nobody loses points for choosing a...

Duplicate post. See reply here: http://www.sqlservercentral.com/Forums/Topic464418-169-1.aspx

It's a repository for SQL Server configuration values. Look at sp_configure to see what it updates in spt_values.

I just realized you're asking about using SSIS. What you're asking about is not backup and restore per se, but exporting a table and importing it if needed. ...

The only way to backup single tables using native SQL Server backup is to put each table in it's own filegroup and do a filegroup backup and restore. Some...

Those two messages are generated every time you run Upgrade Advisor, regardless of whether you have packages stored in MetaData Services or have DTS Designer components installed.

If you don't store...