Post reply

SQL 2005 Job calling DTS

  • January 21, 2010 at 1:03 am

    #218401

    Hi All,

    I've been tasked to convert DTS packages to SSIS for our move to SQL 2008. The DTS packages

    are called in jobs from our SQL 2005 instance. Now, the problem is that there is a DTS job being

    called like this:

    DTSRun /~Z0x938B5D31BF1C95D4D9BCBEC92F5AC8535E4E67CA2F2D76013FC7C8FFF0BBC3B3B72810

    D3B2AA8297A5724EFD4BB0E54046C78EF0C869182FCA6D693FC8A74B7A1E3F772473590C5738AFBCA5

    B4F47CFB0D57FD8986C7A2AED6C5FFB9FB8C9E1407A50D95FEC24E58CFD69C8DA42D5643FB2C6764FD

    8CC5522A13A3B66F2BBBDF5A01776F201D7F77F7578FC2DDAD13FC13BBB3C42DB414FE31BB3C1B15A3

    143CF873FBE2518109F6B7F23ED0CD1017EFC3035E24F39D7086FC315EA2D1FAB70B3BE1C4FB72EA593A

    AE7C080E4AA51FCF4F2BB23C4AB68E70E18D8DF182126BB6CA717639933D8C7065B435

    I'm not sure but this looks like hex?? Can anyone tell me how I take the above information and turn it into

    something useful like a DTS package name for instance?

    🙂

    Cheers

    William

    ----------------------------------------------------------------------------------------------
    Struggling to find the question?
    http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

  • January 21, 2010 at 3:37 am

    #1106572

    Have you tried the suggestion in this post ??

    http://www.sqlservercentral.com/Forums/Topic162801-19-1.aspx

  • January 21, 2010 at 4:10 am

    #1106584

    Thanks, I'll use that post for assistance.

    ----------------------------------------------------------------------------------------------
    Struggling to find the question?
    http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

  • January 21, 2010 at 11:35 am

    #1106876

    In particular, the method described by Dale Cunningham in that thread has always worked for me.

    Greg

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

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