Right - I've never done that.

It might be worth creating another thread & posting your C# snippet, if it's not too complex.

rs80 (4/3/2013)

---

I'm using the DtsRunTime.package to call the package and package.Execute to run the package. In the same library, I'm using DtsRunTime.Variable to pass the variables to the package....

rs80 (4/3/2013)

---

I spoke too soon 🙂

Phil's approach is working. But when I try to run the package thru a batch job passing variables for the template path (source) and report...

Oops! Glad to hear it. Time I visited the coffee machine for some additional humour-spotting beverage :hehe:

shalinder.verma (4/3/2013)

---

I agree with David. The title was misleading and I got upset before reading the article and got angry after reading the article, save 'holy moly guacamole'. 😛 ...

DavidBridgeTechnology.com (4/3/2013)

---

I think the title is misleading and a little unfair to the wonderful work Microsoft did with Merge (Despite its being 6 years after Oracle - poor show MS).

This...

That's a nice technique Dwain, thanks for sharing.

arjundhilod (4/2/2013)

---

hello to all

this is my 1st time i want to create SSIS package.Step is as below But i am using visual studio 2008 or sql server 2008 r2...

Confirmed - that should do it. Good luck.

rs80 (4/2/2013)

---

Phil:

Just to make sure I've understood your approach:

1) In the data flow, I would load the data from the oledb source to the template.

2) Then I...

nk1526 (4/2/2013)

---

Sorry Sir

I am trying to split sentence into words and insert into table as each word as a separate row

This is just practicing test

for some reason I am not...

Why not archive the file (or the very old data in the file) rather than letting it grow?

Surely the ideal thing here would be to fix the CSV file so that positions are shown correctly? But I presume that change is not possible, for some reason?

What is an "assing point"?

Edit - ah, 'assign'!

If this is just a training exercise, fair enough. But this is not the best way to solve such a problem - in SQL Server, loops are used infrequently as...