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

I disagree. It seems relatively straightforward to me.

You need two derived columns - Add1 and Add2 say.

Add1 will be Left(Address, 30)

and Add2 will be characters 31-60 (use a substring function...

GN-340682 (11/26/2010)

---

Hi John,

Thanks for the reply.

I've tried that. It just pushes the problem on. It seems that if I do that when it gets to the next numeric field it's...