SSIS Script Task 2008

• m--S3qU3L

  Hall of Fame

  Points: 3706

  More actions

  November 25, 2011 at 4:12 am

  #251234

  Hi Friends,

  A quick question.

  I'm trying to use SQLDMO in SSIS 2008 script task to handle an old server.

  I have added the reference to SQLDMO DLL from the script task. But the problem is when I close and reopen the script task, the reference no longer exists.

  This is preventing me to use the SQLDMO classes.

  Any help will be useful.

  Thanks in advance.

  John

• Bill Hansen

  Ten Centuries

  Points: 1201

  More actions

  November 25, 2011 at 12:33 pm

  #1413060

  Make sure you save the Script Task before Clicking "Ok" and exiting out.