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.

Steve, you make no mention of the BlackBerry in your article. While it may not be quite as much fun to use as Android, iPhone, WP7, it's a pretty efficient...

That won't make your problem go away.

This sounds like a job for backup/restore to me 🙂

The rest of this thread is about transferring objects between a 2005 database and a 2008 database - that makes two databases. So I mean the other one, presumably on...

Assuming you're using a dataflow to get data from A to B, you can use a Conditional Split to redirect your '0' data out to a CSV file while your...