DTS to SSIS migration

• kk.86manu

  Ten Centuries

  Points: 1268

  More actions

  January 10, 2012 at 5:32 am

  #262679

  Hi All,

  I have a DTS package which is passing query given below through a dynamic property task.

  select 'Countinue' =

  CASE

  WHEN count(*) > 0 THEN 1

  ELSE 4

  END

  from TablenameA

  where

  File_Type = 'Member'

  and Process_File_Status ='N'.

  Iam currently trying to migrate this package to SSIS.Can anyone please let me know how to pass the above query.

  Your help would be appreciated .

• azdzn

  SSCarpal Tunnel

  Points: 4128

  More actions

  January 10, 2012 at 5:45 am

  #1431034

  I think this post might help you :

  http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/292c26f3-05b9-45fe-bd55-b35099de07e4/