DSXchange

Is anyone else here using the Japanese or Korean rulesets? We just upgraded to 8.1 (on Windows), which did fix one issue, but led us to another. Apparently, it is expected that the Japanese data will be in Japanese, so the Classification table still lists the Japanese characters. Unfortunately, Data...

Got it. As usual is was something small that caused it.

One of the fields in DS was an unsigned bigint. In SQL Server, they don't let you choose signed or unsigned. By changing it to Varchar, it worked. Stupid problem, simple resolution.

Thanks for your time.

Sorry about that. I had disabled it on the big job, but not here. Here are the updated error messages. ODBC_Enterprise_0,1: Failure during execution of operator logic. ODBC_Enterprise_0,1: Internal Error: (0): odbcwrite.C: 746 Copy_5,1: Internal Error: (shbuf): iomgr\iomgr.C: 1880 node_node2: Player...

I'm trying to write data to a SQL Server 2005 table. I tested my connection with a test job (to a test table) successfully. When using the actual data (both in the test job and the real job), I get the following: APT_CombinedOperatorController,0: Failure during execution of operator logic. APT_Combi...

When trying to write to a dataset, I'm getting the following errors: APT_CombinedOperatorController(2),0: Write to dataset on [fd 17] failed (Error 0) on node node1, hostname <ServerName> APT_CombinedOperatorController(2),0: Orchestrate was unable to write to any of the following files: APT_Combined...

I am using a lookup to join two datasets. When using the lookup, I get an incorrect record count along the reference link. I should be seeing 448, the actual number of records. Instead I get 2838, which is the number of records from the main link (which displays the correct value). Is this a known i...

So you're saying that it will only change the type if it finds it in the table... Sorry, I must have missed that. Thanks for the help. I'll try it out and then mark this as resolved.

Thanks for bringing that up, Stuart, but the patterns < or > do not always match up to measurement. It can be another value as well. I need to be able to check and see if it is a unit before committing to it. The same for other types of < and >.

That would work, except I also need to use the abbreviated form of the word. Saying that, and thinking about your solution, a messy fix would be to have two tables, one to see if the value of the characters is a unit of measure, and a second one to actually change the value to the abbreviated versio...

I'm taking mixed data, such as 3KG, and breaking them up. It's easy as long as I know for certain that the trailing characters will always be the measurement unit. However, I also get other data in the same format. This is giving me bad data in my output. I need to take a pattern like this: * > and ...

[quote="stuartjvnorton"]You have used COPY to get the first and last parts. So you'd now have something like X99X (variable length number in the middle obviously), right?[/quote] That [i]would [/i]work, except that COPY doesn't get rid of what it copies; MOVE does that. Unfortunately, MOVE...

Unfortunately, it's part of a completely freeform text field. Not all records have it, and some have a measurement type (KG, MM, etc) attached to the end as well. Since it's picking it up as a @, I don't think ^ | I = "X" | ^ | I = "X" | ^ will work either. I do like the transfor...

Another thing to think about is IsNull(...). We use this a lot on my project. If it is NULL, then change it to an empty string('') or whatever you want it to be.

I just want to add in my own opinion, as I had to learn (quickly) from the various guides. Then I was thrown in to making my own custom ruleset. It was very difficult, and the user guides were the resources I had. I came here for help on occasion, but stuck to trial and error (mostly error). I didn'...

I'm working with data with this structure: 14X15X3. I need to pull each dimension from the overall measurement and place them into variables. I tried using 'MOVE [1](n) temp', but MOVE does not work well with operands. I also tried copying the data to a user variable first, but that didn't help. I k...