DSXchange

Hi ArndW, Thanks a lot for the reply and the insight. I did try this and you were right, the bottleneck of DB write is not something I could resolve. But, I would still consider your input highly helpful as I can use this in other jobs where I might need the "Multi-reader" approach. Thanks...

Hi Group, From the Server Dev Guide and various postings, I learned that IPC stage can be used to introduce paralellism in server jobs -- provided, the underlying infrastructure supports this design. I have a server job that has a source sequential file stage and a target SQL Server 2005 DB stage. S...

Hi Duke,
Thanks for your insights and sharing the code snippets. Appreciate it much. I will try them out today/tomorrow.

Ray,
That was an interestingly scary link. One of my colleagues pointed me to this link on the Excel bug.
http://www.joelonsoftware.com/items/2007/09/26b.html

Thanks again,

Hi Ray, I presume you wanted to review the INSERT from my Server Job as that is the working version in this discussion, so far. INSERT INTO #RawLoaderJobParams.DB_TABLE_NAME#("EmpId", "EmpName", "Address1") VALUES (?,?,?); If this is not what you wanted, I apologize for...

Ray, Thanks for the followup and your time. The back-end database (SQL Server 2005) assigns a default value to this 4th column The following is the excerpt from the DDL that creates this column. RawRecCreatedDate [datetime] NULL CONSTRAINT [Dft_Employee_RawRecCreatedDate] DEFAULT (getdate()) Thanks ...

In the server job, i don't have the 4th column in my transformer. Just mapped the 3 input columns to the output columns. The 4th column is not used in the table definition for the target stage also. The Server version works without any glitches. The back-end database populates the 4th column using t...

Hi, Just to make sure my earlier post was not confusing, I would like to summarize it as follows. I have a database table with 4 columns and the input feed has only 3 columns. A job should read the input file with 3 columns and load data into the 3 columns and not worry about the 4th column. 1. I am...

...It happens when the job crosses midnight. Right on Spot Duke. I started this job at 10:22 PM EDT and it completed at 1:00 AM the next day (after 2:30 hours). So if I understand this correctly, from your experience, the product support team has never fixed this, right? Thanks again for your time ...

Thanks Craig. Submitted this to the IBM Support Group.
Will keep the group posted on any progress.

Thanks,

Hi, I ran a server job that reads from a sequential file and loads into a target ODBC stage (SQL Server 2005 DB). It tooks about 2:30 hours to complete the job. When i looked at the job log, i found the following entries. 2848374 rows read from Input_SF_To_XFM_Lnk 2848374 rows written to XFM_To_DB_L...

Hi, I am having some trouble getting this job to work.... Would appreciate your help and input. Here is my job design. SequentialFile ==> Transformer ==> SQLServerEnterprise The job reads an input text file with 3 columns and loads them into a target database (SQL Server 2005). Input file has 3 colu...

I agree with Craig and just to add ... If you have an associated XSD for your XML, you can have the XML stage validate the XML against the XSD file. The syntax to follow is, again as craig mentioned, available via help. Also refer to this wonderful guide available at Duke's site http://www.duke-cons...

Thanks a lot for your time him121 and Ray. Appreciate it much. Setting the transformer to Sequential Mode did not work him121. I selected "Sequential" for the "Execution Mode" in the Advanced page of the Transformer stage properties. It has the same error. If this is not what you...

Hi, I have a simple RCP test job to learn RCP and then put it into practice in a real job. I am a novice and would appreciate your help. Sequential File ==> Transformer ==> SQL Server Enterprise The input file has 3 fields EmpId nvarchar(50) EmpName nvarchar(255) Address1 nvarchar(255) The Destinati...

I compared the new metadata with an old xml one and found out that the old one did not have any '/defns' in description. So i manually removed the 'defns:' to make it as eg. "/BACSDocument/Data/ISCDDocument/Version/text()" To get rid of the "defns" prefix, do the following. 1. L...