Is there a restartability and ability to skip x number of rows (Restart Logic) in SSIS
can ssis allow rollback for unsuccessful completion of load process by record
Pls give me example
SSIS capability?
Hot Topic
- noobie question on CSV Flat Files
- Prevent writing to the Transaction Log?
- Display SQL 2005 KPI status graphic using visual studio 2005
- HTML String Rendering in a Report
- Problem attaching a database
- Merge replication broke after SQL 2005 Evaluation upgrade to Enterprise
- define Value Labels in a Result Set?
- MergeSynchronizationAgent Status event
- If-structure
- AquireConnection error message
SQL Server
- SQL 2000 Best Practices Analyzer report clarification needed.
- SetDefaultInitFields "TextBody" for Stored Procedure
- Intermittent Failure of Interdatabase Service with SP-1 CTP
- Upper Limit for a SQLProvider query in ADF?
- Attribute Relationships
- Adding vertical space between rows
- SSIS package execution question in SQL agent
- How to UNZIP files?
- Manipulating SQL server databases dynamically
- Sharing datasources
SSIS capability?
Barry Neilsen
SSIS supports reusability by use of checkpointing. There's stuff about this in BOL and plenty of other pockets of information aroudn teh community.
There is no ability to automaticallly skip X number of rows in the pipeline using restart logic.
SSIS does not support rollback by record.
-Jamie