SSIS is the one of many possible ways. I do this task in few minutes.

Do you want some support to do this task?

MP

Microsoft SQL Server 2005 Integration Services Step by Step.

MP

If you use data source with unknown structure then this effect may occur. ITO avoid this use derived column component and explicitly give it size and type.

MP

Condition for output name type_00 should be:

RecType == '00'

and for output name type_01 should be:

RecType == '01'

Nothing more.

MP

Please give me the view of mappings in ole db source and view of output definition for conditional split and overall view of this package diagram.

MP

How many rows are displayed near each path outgoing from conditional split component? How many rows are input to this component?

Please post screen capture of execution task.

MP

1. Use Flat File Source, name all column to human readable form (for example name this column to Type)

2. Add path from the source to Conditional Split component

3. add two...

Thanks,

David

MP

No, "with recovery".

So I must restore full backup with "no recovery" and next diff with "with norecovery" too...

Make backup database with truncation log option.

MP

Show more info about those packages (Contacts and GLAccouns).

MP