Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transform Data Task - Error Handling Question?

Status
Not open for further replies.
pkav

pkav

Programmer
Nov 26, 2002
4
GB
Hi,

Is there way to configure a transform data task to populate an error table instead of the destination table if a transform fails?

Or is this something I'll need to do using some form of ActiveX scripting?


Any help would be great, thanks.

Paul.

 
Status
Not open for further replies.

Similar threads

botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
155
botatun
botatun
gquint
  • Locked
  • Question
DTS Error Handling with Muliphase Data Pump
Replies
0
Views
55
gquint
gquint
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
302
markjoseph1232
markjoseph1232
Webkins
  • Locked
  • Question
SQL Server 2000 data redundancy question
Replies
1
Views
61
mrdenny
mrdenny
eao
  • Locked
  • Question
DTS Transform Data Task - Lookup Help
Replies
2
Views
74
eao
eao

Part and Inventory Search

Sponsor

Back
Top