Post reply

SQL command from Variable - 4000 Chars limit?

  • April 11, 2008 at 8:42 am

    #184362

    I have a lengthy query that I'm trying to assign it to a variable. String variable is not taking more than 4000 chars. Is there any to overcome this?.

  • April 11, 2008 at 9:14 am

    #801570

    Nope.

    Well...it depends on what you are doing.

    A SQL Command can use a file as a source for it's command and the file can be larger than 4000 characters.

    If you are trying to use it for query inside a data flow (like an OLEDB source) you need to reduce the complexity of your statement by creating a view or stored procedure at the source or a dsv in your package.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply