DSXchange

Hello all, I'm very new to the DS family of products, working primarily with DataStage right now. One thing to note up front is that I connect to our DataStage server through Remote Desktop - just in case that has any bearing. I created a series of jobs to do bulk loads from a SQL Server 2000 db on ...

I have this same issue, but have also noticed that it never actually inserts any data into the target table. It shows it processed X number of rows, but no rows exist in the table upon completion of the job. My basic setup is DS Server 7.5.1, SQL Server 2000 to SQL Server 2000, RDBMS stage at both e...

Hi Arif, Everything I have seen and read on this site so far leads me to believe that binary is not generally supported. In some ways this makes sense as you can't perform any Transform functions on this type of data. On the other hand, if a database table happens to have a datatype of Text for one ...

Define "binary". Are you talking about an EBCDIC file? See the CFF stage. Remember, a Server Sequential stage expects to either read a delimited row ending with a line terminator (CR/LF, LF, user-defined) or a fixed width row with optional line terminator (read to line terminator or via s...

I am having exactly the same problem with this datatype. I have also gone so far as to try different database connectors. I figured the MSOLEDB would at least be able to handle it's own datatypes :oops: Guess I assumed too much. Is there anyway around this other than truncating data by using the pre...

I also have this problem. I created a single job with a single source connection and a single target connection (MS Bulk Load), but with transforms for about 60 tables to do some load testing. I moved the labels to perfect spots -- it looked so nice. Saved, closed and went home for the day. Next day...

A completely other scenario: If the number of inserts/updates is large and it's difficult to find the changed records: Just truncate and reload. I'm not used to sql server but on an oracle this is the fastest solution once you reach about 10% inserts/updates. Hi all! My first response on this site....