DSXchange

Hello- Seems to be a few threads on here related to this topic tho I think my use-case is unique. I am loading data from SQL server DB (source) into a Netezza DB (target). Very little transformation (most of the time none) is being done. Our vendor has supplied us with an 'API' in the form of a Stor...

Thank you for responding. Unfortunately, and like many seem to have experienced, I am not able to affect change in terms of how the file is output and simply have to work with what I get. I ended up going down the path of using a sed command and was able to add it to the Filter property of the Seque...

I have a .csv file exported from our cisco phone system. It uses semicolon as a delimiter for the columns and appears to have a semicolon after the last column as well as a LF character. The file appears to have the following escaped (using a backslash): null/empty columns, semicolons & line-fee...