In ssis package variable i would like to pass following expression. Please advise. Eomonth(dateadd(month,-6,het date()))
Are you sure that your expression would return a value in SSIS? And as far as using it with a stored procedure, are you seeking to pass the value of that expression, or the expression itself? If the latter, I'd question your judgement, so my guess is it's the value you want to pass. You would need a string expression for your query for a given source component that converts the value of that expression to DT_WSTR and appends it into the correct location in the EXEC statement for your stored procedure.