Geek Answers Handbook

SSIS, dtsx and deployment packages

I'm just trying to understand SSIS packages a little better and how they are deployed. Correct me, I'm wrong, but for any deployment, I believe that there should be at least two files: .SSISDeploymentManifest and .dtsx..SSISDeploymentManifest acts as an equivalent Windows Installer package that points to .dtsx. Dtsx is the actual “material” package that is referenced as an external file, as when the installer starts. When you install it, the package is added to the ssis package list for this instance.

My further questions:

  • If I wanted to keep the previous version of the same package, can I just copy the bin directories with the two above files and save separately, do I need to go back to the previous package?
  • Where are these packages installed? How does SSIS know where the packaging machines are?
+5
source share
3 answers

Correct me, I’m wrong, but for any deployment, I believe that there must be at least two files: .SSISDeploymentManifest and .dtsx..SSISDeploymentManifest acts as an equivalent Windows installer package that points to .dtsx. Dtsx is the actual material package, which is referenced as an external file, as when you run the installer. When you install it, the package is added to the ssis package list for this instance.

. , . , SQL Server. . .

:

:

, dtsx . sourcesafe , . , . , bin, , , - . .

:

:

, :

a) b) MSDB

, . , , , .

. : http://blogs.conchango.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Common-folder-structure.aspx

dtsx. , , (.dtsconfig) ( ). . BOL, .

, dtsx config . , XML .

DBA ( , .

SQL Server, . , , , dtsx config , . DBA dtsx .

, SQL Agent, , SSIS, , , . , , , .

// SSIS. , , .

+16

DTS / SQL Server SQL Server .

0

SSIS, SSISDB . ​​, Studio Management, , , - :

SELECT prj.[name] as Project
      ,pkg.[name] as Package
      ,pkg.[version_major]
      ,pkg.[version_minor]
      ,pkg.[version_build]
FROM [SSISDB].[internal].[packages] as pkg
JOIN [SSISDB].[internal].[projects] as prj
ON pkg.[project_id] = prj.[project_id]
ORDER BY prj.[name]
0

More articles:


All Articles