none
can not add reference to Microsoft.SqlServer.DtsRuntimeWrap

    Question

  • i have sql server 2008 sp1 64 bit.I am trying convert connection manager to oldedb connection in script task. i need to add reference to Microsoft.SqlServer.DtsRuntimeWrap assembly. i have found dll in C:\Windows\assembly\GAC_64\Microsoft.SqlServer.DTSRuntimeWrap\10.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.DTSRuntimeWrap but when i tried to add file get error message file name is not valid. have anyone experienced same issue before? please let me know. Thanks

    Tuesday, July 19, 2011 4:38 AM

Answers

  •  Tod why it is a bad idea to use connection manager in script task?

     

     

    Todd means that you have bunch of tasks and transformations which help you do many things, and using script task for usual tasks is counter-productive, obviously you can do anything in scripts, but you can do many things with other tasks which sometimes made more efficient. It is better to use script task when other tasks couldn't help you.

    http://www.rad.pasfu.com
    My Submitted sessions at sqlbits.com
    • Marked as answer by Eileen Zhao Monday, July 25, 2011 2:23 PM
    Wednesday, July 20, 2011 5:44 AM

All replies