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...

I'm not sure about best practice, but as SSIS is so heavily dependent on design-time meta data, I try to avoid run-time meta-data tweaks where I can. I don't know...

Try adding a data viewer to ensure that the data values are exactly as you mentioned. Remember that you need to be case specific (I think). Leading or trailing spaces...

An alternative way of achieving is to leave the name of the Excel destination static, and to use the File System task immediately after the data flow to copy the...

Without actually setting this up for myself, I am not sure how much more help I can offer.

Do all of the spreadshhet files already exist?

Have you tried using breakpoints to...

I'm using 2012 - maybe it's different if you are on an earlier version - hopefully it should be obvious, if you already have a connection configured.