How do I turn on multi phase data pump in DTS in SQL Srvr 2005?

• WebTechie

  SSChampion

  Points: 11405

  More actions

  March 26, 2009 at 8:26 pm

  #129437

  Hello,

  I am processing a lot of row in my DTS package. Sometimes, because of the import flat file, the task fails.

  I was told about the multiphase data pump that I can code to send error rows to another table.

  Sounds great.

  I've done some research and found that you can just right click on properties in SQL Server 2005. You have to go into the registry and enable the settings key for designsettings.

  However, I don't even see it in the registry. It is supposed to be here:

  HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\DTS\Settings

  I see the all the way down to the dts folder, but I don't see a settings folder under DTS in the registry.

  Anyone have an idea how I can get the multiphase data pump?

  My boss wants to us to use DTS now and get through our projects. Later on, we will create a project plan to migrate to SSIS.

  Also are there any good books that deal with using DTS in SQL Server 2005?

  Thanks.

  Tony

  Things will work out.  Get back up, change some parameters and recode.

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  April 21, 2009 at 1:47 am

  #981235

  You're using DTS on SQL 2005? Any special reason?

  With SSIS you can redirect error rows in the Data Flow Source.

  IMHO, if "getting through the project" is the goal then why not take advantage of SQL 2005?

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com