Change the type of an expression container

Hot Topic

AdventureWorks database not seen by Management Studio Express CTP
SSIS Dataflow vs SQL2K DDQ
Establish connection to the server
SQLNCLI.DLL can't find MSVCR80.dll at runtime
Doesn't like a particular namespace
remove specific string from text field
top n rows
Simulate ROW_NUMBER () in SQL 2000
System.Data.Sql
How to create a DUMP table in MSSQL

SQL Server

Where's the bell?
problem installing sql server express
Migration Wizard Error
SQL SERVER 2005 DATABASE MIRRORING for large number of databases
current users
Failed to generate user instance and Cached Domain Login....
Stupid Replication Q
INCORRECT DATE WHEN USING MOLAP AND HOLAP STORAGE.
variables in sql command
Could not establish trust relationship for the SSL/TLS secure channel

Change the type of an expression container

Hi,

I use expressions to build the SQL query that is executed by the data flow.

Today, I ran into an issue. For the first time the SQL query has exceeded 4000 char so the expression cannot be validated and it is not possible to use it.

Is there a way to change the expression datatype to nvarchar(max) instead of the default nvarchar(4000)

Thanks,

Philippe

Answer this question

Change the type of an expression container

  • Jayender sivaraman

    So i am back in the business of using multiple variables.

    Too bad

  • Syed Hasnain Ali

    Philippe,

    Unfortunately 4000 is the limit on the result of an expression.

    -Jamie



  • Bobby Zwanenburg

    Is there any way around the 4000 literal string masx issues. Its sad that the case because a table could contain many fields and that might cause the literal string to be more than 4000.


  • Change the type of an expression container
Answer this question