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

Nice solution - I'm sure others will use it.

Phil

The title of this thread refers to columns, yet your posts refer to rows. That's an important difference - which do you mean?

For future reference, when you get an error...

Your text states...

Part 2 is the tricky bit though. If you've done this before, I think it would be useful if you could provide a code snippet.

Tricky because

"1,400.00",17.50,300

needs to become

"1400.00",17.50,300...