variables - OLEDB Source dosn`t receive Sql Statment from Skrip Task -


i have problem script task. have package foreach loop container contains skriptask creating sql statment variable. variable defined , contains default value
when after execution skripttask i`m trying create dataflow (oledb source) has sqlstatment variable, oledb getting default value variable , not new 1 script.

is options miss?

thanks lot!

update:

case "feed" msgbox("feed") if cstr(dts.variables("executionflag").value) = "1" dts.variables("feed").value = "select [symbolname] ,[bid],[ask],[ticktime],[server],[serverid],[lastupdate] feed cast( " & columndatefilter & " date) between '" & fromdate & "' , '" & todate & "'" msgbox(dts.variables("executionflag").value.tostring) elseif cstr(dts.variables("executionflag").value) = "0" dts.variables("feed").value = " select [symbolname] ,[bid],[ask],[ticktime],[server],[serverid],[lastupdate] feed" end if


Comments

Popular posts from this blog

tcpdump - How to check if server received packet (acknowledged) -