DSXchange

Hi, As a check-list for your migration, have a list of job types that you are migrating. - Jobs that have transformers - Jobs that don't have transformers - Jobs that read from Databases - Jobs that write to Databases - Sequences - .... anything else that you might have in your site... Try a sample ...

Hi Brad, Apologies for the delay as I was "away" for some time... Thanks for the followup. I think the best bet is to have a simple UNIX script to handle the header row before sending it to the seq file stage for further processing. We have some more time before we can make a decision on t...

Try the ODBC stage for data loading on the target side.

Thanks Craig.

Hi Please check the section "Command Line Interface" in the Server Job Developer's guide (Page number 397 and later) for a detailed review of Command Line Invocation. Section "Starting a Job" lists the syntax and options.. Try it out and post your respones here... At a high level...

An interesting blog on Parameter sets can be found in http://it.toolbox.com/blogs/infosphere/ ... sets-25604 (Thanks to Vincent for his wonderful work).

Are you looking for syntax to pass specific parameters or the parameter set as a whole from a file?

An interesting blog on Parameter sets can be found in http://it.toolbox.com/blogs/infosphere/ ... sets-25604 (Thanks to Vincent for his wonderful work).

Are you looking for syntax to pass specific parameters or the parameter set as a whole from a file?

Hi Josh,
Thanks for the followup. Appreciate it much.

Correct me if i am wrong, my understanding is that the "SQL Server Enterprise" is not available on Linux/Unix Server installations.
Or is there a way to "bring in" this stage on a Linux/Unix installation?

Thanks again

Hi, We have jobs that read from sequential files and load into target MS SQL Server 2005 tables using ODBC Enterprise as per the following design. SeqFile ==> Transformer ==> ODBC Enterprise Is there any Bulk Copy/Load stage for MS SQL Server 2005 that one could use for such operations? Thanks,

Hi All, I have been using ODBC Enterprise stage in my PX job that uses RCP to read from sequential files and load into target tables (MS SQL Server 2005) Seq File ==> Transformer ==> ODBC Enterprise I wanted to try the same design using ODBC Connector stage and the job design is Seq File ==> Transfo...

Hi Ray,
Thanks for the followup. I was off for a couple of days and could not review this. The account is active for premium content.

Thanks for your help in resolving this.

-V

Hi,
Thanks for the update.
Are you able to view premium content at all, then?

Thanks

Hi, I renewed my subscription 2 days ago and am not able to view any premium content links. I did receive a confirmation email for the payment but it has been 2 days since. I emailed this issue to webmaster@dsxchange.com and membership.director@dsxchange.com and haven't received any response yet. Is...

Apologies for the delay.. Thanks for taking the time to explain the details. Brad, At this time we are reading from text files and this happens to be an RCP job of the following design. Seq File ==> Transformer ==> ODBC || || \/ Rejects file The sequenctial file has a "Keep File Partitions"...

Thanks lstsaur. That was helpful. In our case the server is shared across several teams and if one of them happen to submit a job that takes 2 hours of processing time, the rest of the folks are left to use the remaining nodes or wait until this node becomes free. Looks like this needs careful plann...