Re: flat file to SqlServer DB... all or nothing.

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi, I think the best option for this scenario is Sql Server Integration
Services.

cheers

--

Francisco A. Gonzalez
fgonzalez@xxxxxxxxxx



"Nalaka" <nalaka12@xxxxxxxxxxxxx> wrote in message
news:eLw07YqrHHA.192@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have to move data from a flat file to a sql-server table.

My requirement is... if one record insert fails, rollback all prior
inserted data... and send an email.

My questions is... what is a good pattern to use for this scenario?
(Things like... if to use biztalk sel-server adapter or other mechanism)

Thanks a bunch.
Nalaka



.

Relevant Pages

  • Mapper & files dimension
    ... This is my scenario: ... I 've a document specification for a FLAT file that can be great some MB ... I want to map and import it into DB. ...
    (microsoft.public.biztalk.general)
  • Mapping columns of Flat File to DB table columns.
    ... How can we use SSIS for transfering data between flat file source to ... SqlServer DB existing table. ... Consider a scenario of an flat file where there is one column "Company ...
    (microsoft.public.sqlserver.dts)
  • Should I use Custom Pipeline with Flat File Dissembler?
    ... I am implementing a Scenario in which the input file is a Flat File with ... positional records and output is also a flat file. ...
    (microsoft.public.biztalk.general)