0

I know I can test this out pretty easily but dont have access to SSIS right now does any one know if a ssis data flow commits the inserted records if it is stopped mid process.

Thanks

user2129585
  • 259
  • 1
  • 4
  • 14

1 Answers1

0

That would be dependent on the setting for TransactionOption. This can be set on the package, container or task level. It defaults to not supported, which would commit the records.

http://msdn.microsoft.com/en-us/library/ms137690(v=sql.105).aspx

W.W.
  • 36
  • 3