Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
webtechie
Starting Member
1 Post |
 Posted - 2009-04-15 : 09:29:41
|
| 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\SettingsI 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.TonyIf you want the same results, keeping doing the same thing. If you want different results, pray harder! |
|
|
|
|
|
I don't see the multiphase data pump in 2005?