DTS Transfer between Firebird and SQL Server

• amasood

  SSC Rookie

  Points: 39

  More actions

  April 8, 2008 at 12:01 pm

  #71542

  Hi,

  I'm using the IBProvider OLEDB Provider in the SQL Server DTS Wizard to import data into a SQL Server database. The DTS execution hangs at the execution phase without giving any errors. Is there a way I can track what is going on while DTS is sitting at execute?

  Anyone have any idea what the problem might be?

• Norman Kelm

  SSCommitted

  Points: 1922

  More actions

  April 24, 2008 at 7:23 am

  #806565

  On the SQL Server side, use the profiler to watch what is happening.

  Does the IBP OLEDB provider have a trace function?

  Set up a log file on the dts package.

  Norman Kelm

  DTS Package Search

  http://www.dtspackagesearch.com/