October 25, 2016 at 10:42 am
I am new to SSIS .I want to learn the difference between .DTSX and .ISPAC.I tried to google it but it some what hard to learn,Can anyone please let me know the differences.Thanks in advance!!!
October 25, 2016 at 10:55 am
@Patrick123 (10/25/2016)
I am new to SSIS .I want to learn the difference between .DTSX and .ISPAC.I tried to google it but it some what hard to learn,Can anyone please let me know the differences.Thanks in advance!!!
A DTSX file corresponds with a single SSIS package.
An ispac is created by building an SSIS project containing one or more packages. The ispac contains all of the packages, plus some other project-level information, zipped up into an archive. See for yourself by renaming an ispac to .zip and unzipping it.
The ispac can be deployed to a SQL instance in one operation (so all of the package and parameter information is transferred in one hit.)
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 25, 2016 at 10:59 am
A .dtsx file contains the source code for the SSIS package (in XML format), while .ispac is a ZIP formatted file containing .dtsx files, .params file, .manifest file, and other project files required for a deployment. You can actually open up a .ispac file using a tool like 7Zip and examine or extract what's inside.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply