Yes exactly. Once you have that, you're in business.

Even if you just use Row_Number() to generate one on the fly ... (if you're not too fussy about which rows end...

If you have two data sets

Set 1

1, 2

3, 4

Set 2

a, b

c, d

and you want to combine them to give something like

1, 2, a, b

3, 4, c, d

you need to...

Or ...

Instead of using the tables as your sources, use a query which includes the join. Then your data source is ready to go - this will be faster than...

Feed the two sources into a Merge Join transformation and from there map to your destination table (I'm assuming that the two source tables can be joined, of course).

Hi Steve

It's easy - take a look here.

I am happy to have been of help - although, with hindsight, I feel that we should have got to this sooner 🙂

Phil

Sounds like you're well on the way to creating a script component to do the job.

I will write down my thoughts, just in case they include anything you haven't considered.

The...

Craig Farrell (12/2/2010)

---

LutzM (12/2/2010)

---

In that case, either an IIF statement or REGEX should help. (Google regex or IIF in ssis for details.)

You'd basically use a script component after your data...

Finally we are getting somewhere, I think.

For this task, forget the FST. You can delete the entire dataflow actually.

Just configure an Execute Process task on the Control Flow pane to...

I am afraid that you have not answered my question. Until you can tell me why you cannot use

move *.*

I am not going to post further.

Steve Hindle-535638 (12/2/2010)

---

Yes - maybe I'm over complicating things. If I use the wildcard method for the Source folder, how do I loop through to different destinations. Do I still...

I must be missing something. Why not use the wildcard option? Then you don't need to know the file names.

Steve Hindle-535638 (12/2/2010)

---

the SourceFolder variable will be the same, but there may be more than one text file in there - so I need to iterate over these files (one...

So do these variables merely contain folder paths and you want your task to loop round all files in <source_folder> and move them to <destination_folder>?

Or do the values of the...

This can definitely be done. What problem are you having?

I am also interested to know what will happen to this table in future. Will it be maintained incrementally (via appropriate UPDATEs and INSERTs) - in which case is this...