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.)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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