DSXchange

Just guessing here but maybe it only needs to 'compile' it once? Meaning, unprotect the project or open up the permissions then run the query and finally set things back locked up tight. Then try it again as well.

Or just wait for someone like Ray to come along with the real answer.

kumar66 wrote:from DataSetDef provided by connector: In field "CC_13_____": Parsing parameters "0" for schema type "string": Length must be positive, got: "0".

Have you looked into this?

What about the IP address? I thought that if that changed it could be a problem as it is embedded in the product in several places... I think.

Yeah chulett.. I too thought so,, so i have created my own post. Can you point out as what wrong i have done. That's just it, you didn't create your own post but replied to the old one you found. Next time please use Post new topic to start a new discussion. Use Reply to topic to add to the current...

As noted, you have something to clear up. Your source, if it is truly US7ASCII, cannot contain Arabic characters. Double-check what it actually is.

That kind of scenario would require a named pipe rather than an intermediate dataset.

I'm also curious why you marked your version as 11 and then put 8.7 in the subject.

Let's get you into your own post rather than piling on the end of one from 2009... done.

theone - always best to explain your requirements in words, posting only input and output examples means we have to puzzle out what it is you need and leads to confusion and incorrect solutions. Or far too much back and forth. Start us off on the right foot. Oftentimes the simply act of spelling it...

It certainly could I would imagine... did you change it with your server migration?

1. You create a routine that returns a delimited list of the filenames to process and you call that routine in the User Variables stage. Then you use that variable in the Start Loop stage as the 'list of things to loop through'. 2. Server jobs support USERSTATUS which is a 'communication' area much ...

As Ray noted, not if you insist on using RCP throughout. That's the nature of the beast.

That's a good thing. In fact, all of this is a good thing... are you thinking there's a problem of some kind?

Sure, that would be one solution.

It comes with full documentation and is probably online as well. The bigger question is can you or someone at your site code up the Java needed to source from a URL? The 'pack' just allows you to integrate that into a job.

Ray had a nice set of "date math" routines he used to give away on his old site but I don't see them on his new one. Ray, do you still have a link to that dsx around? I'm assuming it would be helpful here.