DSXchange

This is how i went about fixing it. I hope this helps people facing similar problems and saves some time and effort. so , here it goes : I installed Visual Studio C++ 2008 Express Edition. I then worked around vcvarsall.bat :idea: file .if you are wondering why , please check ( http://msdn.microsoft...

Hi stuart, Thanks for responding. I have installed the following SDK, which I assume is the problem. :( Microsoft Windows SDK for Windows 7 and .NET Framework 3.5 SP1 I did check the Planning and Installation Guide but I am a bit confused about the SDK to use for Windows Server 2008 R2(SP1) 64 bit, ...

Hi All, I would appreciate if i can get some help in solving this issue for which i have been looking for information for over 2 days through various forums. :cry: :cry: I have installed Infosphere Datastage v8.5 on windows environment for testing and have run a couple of jobs, but when i run a job ...

Hi chulett , I tried your suggestion .I removed modify stage and used FILE_REFERENCE[1,50] in tranformer and that solved the problem

Hi All, I am trying to do a string to string type conversion, but i still get a warning, as explained below, what am i doing worng ? Incoming column: FILE_REFERENCE varchar(255) -Nullable Outgoing column: FILE_REFERENCE_ID varchar(50) -Nullable Specification: FILE_REFERENCE_ID:string[max=50]=substri...

Ray, Thanks for the reply..

I did come up with a similar solution after some trial and error.

Hi All, In a sequence i am trying to calculate datetime in the format YYYYMMDD_HHMM and assign this to a variable and pass the variable to a job activity stage as a parameter. The calculated value "YYYYMMDD_HHMM" will be appended as a suffix to an error file. So the error will have a name ...

Thanks Craig, that information was handy. Also, To read two columns from a files (just 1 record in it) into UVA stage variables, currently i am using Command Activity stage twice on the same file . Once i extracting columns 1 into one of the UVA variables and then extract columns 2 into another UVA ...

I am writing 2 values into a sequential file and want to read these two values into 2 variable in UVA stage and then pass these variable down stream. This file has only 1 line with two columns containing values. From other threads i have seen that Execute Command Activity stage is generally used to ...

Hi i have a similar requirement as noted here to add/subtract months from a given date. I did use Ray's Addmonth , when i Test the routine independently it works fine but when i include it in a sequence the routine fails with return code = '10893', Am i doing something wrong here :( (i have 3 month ...