Try
            Package.Connection.Open()

            Using transaction As SqlTransaction = Package.Connection.BeginTransaction()
                Try
                    DeleteCommand.Transaction = transaction
                    DeleteCommand.Connection = Package.Connection
                    DeleteCommand.ExecuteNonQuery()

                    Using bcp As New SqlBulkCopy(Package.Connection, SqlBulkCopyOptions.KeepIdentity, transaction)
                        bcp.DestinationTableName = TableName
                        bcp.WriteToServer(Table)
                    End Using

                    transaction.Commit()
                Catch ex As Exception
                    transaction.Rollback()
                    Throw New Exception("Ошибка загрузки таблицы """ & TableName & """", ex)
                End Try
            End Using
        Finally
            Package.Connection.Close()
        End Try