• wiam.elab (10/14/2016)


    Hello everybody,

    I have a little story to tell about SSIS,

    As I have to retrieve a parameter from the result of a Tsql Stored Procedure,

    It'll be passed to a variable into my SSIS package,

    then this variable will be called in a SQL query as a column value,

    and this dynamic SQL query will be called through another variable,

    that will form a query extraction for my OLE DB Source component :hehe:

    and finally the size of each column of the OLE DB Source will be set automatically,

    the problem that I'm having is : when the value has only 3 caracters, the size is set to 3, when the second value is 10 caracters,

    this current value is truncated to 3 caracters, I tried several work around to avoid this, but still not resolved !

    I have little idea how you have put this all together and exactly what is going on, but if your source query is SQL, why not force the data type length using CAST()?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.