Post reply

Running legacy DTS packages with an SSIS wrapper under SQL Server 2005 agent?

  • November 23, 2007 at 2:52 pm

    #176997

    Hi,

    I am somewhat of a newbie to SQL Server. I know that SSIS is replacing DTS when we migrate from 2000 to 2005. But my group does not have the time to convert all of the DTS packages before we go live on SQL Server 2005. I saw on Google that you can run a legacy DTS package via SSIS wrapper using O/S type command in SQL Server AGent.

    Would anyone be able to give some pointers? And maybe post an example of what the command would look like under SQL Server Agent?

    Thanks in advance,

    Bret

  • November 24, 2007 at 2:17 am

    #753737

    hi !

    You can definatly do that but SSIS also give u facility to run DTS packges creatde in 2000 using Execute DTS 2000 package task.

    Regards,

    Abhijit More

  • November 26, 2007 at 8:19 am

    #754069

    Bret,

    Your jobs should migrate with 0 changes. The DTSRUN is available on a 2005 SQL Server with the backward compatability pack installed. GIve it a try your self. Remote into a 2005 server, open a command window and enter DTSRUN /?. Grab one of the DTSRUN commands from an existing job step and paste it into the command window. It should work fine.

    Norman

    DTS Package Search

    http://www.dtspackagesearch.com/

  • December 6, 2007 at 9:20 am

    #757733

    Thanks for the responses. I will give it a try once we are at that point.

  • April 22, 2008 at 10:45 am

    #805630

    Hi,

    but is DTSRUN also applicable for running DTS packages in a 64bit SQL Server environment? or do you have to create an SSIS wrapper?

    I read somewhere that SQL Server 64bit does not provide runtime for DTS

    Thanks

  • October 20, 2008 at 11:48 am

    #887259

    in regards to x64:

    Check out this link.

    I'm dealing with this headache now.

    MCITP, Database Administrator
    A hodgepodge of Information Technology and Life
    LinkedIn Profile
    My Twitter

  • January 16, 2009 at 5:35 am

    #927987

    Has someone got a workaround on this please?

  • January 19, 2009 at 6:53 am

    #929191

    I have resolved the problem.

    Please visit http://www.developersdex.com/sql/message.asp?p=1865&r=6538809

    for more details.

  • August 6, 2010 at 6:20 am

    #1203428

    tadewusi (1/19/2009)

    I have resolved the problem.

    Please visit http://www.developersdex.com/sql/message.asp?p=1865&r=6538809

    for more details.

    This link no longer works??? Can you post the resolution or repost the link???

Viewing 9 posts - 1 through 9 (of 9 total)

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