DSXchange

Asked and answered several times here already as an exact search for "version control" will turn up. A recent example is here, there are a number of others.

midmaxds wrote:Is there is way I can pass this as a parameter, just as in a normal job?

I don't know why not... have you tried it yet?

Built in, 'out of the box' functionality? No.

I've never found any links or seen any details other than "it rebuilds the indexes in the project". That was enough detail for me.

Hmmm... usually by now if someone had something to add they would have posted it. Have you involved your official support provider yet?

I didn't think so... but standing by to be educated.

Very interesting. Thanks for posting your resolution.

Perhaps...

http://www-01.ibm.com/support/docview.w ... wg21611365

You'd need to enlighten us what "not getting compiled" means... what are the specific errors you get?

Use the proper NLS characterset in the job... assuming your installation was "NLS enabled", that is. You should also verify that your target, the SQL Server database, is configured to handle them as well.

Me saying "in your shoes I'd ping support" was a suggestion for you to contact them.

I'm not aware of any settings to help though others might. You could always check with your official support provider. Never was a big fan of using spreadsheets as a data source, they are always a PITA to validate no matter what tool you are using it would seem. Had to do something like this in Info...

abyss wrote:you can create project package

Not really all that helpful of an answer unless you also explain what that means and how to actually do it.

All setting "first line is column headings" does is cause the first record in a file to be skipped when read, that or added when written, there's no validation built into it. If you want to validate you have all of your columns, perhaps you could turn that option off and then check to make...