Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL 2000 DTS Multiphase Data Pump question re insertion fa..

 
   Database Help (Home) -> DTS RSS
Next:  accessing the behaviors and attributes of a sibli..  
Author Message
Zoe Hart

External


Since: Jan 10, 2008
Posts: 3



(Msg. 1) Posted: Thu Dec 11, 2008 2:52 pm
Post subject: SQL 2000 DTS Multiphase Data Pump question re insertion failure details
Archived from groups: microsoft>public>sqlserver>dts (more info?)

I am working with SQL 2000 and have enabled the Multiphase Data Pump. I've
got a function handling the insertion failure phase because I want to ignore
primary key violations. I'm doing all of this in an ActiveX Script
transformaion. My problem is that I'd like to ignore primary key violations,
but log all other violations (null fields etc.) before going on to the next
row. I haven't been able to find any way to get error details within the
insertion failure phase so that I can distinguish one type of failure from
another.

Thanks for any help.

Zoe

 >> Stay informed about: SQL 2000 DTS Multiphase Data Pump question re insertion fa.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
DTS data pump field count "error" - I've just noticed a problem with a DTS package I've designed, and was wondering if anyone else had had a similar problem. Basically, I have a data pump task which takes an Excel .csv file and transfers the data into a SQL table. Each .csv column is..

pump task to flat file --- High CPU - I have a DB connection and a output destination defined in my SSIS package. What creates the output file is driven from a query that uses a view to extarct the records to the Flat file. If I run this query it returns the records with 20 seconds. When I...

Newbie alert: SQL Server 2000: How do I UPDATE data alread.. - Hi everyone, I am working to learn DTS as a method to pull data from legacy Access database(s) into a new SQL Server 2000 data structure, rather than using Access to push the data there. I have a table of lookup values (used in combo box [cbo]..

Importing data from MySQL to SQL Server 2000: Problem with.. - I am using MS SQL Server 2000 together with the DTS Import/Export Wizard and MySQL Connector/ODBC 3.51 to import data from MySQL to SQL Server. Everything works fine except with a MySQL table that include text columns (called 'descCredits',..

Issue with data migration from Sql 6.5 to Sql 2000 using bcp - Hi, My apologies if this question is not suitable to be posted here.. We are facing an issue while moving a Sql 6.5 database to a Sql 2000 server using bcp out/bcp in. We have moved several databases from Sql 6.5 to Sql 2000 earlier by scripting out an...
   Database Help (Home) -> DTS All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]