SQL 2005 Migration Questions ! Simple Tasks !!

• John Burchel

  Hall of Fame

  Points: 3611

  More actions

  November 22, 2006 at 8:38 am

  #121582

  Hi All,

  I am currently looking to put together a test migration and would like to know how to complete the following tasks:

  1. Running a DTS package from SQL 2005: On sql 2000, you can call DTS packages using xp_cmdshell, I am not sure of this is possible with 2005.
  2. Import/Export into Excel from sql 2005: Within SQL 2000, you can export data from sql to excel files using transformation tasks, is this possible with SQL 2005 ?
  3. Migrating SQL Agent Jobs Over: How can this be done within SQL 2005 ? etc
  4. Can you run DTS packages remotely or does it have to be done on the server ?
  5. Sending emails: Are there any send mail functionalies built into SQL 2005 that can be called from a SQL job programatically ?

   

  ---

  Kindest Regards,

  John Burchel (Trainee Developer)
  

• November 27, 2006 at 8:00 am

  This was removed by the editor as SPAM

• zake

  SSC Enthusiast

  Points: 158

  More actions

  November 28, 2006 at 10:13 am

  #674456

  Hi,

  Not sure that this helps you, but... In order to send mail, (use SQL Mail), you must install an e-mail application that supports Extended MAPI on the computer that runs SQL Server

   

• Rich Hansell

  SSCrazy

  Points: 2346

  More actions

  November 28, 2006 at 11:49 am

  #674477

  1: Yes you can call DTS with Sql2005

  2: Yes, you can use Excel file sources and destinations

  3: Not sure if there is an automated way to migrate. Could try scripting it out and creating that way

  4: Yes, you can fire DTS remotely (Dtexec) Or SSMS

  5: yes .. you will have to enable Database Mail and you can reference with sp_send_dbmail