Answer 1

Answer 2

I am agree with Nitesh,

you can use variables but not as expression.

this post from Jamie talks clearly about when you can save more than 4000 characters in ssis  variables and when you can not:

http://consultingblogs.emc.com/jamiethomson/archive/2009/05/27/4000-character-limit-in-ssis.aspx

Answer 3

Thanks Nitesh and Reza, but the main problem is not the 4000 caharacteres, The problem is how can I do the following code in SSIS 2008???

Regards

               VBScript Task

………………..

……

                Set pkg = DTSGlobalVariables.Parent"

                ' MODIFICACIÓN DATOS TRANSFORMACIÓN: CARGA FLUJO CAJA"

                Set tsk = pkg.Tasks( ""DTSTask_DTSDataPumpTask_9"" )"

                Set cus = tsk.CustomTask"

                sqlOriginal = cus.SourceSQLStatement"

                sqlNueva = sqlOriginal"

                sqlNueva = Replace ( sqlNueva , ""GBLFECHAINICIO"",GblMesAnt )"

                sqlNueva = Replace ( sqlNueva , ""GBLFECHAFIN"", FechaFin )"

                cus.SourceSQLStatement = sqlNueva   ' Para modificar querys cuando están en una transformación."

……..

……….

Data PumP Task (Source Ole DB Oracle)

                SELECT *, ...............................

                'GBLFECHAINICIO' Fec1, "

                'GBLFECHAFIN' Fec2,"......................................where

                ....AND   A<= TO_DATE('GBLFECHAFIN','YYYYMMDD')"

                .......

Answer 4

Answer 5

I think you'd want to use an OLEDB Source and select SQL Command from the drop down and place question marks where you want to modify  the criteria from a variable.  Then set up parameters to populate the question marks with the required values from a variable at run time. You'll also need to set up the variables and use an Execute SQL Task on the Control Pane to populate them with the needed data.

I hope I've understood, what you're trying to do correctly.

SELECT *, ...............................

                ? Fec1, "

                ? Fec2,"......................................where

                ....AND   A<= TO_DATE(? ,'YYYYMMDD')"