Home Forums SQL Server 2005 SQL Server 2005 Integration Services how to use parameters in SSIS update query having CASE[ Giving Error] RE: how to use parameters in SSIS update query having CASE[ Giving Error]

  • June 6, 2013 at 6:30 am

    #1621704

    Try this

    declare @janflag as varchar(56)

    declare @febflag as varchar(56)

    BEGIN

    set @janflag ='y'

    set @febflag ='y' --[ SELECT TOP 1 febfl FROM saupdate ]

    <<ALLL your udpate statements here>>

    End

    Vikash Kumar Singh || www.singhvikash.in