Running Package Examples
To execute an SSIS package saved to SQL Server using Windows authentication, you use the following code:
dtexec /SQL UnleashedPackage1SQL /SER DXD001\SQL2014DXD01
To execute an SSIS package saved to the package store (on the filesystem), you use the following code:
dtexec /DTS "\File System\UnleashedPackage99PS"
To execute an SSIS package saved in the filesystem, you use the following code:
C:> dtexec /FILE "C:\HotCustomerPlus.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI
Figure 47.43 shows the command prompt and subsequent execution of the HotCustomersPlus.dtsx SSIS package. Now, the package can be set up for ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
