--input string

declare @s-2 as varchar(max)

set @s-2 = '47,48,49,92,93,94,95,96,108,107,37,27'

--input string delimiter

declare @delim as char(1)

set @delim = ','

--variable for output string

declare @o as varchar(max)

set @o = ''

--use tally...

--create table variable

declare @Table table(Id int identity(1,1), Var1 bit, Var2 bit, Var5 bit, Var7 bit, Var9 bit)

insert into @Table(Var1, Var2, Var5, Var7, Var9)

select 0, 1, 0, 0, 1

union all

select 0,...

In your Connection properties set:

RetainSameConnection = True

In associated Data Flow Task you may need to set property ValidateExternalMetaData = False

See the following for explanation and walkthrough: