Handling constraints in DTS packages

#1

DOH!! Figured it out. Hmmm... how about Save As...

There are somethings that really leave one feeling stupid.

-Joseph

#2

Let me see if I understand you.
You suggest using DTS to move the data to a temp table.
Then I could call a stored procedure from the DTS to do validation and
to populate the 'real table'.
I suppose it would not make any difference if the source were an excel
file, would it?
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

I would not be doing this manipulation against the text file. I often, if
not always, find it easier/better to import into a working table and use
TSQL to determine the good records.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Rathtap" <amcniw (AT) yahoo (DOT) com> wrote in message
news:b21a5958.0307011015.480b4629 (AT) posting (DOT) google.com...
I am importing data from a text file into a table. How can I prevent
unique and foreign key constraints on the table from preventing the
import? I do not want to uncheck the CheckConstraints checkBox in the
TransformdataTaskproperties.

I would ideally like the records that are causing errors to be skipped
and logged or inserted into another table but the execution should go
on.

#3

Not really for the MPDP.

With a text file you are limited to manipulation using an Active X transform
which operates row by row.

A BULK INSERT into a table and then use TSQL would be fastrer especially if
the recordset was large.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Rathtap" <amcniw (AT) yahoo (DOT) com> wrote

Quote:

I have also been reading about Multiphase Data Pump Functionality --
is this something that I could possibly use here? Any samples?
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

I would not be doing this manipulation against the text file. I often,
if
not always, find it easier/better to import into a working table and use
TSQL to determine the good records.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Rathtap" <amcniw (AT) yahoo (DOT) com> wrote in message
news:b21a5958.0307011015.480b4629 (AT) posting (DOT) google.com...
I am importing data from a text file into a table. How can I prevent
unique and foreign key constraints on the table from preventing the
import? I do not want to uncheck the CheckConstraints checkBox in the
TransformdataTaskproperties.

I would ideally like the records that are causing errors to be skipped
and logged or inserted into another table but the execution should go
on.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Handling constraints in DTS packages

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Handling constraints in DTS packages - 07-01-2003 , 02:56 PM

Re: Handling constraints in DTS packages - 07-02-2003 , 07:26 AM

Re: Handling constraints in DTS packages - 07-02-2003 , 01:35 PM