oh yeah Matthew...i...

Lowell (5/7/2012)

---

well, it depends on the results you want, right?

you had said at first you just wanted check how many rows are existed as like as above scenario...

so displaying the...

Thank you Sturner...as you told, it takes some time to get...

sturner (5/9/2012)

---

How big is the database? It could take a while to push the snapshot over there if its big, in which case you might want to just backup and...

Brief the error...i mean post the exact error as like as it looks...

where do you get the...

If you would like to pass connection strings through configuration files, you could see like below in the file...here you can edit passwords

<Configuration ConfiguredType="Property" Path="\Package.Connections[Target].Properties[ConnectionString]" ValueType="String"><ConfiguredValue>Data Source=.;User ID=sa;Pwd=*****;Initial Catalog=DataBaseName;Provider=SQLNCLI10.1;Auto Translate=False;Application...

you can use Conditional split transformation...

Lowell (5/7/2012)

---

well, it depends on the results you want, right?

you had said at first you just wanted check how many rows are existed as like as above scenario...

so displaying the...

Lowell (5/7/2012)

---

Great job posting the DDL, that makes it SO easy to help!

by using the INTERSEC operator, i seem to get the results you might be looking for;

you could do...

robert.gerald.taylor (5/7/2012)

---

In a Derived column transform, you can do something like:

[font="Courier New"]RIGHT(Field1,1) == "," ? SUBSTRING(Field1,1,LEN(Field1) - 1) : Field1[/font]

I didn't check for an empty string or other possible problems,...

GSquared (4/25/2012)

---

The problem rows have DIDOC# values. Your subquery (the Cross Apply query) requires that they be the same as per the first item in the Where clause. ...

dwain.c (4/24/2012)

---

I think you've gotten the idea.

Don't wait for us to desk check it. Run the SELECT (maybe with a TOP 100 or something) and look at the output...

GSquared,

i have attached sample output of the script...and i high lightened the rows where i have problem...

if ModIDRef has duplicates, again comment column has to be concatenated...and seqno = 1...

GSquared (4/24/2012)

---

Okay, for clarification, is all this is doing is concatenating text together into a single text string, and then putting that in another table?

If so, you definitely don't need...

If you guys are still not understanding about my requirements, please let me know so that i'll give you better explanation of my requirement...

the two tables are like one to...