Viewing 9 posts - 106 through 114 (of 114 total)
I've discovered the effects of having validateExternalMetadata set to false in the event of an error.
In this case trimming some char values, for insertion into varchars at the destination, caused...
March 1, 2011 at 11:23 pm
I'm setting ValidateExternalMetadata to false based on advice from relevant articles. I can't for the life of me find the ones I was looking at 4 weeks ago, but I...
March 1, 2011 at 3:58 pm
After the data has been output to the database?
I wouldn't recommend trying to do it that way (though maybe someone with stronger SQL could divine a simple way).
I'd be doing...
January 13, 2011 at 3:00 pm
I expect that you have quotation marks in the source and your viewer just isn't showing them.
In the Flat File connecton under generl put quotations in as the text qualifier.
January 12, 2011 at 11:05 pm
"AB"
"GH"
"AD"
What is wrong with that?
Can you provide a sample of what your CSV data is like and what form it should be in after?
Are there no quotations in your source...
January 12, 2011 at 10:46 pm
It's not exactly clear what you are trying to do.
Are you trying to update your 2000 SQL Server records based on values from the oracle table?
Or are you trying to...
January 12, 2011 at 10:32 pm
Right click your Source or Data Conversion (whichever is generating the error) -> Hit Configure Error Output -> Change the setting from Fail Component to Redirect or Ignore Failure depending...
January 12, 2011 at 10:13 pm
Craig Farrell (12/1/2010)
The other option would be that you simply use that report as an indicator to a live body to go and adjust the time records.
At present we have...
December 1, 2010 at 4:10 pm
Yes, it's safe to assume Leave is static (one of 3 values) and also that activity is potentially anything.
If I take the suggestion of adding another column to group on,...
December 1, 2010 at 3:36 pm
Viewing 9 posts - 106 through 114 (of 114 total)