Ssis-668 | iPad |
Example:
dtexec /F "PackageName.dtsx" /CHECKPOINT FILE "C:\Temp\Checkpoint.xml"
Ensure that the .NET Framework version is compatible with the package. You can do this by: SSIS-668
CREATE TABLE dbo.SSIS_ExecutionLog (
ExecutionID BIGINT NOT NULL,
PackageName NVARCHAR(260),
StartTime DATETIME2,
EndTime DATETIME2,
RowsInserted BIGINT,
RowsUpdated BIGINT,
RowsDeleted BIGINT,
Status NVARCHAR(20),
ErrorMessage NVARCHAR(MAX) NULL
);