Viewing 15 posts - 11,746 through 11,760 (of 13,876 total)
Does the path include drive letters? If so, can you use a UNC path instead?
November 25, 2010 at 1:11 am
Do you mean that the SQL Server Agent service is using your own personal credentials to run?
November 25, 2010 at 1:05 am
No problem, thanks for posting back.
November 24, 2010 at 8:48 am
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...
November 24, 2010 at 8:36 am
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....
November 24, 2010 at 8:07 am
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.
November 24, 2010 at 1:51 am
Maybe it's worth trying this with an Expression instead and seeing what happens.
November 24, 2010 at 12:42 am
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...
November 24, 2010 at 12:39 am
That won't make your problem go away.
This sounds like a job for backup/restore to me 🙂
November 23, 2010 at 10:00 am
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...
November 23, 2010 at 7:15 am
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...
November 23, 2010 at 6:04 am
And the problem you have is just with the 2005 database, or with both? Are your db's both set at 90?
November 23, 2010 at 5:58 am
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).
November 23, 2010 at 3:55 am
SSIS does not natively handle dynamic column mapping in dataflows, if that is what you are referring to?
November 23, 2010 at 3:16 am
Viewing 15 posts - 11,746 through 11,760 (of 13,876 total)