Calling DB2 command line from SSIS

• jithu.balan

  SSC Rookie

  Points: 49

  More actions

  October 8, 2010 at 2:21 am

  #241390

  Hi SSIS Masters,

  I have one issue in using load utility of db2 in SSIS. I have successfully run the below sql statement in db2 command editor but need to know how can I execute the same using SSIS task.

  my primary objective is to load the db2 table from the file.

  db2 LOAD CLIENT

  FROM 'C:\test\Sample.txt'

  OF DEL

  MODIFIED BY DUMPFILE='C:\test\reject.txt'

  COLDEL|

  METHOD P (1,2,3,4)

  Insert INTO DB2INST1.testTable

  (col1,

  col2,

  col3,

  col4 )

  Thanks in advance.

  JKB