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
Post a Comment