DSXchange

Thank you all for your replies. I know the size of most of these image files are over 1MB. In the meantime, I've gotten things to work using a MSSQL DTS job called from a command stage within DS 7.5.1. However, I'll look into adjusting the MAXBUFFSIZE to 2MB+ and try that. I'll also check for goofy ...

I'm trying to convert one table to another table, both containing a column of text data type, which Datastage interprets as longvarchar(2147483647) in the metadata. The data can be rather large, and could contain any variety of characters entered in the data. This should be a straight mapping. Datas...

In case anyone was interested, with IBM's help we were able to solve this problem. In addition to what was stated in the Datastage documentation on how we should handle GUID data types, we needed to add the following function in the transformer moving the binary data from source to target: OCONV(<bi...

I'm having trouble using binary MSSQL columns in my DS job. I have a lookup table with a binary(16) key. Key values are created as GUIDs. I search the lookup table (using another column) to get the key to populated in a column on a target table, also a binary(16). I'm using an ODBC stage for both th...