DSXchange

Hi all. We have a web service application with 30+ jobs in it. When it is deployed the server slowly starts to crawl to the point of being unusable. There are a bunch of memory segments taken by dsadm that do not get released. The only way to clean them up is to reboot. Has anyone seen this issue be...

Date length 4. Thanks.

data example: |xxx|xxx|2009-12-15|xxx|xxx| target data type: Date length 10 append a zero time to cause an error as well. to validate the date I removed the ODBC stage add a Seq Stage and wrote all records to a file that passed the test below. All records passed. IsValid('Date', lk_SourceFile.DateFl...

Thanks for replying craig. I had the same concerns you mentioned in your reply so I delete all but one record from the file and have confirmed the data. Still receiving the message.

Any suggestions from anyone would be greatly appreciated.

Hi all. I am loading a DB2 table via the ODBC stage The source file is ascii text and the source field is varchar 255 The dates in the field are in yyyy-mm-dd format In the transformer stage I am using the following code: StringToDate(Trim(lk_SourceFile.DateFld),'%yyyy-%mm-%dd') The job fails with t...

Thank you ray. Since the Seq Stage can handle files patterns I thought there could be a solution.

Hello all. I need to concatenate/append a single string that resides in one file to every record in three separate text files. These three file have very similar names. I need to be sure that all records remain in their respective files. Is it possible to have one job handle all three files without ...

I reread the original post and thought it was not clear. I want to created a host computer named TEST. When I navigate to do so, i.e., Home--> Configuration--> Sources--> Click On Host Computer Name I only see Home -->Configuration. The "Sources" selection is missing. This is a new install...

Thank you. ray and chulett. That worked.

I'm sorry chulett. There is a key part I forgot to add to the original post. I am not signed on to IIS server when the job is started. It runs at 3 AM.

Any additional comments would be appreciated. Thanks.

Absolutely works for the whole project. I have been doing it at the command line for awhile now and just need to automate and schedule

I tried dscmdexport and it works at the command line but in a scheduled Sequence job I received a "failed to attach to project" message

Apologies. I omitted the fully qualified path for dsexport.exe and forgot the DataStage server name. For clarity I changed ProjectName.dsx to DSexportOuptputFileName.dsx D:\IBM\InformationServer\Clients\Classic\dsexport.exe /H=999.99.99.9:9080 /U=DsAdmin /P=pwrd DataStageServerName/ProjectName C:\My...

Thanks chulett. I'm trying to schedule this to run off hours when no one is using DataStage. Do you think this is possible?

I have scheduled a Sequence job that has an Execute Command Stage that runs the following command dsexport.exe /H=999.99.99.9:9080 /U=DsAdmin /P=pwrd ProjectName C:\MyFolder\ProjectName.dsx This job starts but never ends. The dsx file is created but no DataStage objects are sent to the output. DsAdm...

Thanks chulett. This is very helpful