DSXchange

I have a Job.source and target both sql server source--->transformer--->target when i run the job it gets aborted with the error message : Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. sometimes it...

I have a job simple source to target dump source--->transformer--->target both source and target are sql server. one of the columns for the table say COLUMN_A is defined as ntext in the sql server and on importing it into DS it is read as LongVarChar with length 2147483647. similar structure at the ...

Thanks you Eric, that was great help...I was able to resolve the issue with what you told me..Thank You SIR!!!! :D

chulett wrote:An empty string "" is not the same as null. Sounds like you need to explicitly check for that. ...

so what exactly do I need to do..

I have an issue need some insight.. i have a job with one of the source column as NOT NULL and its been targeted to a column that is also NOT NULL..the data coming in on that column shows blank, null spaces, I want to default those blank spaces to UNKNOWN. but when I use the NullToValue function, I ...

Thanks Guys...I found out the mistake I was doing...apparently the derivation was a faulty one that i was doing.

but so far in the design through out the flow there has been no error or warning...its only at this last step that the warning is coming up..i have also broken down the design in small steps to check for the warning but none..

what do you suggest me to do..

Thanks

I have a job and I need some help in recognizing the warning message that am getting...the job runs and completes but at the last step after all the trasformation and joins when the data passes through the last transformer before it goes into the table a lot of rows are getting dropped. the log show...

Put a reject link onto the Sequential File stage that is writing the file. Capture that in a Peek stage. It may be useful in a diagnostic sense. ... when i do the view data in sequestial file it gives me the following error.. ##E IIS-DSEE-TFOR-00089 15:13:03(000) <_ABORT_IDENT_,0> The runLocally() ...

ray.wurlod wrote:Put a reject link onto the Sequential File stage that is writing the file. Capture that in a Peek stage. It may be useful in a diagnostic sense. ...

i just did that and all the data routed out of the sequential file and got rejected. i dont understand what could be wrong over here...

am trying to write data in a sequential file in .csv format to read the full data in an excell file...when i run the job, it completes successfully but when i open up the excel file, all i see is the columns and no data. can anyone please tell me where am going wrong.

thanks

i have the source column with date in the format of 2007-07-08 00:00:00.000 how can i get just the date from it and leave out the time part at the target column...
thanks

Hi, I need to create a timestamp column in my target table (sql server), which will read data from source table (sql server) and datastage when run will create the timestamp on the target table. my question is while creating the column what has to be set as the attribute, datatype for the column. mi...

chulett wrote:Link.TimestampField[6,2] ...

thanks Craig..issue resolved...

how do I get just the month in output column from a date in the format yyyy-mm-dd

the source column in isn TIMESTAMP and the target is in INTEGER

thanks