DSXchange

Make use of Folder stage as the target stage instead of the sequential file stage and your requirement will be achieved easily. we have done the same things successfully.

I am getting following error when I am connecting to a Microsoft SQL server database through ODBC Connector Stage. ODBC_Connector_0: [IIS-CONN-DAAPI-000296] SAX parser exception thrown: Invalid character (Unicode: 0x1) (CC_PropertySet::fatalError, file CC_PropertySet.cpp, line 2,005) Now I searched ...

ArndW wrote:I really should have been paying attention - this is a Version 8 question and I think it likely that you are going to have to get IBM support involved as it does look more like a bug than a design issue.

Thanx Arndw,

Will send the job export to the IBM team and try and resolve.

After this post I tried almost 15 different job designs. And a particular pattern came up. I don't know whether its correct or not... What I am doing is: - lookup_stage---------------->Funnel-------->Dataset \ /|\ \ | \ | Surrogate key generator------>Copy----->Transform----->Oracle So it always giv...

I'm sorry if my question was misleading. What are you doing in the ODBC connector stage (which database, which options, etc.) ... Hi, sorry for misunderstanding. I am connecting to Microsoft SQL server and I am doing a select * on the table named as EventLog. Apart from it all the options are defau...

I'm sorry if my question was misleading. What are you doing in the ODBC connector stage (which database, which options, etc.) ... Hi, sorry for misunderstanding. I am connecting to Microsoft SQL server and I am doing a select * on the table named as EventLog. Apart from it all the options are defau...

I'm sorry if my question was misleading. What are you doing in the ODBC connector stage (which database, which options, etc.) ... Hi, sorry for misunderstanding. I am connecting to Microsoft SQL server and I am doing a select * on the table named as EventLog. Apart from it all the options are defau...

Can I use any active stage after a surrogate key generator. I am using a surrogate key generator in a reject link of lookup stage. and from this surrogate key generator I am feeding the values to a copy stage which populates 2 copies of this data in 2 different tables. but I am getting an error of S...

ArndW wrote:What kind of a stage is this ODBC_Connector_108? ...

Its a ODBC connector stage which is now a days available with ODBC enterprise database stage. This ODBC connector is setting up a connection with Sequel server and fetches data.

The ODBC_Connector_108 stage has the string " -XMLProperties '<?xml" which seems to trigger the error message at compilation. Is the "<" properly quoted so that it isn't interpreted as a redir ... But I can not see any "<" coming in my data. Also at the stage level I h...

I am getting an error while running a job it says main_program: Syntax error: Error in "transform" operator: Error in input redirection: Expected input name, got: "?", line 291; text: <? First of all if its a syntax error then why was this not caught during compilation. Also I ch...

Can some one tell me why is this warning comming in the lookup stage.
I tried searching in the forum, but could,nt get any link

We are using an execute command stage for taking the output of Cat command which is reading a file. Next to this stage we are using a routine activity to take a specific value from the output of the Cat command. Finally I am passing this specific value to a parameter which will be used in a differen...

So tell me what you finaly want as result and I tell you the best way to achiev it. Dear WoMaWil,what i want is output to Excel file on Multiple sheets.i.e i have source extract containing data about multiple instances of data and what i want is that after transformation the the output should be in...

I'm not suggest you have to do it. 'Get' as in 'make arrangements with whomever manages the server' to have the DSN created. Craig the information regarding server management is not available from Client even on special request.Besides even if we manage to get one off approvals it will only help in...