corey lawson (10/25/2013)

---

It is the dynamic remapping of input & output fields in data flow tasks that bites...

Look at BIFuture.blogspot.com for C# code to add a derived column to ssis...

corey lawson (10/25/2013)

---

Effecting dynamic stuff like that in SSIS can be painful.

You somehow have to make the changes to the package at "design" time. Which can mean programatically creating a...

Koen Verbeeck (10/24/2013)

---

Script task or script component? Last one is in the data...

Koen Verbeeck (10/24/2013)

---

Just curious: why do you use a script task as a destination? What is your destination?

Maybe there are easier alternatives.

As long as you don't use any blocking transformations...

But how do i see the exact line of my script task which caused an exception ?

Koen Verbeeck (10/24/2013)

---

Can you be a bit more specific?

Is the job scheduled with SQL Server Agent, or with another scheduler?

With which tool did you make the ETL job? If SSIS,...

Sorry, I'll clarify. Pull, each record, do some concatenation of...

SQLBill (10/17/2013)

---

My wife doesn't want to hear about it. But interestly enough, she goes on and on about her work and expects me to be interested. She really...

Phil Parkin (10/20/2013)

---

blasto_max (10/20/2013)

---

I want to get all the rows in one column of a record set and concatenate them into a string. I want to do it using C#....

Koen Verbeeck (10/20/2013)

---

In contrast with Jeff, I know (quite) a lot about SSIS.

DO NOT USE SSIS FOR THIS.

Use dynamic SQL for this (as Jeff mentioned).

If I would need to do...

Won't work in my case. Its a pretty complicated situation. The derived column itself would have to be generated...

Okay. So, it there a set of scripts that can convert data...