DSXchange

Hi all, I have a job that kept crashing and gave out the following messages: GIL_J_Dim_PS_D_SNO_WEEKS_WRK..Trans_Gen_Key: Metadata mismatch for column '2': Datastage column type and database column type differ. ... DataStage Job 2614 Phantom 3288 Job Aborted after 50 errors logged. Attempting to Cle...

>1) Is your D:\Lab\TestPsExec2.bat on the remote server? Yes > 2) Inside TestPsExec2.bat, it runs simply "echo 0". > Instead of doing an echo. Try to test it using a command which is non-> interactive (e.g. touch D:\Touched_by_psexec.txt). This will give you > something definite to go and ...

Minhajuddin, Thanks for the encouraging answer! I want to test how to use psexec to run a remote command in another machine. I created a Execute Command stage and the command is: 'D:\Lab\TestPsExec.bat' It runs a batch file that does the following: cd D:\Lab psexec.exe \\remotemachine -d "D:\La...

Is there an answer to this question? I have the same issue.

Thanks!

I defined this field to be CHAR(5) in all the job stages and when it worked in DRS stage, I defined the database type to be ODBC.

Thanks all for the help.

By the way, is the SQL Bulk Stage the same as SQL Server Load Stage?
I didn't find SQL Bulk Stage inside Designer.

Before that, I used Dynamic RDBMS stage, it worked fine. I wanted to see
if bulk loading can reduce ETL Time.

Thanks!

Hi all, I am trying to use MS SQL Server Load stage to bulk load data into a MS SQL Server target table but I get the following message: C_FIELD_J_Fact_PS_F_INV_TRANS_E1..MS_SQL_Server_Load_231.IDENT5: Failed to convert column SRC_SYS_ID value from DataStage type to OLE DB type. Both source table an...