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

Adiga (11/25/2010)

---

However it looks like the SQL Server Agent startup account does not have access to the path specified. Can you double check if the SQL Server Agent is starting...

Well done. I have no idea either 🙂

Does the path include drive letters? If so, can you use a UNC path instead?

Do you mean that the SQL Server Agent service is using your own personal credentials to run?

No problem, thanks for posting back.

Delete that green arrow.

Then connect source to derived column and derived column to destination (use green connectors).

Then amend your mappings. The new derived column should be available as an extra...

Add a derived column transformation into your data flow - set its value as required and then map it to the desired destination column, same as all your other columns....

I'm sorry, I don't know what else to suggest.

This link suggests that what you are trying to do should work just fine.

Maybe it's worth trying this with an Expression instead and seeing what happens.