SET CONCAT_NULL_YIELDS_NULL OFF in 2005 SSIS Execute SQL Task

#1

need to SET CONCAT_NULL_YIELDS_NULL OFF, but while my query works fine in
SQL Server 2005 Management Stuido, it does not work in Integrtattion
Services. Any ideas?

#2

I solved it. I think it has to do with the size of the concatendated result
and the size od the target column, which I may have made too large.

"Greg" wrote:

Quote:

need to SET CONCAT_NULL_YIELDS_NULL OFF, but while my query works fine in
SQL Server 2005 Management Stuido, it does not work in Integrtattion
Services. Any ideas?

#3

Actually, it works in an Execute DTS 2000 Package Task, but not an Execute
SQL Task.

"Greg" wrote:

Quote:

I solved it. I think it has to do with the size of the concatendated result
and the size od the target column, which I may have made too large.

"Greg" wrote:

need to SET CONCAT_NULL_YIELDS_NULL OFF, but while my query works fine in
SQL Server 2005 Management Stuido, it does not work in Integrtattion
Services. Any ideas?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SET CONCAT_NULL_YIELDS_NULL OFF in 2005 SSIS Execute SQL Task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SET CONCAT_NULL_YIELDS_NULL OFF in 2005 SSIS Execute SQL Task - 07-14-2005 , 02:17 PM

RE: SET CONCAT_NULL_YIELDS_NULL OFF in 2005 SSIS Execute SQL Task - 07-14-2005 , 04:01 PM

RE: SET CONCAT_NULL_YIELDS_NULL OFF in 2005 SSIS Execute SQL Task - 07-14-2005 , 04:15 PM