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

And the problem you have is just with the 2005 database, or with both? Are your db's both set at 90?

Where is the SSIS package running? On 2008 or 2005? I would expect it to work if using a 2008 package (though haven't tried it).

SSIS does not natively handle dynamic column mapping in dataflows, if that is what you are referring to?