Running Package Examples
To execute an SSIS package saved to SQL Server using Windows authentication, you use the following code:
dtexec /SQL UnleashedPackage1SQL /SER DATAXDESIGN-PC\SQL2012DXD01
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 54.43 shows the command prompt and subsequent execution of the HotCustomersPlus.dtsx
SSIS package. Now, the package can be ...
Get Microsoft® SQL Server 2012 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.