DSXchange

Well... blue-ish words are URL links, in this case a link to another post I found by searching for your error number. If for some reason you can't see that in your browser, hover over the word 'this' in my post and the rest should be obvious.

Any chance it's this problem?

You might want to expand a little on what you are trying to do. Any of the database stages can be configured to do inserts, updates, etc - all 'automatically' without resorting to User Defined SQL. That's the whole point behind the 'Update action' choice in the stages when used to write to a databas...

So, go ahead and pass it. Nothing about what Ray posted makes that "not suitable" for you.

More information, please. What exactly are you exporting and with what options? Is this import project another project on the same server as the export project or is it on another server? If so, anything different about that other server? It would also help to post the specific error messages you ar...

Is there some way to parametrise my template or to make something similar to wizard to populate new jobs faster and easier No, not really. Ascential documented something along those 'Wizard' lines in the product which confuses things when people stumble across it, but it never really materialzed. Y...

You are better off repeating the Server installation. It will run in Maintenance Mode and allow you to - amongst other things - install optional plug-ins you didn't during the original installation. This is the preferred methodology and will get the plug-in into all current projects plus the project...

How did you install it?

Actually, you can - it just doesn't return any rows. Move into a project directory and it will actually produce output: /ds/Ascential/DataStage/DSEngine > . ./dsenv /ds/Ascential/DataStage/DSEngine > cd ../Projects/YourProject /ds/Ascential/DataStage/Projects/YourProject > $DSHOME/bin/uv "selec...

Yah, good luck with that - I don't envy the position you're in. I thought - how about creating a rich text format format file? So I created one using Word 2003 with two lines: This is not bold This is bold I ended up with a Word document 19,968 bytes in size that converted into a 3,313 byte rtf file...

I'm not sure what you are expecting... someone to come along and tell you everything you'd need to know in one post? There's alot of information buried in the forum, you just have to get creative sometimes in what you use for search keys. Here's one example that I found in a couple of seconds, I'm s...

If by 'in parallel' you mean 'at the same time' the answer is mostly a no. This has been discussed here before, so a search should turn up what you need to know. It is simple to install two versions of the Client on one machine, I've got that going on with mine right now. You just need to install th...

Kumar - did you source 'dsenv' first? /ds/Ascential/DataStage/DSEngine > . ./dsenv /ds/Ascential/DataStage/DSEngine > cd bin /ds/Ascential/DataStage/DSEngine/bin > uv "select * from DS_JOBS;" This is what Saravanan meant by 'executing' it to make sure all your environment variables and pat...

First off, why in the world would you use an ETL tool to do a job that BI tools are specifically built to do? Secondly, define what 'bold' means. That depends on what will be used to read / display your output and what it expects. What are you building - HTML, RTF for Word, what? Once you know that ...

If you are trying to compare source fields that are transformed before going into your target, to make an apples-to-apples comparison you'll need to do your initial transforms and then do the CRC check.

Otherwise they'll always be different.