Foreach SMO Enumerator

• planetmatt

  SSCrazy

  Points: 2207

  More actions

  April 11, 2008 at 2:56 am

  #121130

  I am trying to use the ForEach SMO Enumerator to loop through all the databases on a server. This works but I need to filter the databases to exclude certain ones like Master, MSDB etc..

  I have the logic already written in TSQL and there all I do is use a cursor and say where name not like (master, msdb etc....) How do I model this in SSIS?

  I think I need to filter the loop using an expression but I'm not 100% what the expression needs to be.

• bhushan_juare

  Ten Centuries

  Points: 1292

  More actions

  July 13, 2011 at 12:18 am

  #1351962

  Could you please tell me how you have configured Foreach SMO Enumerator in detail?

  I tried but failed to configure.

  Thanks.