Pulivarthi Sasidhar (9/16/2015)

---

Hello All,

I have an SSIS package, which loading 5 data files of same format into Single Destination Table by taking 3-4 Hours...

Now my Manager asked me to change...

And the ordering of the data is purely by date/time?

toni 667 (9/16/2015)

---

Hello,

I have following problem and I hope someone could help:

I have a table with a datetime and an Item column.

I want to retrieve only the rows where...

I can't see how. Gives this

Here's one way:

with rows

as ( select * ,

...

Try this.

select column1 ,

stuff(column1, charindex('@param1', column1),

charindex('@param2', column1)...

I use stored procs with parameters all the time, but not with DB2. Is...

Have you considered implementing this as a standard data flow, with your DB2 query as source and the CSV file as destination? It would seem much easier, though maybe I...

How is D:\jj\JJ_Data_Extract_20150914103322732.csv related to what you are doing?

Can you please explain what you mean by this?

mar.ko (9/14/2015)

---

Fair enough Sean, thanks for that idea.

However, I don't agree that using comma-delimited lists violates any rules of relation theory.

A list is a list....whether it's in table form...

Kristen-173977 (9/14/2015)

---

Sorry, I mistook @RETABLE as a parameter to the...

Kristen-173977 (9/14/2015)

---

A function can't insert into a table. I presume that is the error that you are encountering.

A Stored Procedure could do.

The Function could return the SQL, for the code...

This seems somewhat long-winded and will not scale well (because it's not an iTVF).

Can you give a bit of background about what you are trying to achieve & what the...

Kristen-173977 (9/14/2015)

---

Any mileage in looking...