Post reply

SQL 2005 Migration Questions ! Simple Tasks !!

  • 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

  • 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

     

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply