DSXchange

Consolidate the xsd files into a zip file and import the zip file as a "schema bundle". This should fix the issue assuming your xsd files have correct syntax.

Just use the string $PROJDEF in your parameter set for the password value. It will automatically resolve changes from the administrator client. Job recompiles are not necessary. It was also discussed here

When you add your user defined environment variables to your parameter set double click in the default value column for the password that you selected from the "Add environment variables" picker. Replace the values (Encrypted String & Confirm Encrypted String) with the string "$PR...

This is a known issue

My client version is 8.5.0.1 and when I go to Import -> Table definitions -> Web services WSDL definitions and provide http://wsf.cdyne.com/WeatherWS/Weather.asmx?wsdl in the address bar I see two ports (WeatherSoap & WeatherSoap12) with three operations each in the Web Service Explorer. If you'...

Follow the steps in this turorial. Quick and easy.

Use the @DAY System Variable in a job sequence which gives you the current day. You can set up a nested condition check to see if the day is equal to 1 and if so then call your job as necessary.

Hi Everyone, I am not trying to ask a loaded question here, but when we have a lot of large jobs running I almost always see some sort of NuTCRACKER related errors in the event viewer on the server. Level Date and Time Source Event ID Task Category Error 10/16/2012 10:08:19 AM NuTCRACKER 4 16005 NuT...

About once every couple of hours, one of our servers logs these messages in the event viewer. I do not notice any drop off in job performance with the DS jobs that are on this server, but I was wondering if anyone else on a Windows OS had experienced similar issues. Is this something that could poss...

DSFreddie here is an example of server routine that will take a variable for the body: $INCLUDE DSINCLUDE JOBCONTROL.H FullArg = "" If ToAddress <> "" Then FullArg<-1> = "To:":ToAddress End If FromAddress <> "" Then FullArg<-1> = "From:":FromAddress ...

Karthik.M you can start here

Take a look at this article. We just had the same issue using Oracle and used this information to solve the problem.

Thanks Ray -- I appreciate the feedback.

Josh

I modified the job and changed the sequential file stage to Char(21) as suggested. This works great and rejects the record perfectly. Is it a best practice to use Char instead of Varchar in these scenarios? I also incorporated the Column Import stage off of the sequential file reject link and I am a...

I must be overlooking something really obvious, but I ran into an issue with a flat file load job and wanted to see if my understanding of the sequential file stage is skewed. One of the systems that we receive data from sends us files that are fixed width. This particular fix width file is defined ...