sqlbaby2 (10/12/2015)

---

I want to join 2 tables, table a and table b where b is a lookup table by left outer join. my question is how can i generate a...

dudekula.kareemulla (10/12/2015)

---

I have a package with 3 parallel data flow tasks added in a sequence container. I need to implement transaction such that, the transaction completes if all the 3...

I have an idea.

If the subject of a post contains either "http://" or "https://", mark it as spam.

Felix Pamittan (10/12/2015)

---

Yeah! I've been lurking this forum for quite some time now...

Nice code, Felix.

Not sure how quick it was though; have you been listening to Eirikur?

kdefilip (10/11/2015)

---

Hi

I have two tables, INCIDENT and PEOPLE

INCIDENT has two fields, ID and Date

PEOPLE has three fields, INC_ID [foreign key to INCIDENT.ID], PersonIteration, Complaint

There is always only one incident, but...

Jason A. Long (10/9/2015)

---

Correct me if I'm wrong (a strong possibility), but I don't think we're able to reference...

Jason A. Long (10/9/2015)

---

Phil Parkin (10/9/2015)

---

I found a 'GetNumbers' function here [/url] and that, when combined with Jeff's function, allows you to take the CLR out of the equation ......

Here's an iTVF version of the query I posted earlier.

create function dbo.GetNumbers ( @data varchar(8000) )

returns table

return

select nums = left(substring(@Data, patindex('%[0-9.-]%', @data), 8000),

...

I found a 'GetNumbers' function here [/url] and that, when combined with Jeff's function, allows you to take the CLR out of the equation ... at least for the data...

anthony.green (10/9/2015)

---

7 packages, a bit overkill.

Why not 1 package...

+1

garfieldlandry (10/8/2015)

---

If you change the target to a SQL Server table, does it work OK?

Do the columns which fail to be populated have anything in common? Same datatype, space in...

garfieldlandry (10/8/2015)

---

I am using a config file. The same config file manually as I use when running as SQL Job. The SSIS package moves data to an Informix table. It...

garfieldlandry (10/8/2015)

---

I have an SSIS package that extracts from Excel and loads to Informix db. The package uses a config file. If I run the package manually (package utility) it...