DSXchange

OK so I can stop pulling out my hair, "Thanks Bill Gates and MicroSoft". I talked to my DBA and they sent me the following. It is not about the time the row was created or updated. Instead, it is a sequence number. Here is some more information: timestamp The SQL Server timestamp data type...

I'm trying to select a timestamp from SQL Server using ODBC connection, the Table Def has the field as Binary and so it returns the value 30303030303030303031463635444644, if I put it through OCONV I get 7481BC-08-12 -03:00:44. But if I change the SQL Type to integer, the Length to 10 and the Data E...

Has nothing to do with that, in the Oracle stage the field is defined as Timestamp, when doing a view data of the Oracle stage I get *'s for only the 01-01-4712 00:00:00 data. It happens in the Oracle stage before it gets to the transformation stage. waht is ur data type in target dataset? if its ch...

I have a condition that has a date in Oracle of Jan 1 4712, I've been told this actually is a negative number in oracle, when I use a Server Job it will pull the date out as 4712-01-01 00:00:00 but when I use a Parallel Job I get *'s returned. I want to use a Parallel Job but also need to have the d...