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 derfloh 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
Joined
Nov 26, 2002
Messages
4
Location
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 Question
the linked server insert data to csv in wrong order
Replies
0
Views
623
botatun
botatun
gquint
  • Locked
  • Question Question
DTS Error Handling with Muliphase Data Pump
Replies
0
Views
208
gquint
gquint
smsmail
  • Locked
  • Question Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
1K
markjoseph1232
markjoseph1232
Webkins
  • Locked
  • Question Question
SQL Server 2000 data redundancy question
Replies
1
Views
278
mrdenny
mrdenny
eao
  • Locked
  • Question Question
DTS Transform Data Task - Lookup Help
Replies
2
Views
265
eao
eao

Part and Inventory Search

Sponsor

Back
Top