Thanks GSquared......I'll add logging and trace the package. I'll get back to you on this one after I'm done with it.

I really don't know a lot about CLR. And I think if I start now then it would be really time consuming. So, I'd rather stick to solving this problem...

Eugene Elutin (10/18/2012)

---

Did your "above you" insisted that you should use trigger to execute XP_CMDSHELL? Or they just told you that SSIS should start as soon as records inserted?

I...

GSquared (10/18/2012)

---

What is the SSIS package accessing the same table for? To read values out of the inserted row?

If it's to read values out of the row, then what...

Hi Sam,

I changed the properties of my package as you suggested. But, it didn't improve anything. I am adding an image which shows the various current sessions on the...

This is another way of doing it...and I guess the simplest way....:-)

With YOURTABLE (TICKET,STATUS)

AS

(

SELECT 9543,1 UNION ALL

SELECT 9543,5 UNION ALL

SELECT 9543,5 UNION ALL

SELECT 9544,1 UNION ALL

...

Thanks a lot for the replies.

I know that this is a bad idea, but some people above me disagree.....anyways if this doesn't work then they'll learn I guess.

I am pretty...

Laurie is right. Please post DDL, Sample Data and the Expected Result and we will give you a sample solution using a Recursive CTE.

Where in the Sample Data does it show that the city is mapped to address 3??...What is the logic behind the city being mapped to Address 3 and not 1...

The following query should do it for you:

Select a.IssID, a.subject, a.dessc,

MAX(Case When c.new_value = 'Accept' Then b.created_on Else NULL End) As Accepted_Date,

MAX(Case When c.new_value = 'Assign' Then b.created_on...

woody_rd (9/5/2012)

---

Sorry for the confusion, guys. Let's see if this explains it better. I have come across an issue where a table logs conditions with

a timestamp, eventid...

May be the OP means that when he applied your query...

ohhh!!!! yes!!....i didn't look at the logic that way...that completely missed my eye. Sorry, My Bad. I was in a hurry, I just saw the OP's post and replied without...

I really didn't understand the requirement. Would be better if you could come up with a better example. Please have a look at the link in my signature to get...

You can use a lot of methods to do this. It all depends on what part of the String you want to remove, the type of requirement(one time or a...