Koen Verbeeck (6/24/2011)

---

Both formats will work.

1. Text with spaces: the space is not listed in the dropdown box as a delimiter, but you can type in that dropdown. Just type...

Lowell (6/23/2011)

---

can you get the data with a delimiter that is not used in the data, like a tab delimited or pipe [|] or tilde [~] or something? for get...

Ms.SSIS (6/23/2011)

---

Like you said, there is no "space" option for text qualifier. One option you can try is, read the data of all the columns in one column. For that...

rgtft (6/22/2011)

---

The bad syntax in your expression looks to be a misplaced :

In an SSIS expression If/Then Else statement, the Then clause follows the ? and the Else clause follows...

Thanks Mark that worked. I am an SSIS newbie so I have do not understand this logic (I dont understand why it doesnt use VB expressions or SQL functions)....

Ninja's_RGR'us (3/16/2011)

---

What I mean is find a row that is not correctly filtered. Get the input param from that row and run the function manually. That will show...

Here is a sample output of the results. Like i said earlier I use this same script for other fields for a long time and haven't had any complaints...

I just want to add that if i write it to a temp table and requery WHERE CI is NULL then it works, however, in this instance I do not...

Ninja's_RGR'us (3/16/2011)

---

is250sp (3/16/2011)

---

CREATE FUNCTION dbo.CI(@chg_ref_num varchar(10))

RETURNS VARCHAR(1000)

AS

BEGIN

declare @ci varchar(1000)

select @ci = coalesce(@ci + ', ', ' ') + cast(cor.resource_name as varchar(50))

from ca_owned_resource cor

inner join lrel l on substring(l.r_persid, 4,...

Function works properly as far as I know. I use this same function whenever i need to concatenate...

CREATE FUNCTION dbo.CI(@chg_ref_num varchar(10))

RETURNS VARCHAR(1000)

AS

BEGIN

declare @ci varchar(1000)

select @ci = coalesce(@ci + ', ', ' ') + cast(cor.resource_name as varchar(50))

from ca_owned_resource cor

inner join lrel l on substring(l.r_persid, 4, 60) =...

anyone?????

nm figured it out

I already have that in my WHERE...

Please explain how I...