Post reply

What happens internally when an DTS is opened

  • March 2, 2012 at 9:26 pm

    #254173

    1. A curious doubt. What happens internally when an DTS is opened in SQL 2000, 2005, 2008?

    2. Are there any major differences in the way an DTS is opened in 2000, 2005, 2008?

    I remember vaguely reading that when an dts is opened, it looks at Registry to check database connections

  • March 3, 2012 at 11:06 am

    #1454469

    Check this.

    http://msdn.microsoft.com/en-us/library/ms345120(v=sql.90).aspx

  • March 3, 2012 at 11:28 am

    #1454475

    balasach82 (3/2/2012)

    1. A curious doubt. What happens internally when an DTS is opened in SQL 2000, 2005, 2008?

    2. Are there any major differences in the way an DTS is opened in 2000, 2005, 2008?

    They will all open using an application called DTSrun.exe. I've not checked if the exe version number differs but I expect it does

    balasach82 (3/2/2012)

    I remember vaguely reading that when an dts is opened, it looks at Registry to check database connections

    That would only occur if it were using an ODBC connection

  • March 3, 2012 at 11:29 am

    #1454476

    SSIS is a different beast to DTS so if you want to know more about those internals it's likely you need to be more specific.

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

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