How to access .dtsx file in SQL Agent job step in SQL Server 2016
up vote
0
down vote
favorite
In SQL Server Management Studio, under SQL Server Agent, Jobs folder, I double-click a job. This opens the Job Properties window. Then I go to Steps, and double-click the first step of the job. This opens the Job Step Properties window as below:
In the Package textbox is a path to a .dtsx file. The path is similar to SSISDB...Step1Package.dtsx
Where is this .dtsx file located on the SQL server? And how can I view the file? Can I use Visual Studio 2017 to view the .dtsx file?
ssis sql-server-2016 sql-agent-job
asked Nov 8 at 0:13
Mark Nugent
941111
add a comment |
up vote
0
down vote
favorite
In SQL Server Management Studio, under SQL Server Agent, Jobs folder, I double-click a job. This opens the Job Properties window. Then I go to Steps, and double-click the first step of the job. This opens the Job Step Properties window as below:
In the Package textbox is a path to a .dtsx file. The path is similar to SSISDB...Step1Package.dtsx
Where is this .dtsx file located on the SQL server? And how can I view the file? Can I use Visual Studio 2017 to view the .dtsx file?
ssis sql-server-2016 sql-agent-job
asked Nov 8 at 0:13
Mark Nugent
941111
It's in the SSIS catalog. Take a look at "exporting an SSIS package in managent studio" mssqltips.com/sqlservertip/1428/…
– Nick.McDermaid
Nov 8 at 10:58
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
In SQL Server Management Studio, under SQL Server Agent, Jobs folder, I double-click a job. This opens the Job Properties window. Then I go to Steps, and double-click the first step of the job. This opens the Job Step Properties window as below:
In the Package textbox is a path to a .dtsx file. The path is similar to SSISDB...Step1Package.dtsx
Where is this .dtsx file located on the SQL server? And how can I view the file? Can I use Visual Studio 2017 to view the .dtsx file?
ssis sql-server-2016 sql-agent-job
asked Nov 8 at 0:13
Mark Nugent
941111
In SQL Server Management Studio, under SQL Server Agent, Jobs folder, I double-click a job. This opens the Job Properties window. Then I go to Steps, and double-click the first step of the job. This opens the Job Step Properties window as below:
In the Package textbox is a path to a .dtsx file. The path is similar to SSISDB...Step1Package.dtsx
Where is this .dtsx file located on the SQL server? And how can I view the file? Can I use Visual Studio 2017 to view the .dtsx file?
ssis sql-server-2016 sql-agent-job
ssis sql-server-2016 sql-agent-job
asked Nov 8 at 0:13
Mark Nugent
941111
asked Nov 8 at 0:13
Mark Nugent
941111
asked Nov 8 at 0:13
Mark Nugent
941111
asked Nov 8 at 0:13
Mark Nugent
941111
asked Nov 8 at 0:13
Mark Nugent
941111
941111
It's in the SSIS catalog. Take a look at "exporting an SSIS package in managent studio" mssqltips.com/sqlservertip/1428/…
– Nick.McDermaid
Nov 8 at 10:58
add a comment |
It's in the SSIS catalog. Take a look at "exporting an SSIS package in managent studio" mssqltips.com/sqlservertip/1428/…
– Nick.McDermaid
Nov 8 at 10:58
It's in the SSIS catalog. Take a look at "exporting an SSIS package in managent studio" mssqltips.com/sqlservertip/1428/…
– Nick.McDermaid
Nov 8 at 10:58
It's in the SSIS catalog. Take a look at "exporting an SSIS package in managent studio" mssqltips.com/sqlservertip/1428/…
– Nick.McDermaid
Nov 8 at 10:58
add a comment |
2 Answers
2
active
oldest
votes
up vote
1
down vote
accepted
See the package source. It says SSIS Catalog. You'll find your package at below location:
Integration Services Catalogs -> SSISDB -> <your package path>
The reason being, you've deployed the SSIS solution as Project Deployment Mode
Additional info : Microsoft document on SSIS deployment mode
answered Nov 8 at 12:22
Prabhat G
2,34411324
add a comment |
up vote
3
down vote
one way to view the package in visual studio is as follows:
Step 1.
Open a integration services project in visual studio
Step 2.
Add a existing package in the solution explorer
Step 3.
Select SQL server and type in the adress of the SSISserver where your package is located. Then click on the dots on right side of the screen and select the package path.
answered Nov 8 at 10:38
ppijnenburg
143110
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
See the package source. It says SSIS Catalog. You'll find your package at below location:
Integration Services Catalogs -> SSISDB -> <your package path>
The reason being, you've deployed the SSIS solution as Project Deployment Mode
Additional info : Microsoft document on SSIS deployment mode
answered Nov 8 at 12:22
Prabhat G
2,34411324
add a comment |
up vote
1
down vote
accepted
See the package source. It says SSIS Catalog. You'll find your package at below location:
Integration Services Catalogs -> SSISDB -> <your package path>
The reason being, you've deployed the SSIS solution as Project Deployment Mode
Additional info : Microsoft document on SSIS deployment mode
answered Nov 8 at 12:22
Prabhat G
2,34411324
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
See the package source. It says SSIS Catalog. You'll find your package at below location:
Integration Services Catalogs -> SSISDB -> <your package path>
The reason being, you've deployed the SSIS solution as Project Deployment Mode
Additional info : Microsoft document on SSIS deployment mode
answered Nov 8 at 12:22
Prabhat G
2,34411324
See the package source. It says SSIS Catalog. You'll find your package at below location:
Integration Services Catalogs -> SSISDB -> <your package path>
The reason being, you've deployed the SSIS solution as Project Deployment Mode
Additional info : Microsoft document on SSIS deployment mode
answered Nov 8 at 12:22
Prabhat G
2,34411324
answered Nov 8 at 12:22
Prabhat G
2,34411324
answered Nov 8 at 12:22
Prabhat G
2,34411324
answered Nov 8 at 12:22
Prabhat G
2,34411324
2,34411324
add a comment |
add a comment |
up vote
3
down vote
one way to view the package in visual studio is as follows:
Step 1.
Open a integration services project in visual studio
Step 2.
Add a existing package in the solution explorer
Step 3.
Select SQL server and type in the adress of the SSISserver where your package is located. Then click on the dots on right side of the screen and select the package path.
answered Nov 8 at 10:38
ppijnenburg
143110
add a comment |
up vote
3
down vote
one way to view the package in visual studio is as follows:
Step 1.
Open a integration services project in visual studio
Step 2.
Add a existing package in the solution explorer
Step 3.
Select SQL server and type in the adress of the SSISserver where your package is located. Then click on the dots on right side of the screen and select the package path.
answered Nov 8 at 10:38
ppijnenburg
143110
add a comment |
up vote
3
down vote
up vote
3
down vote
one way to view the package in visual studio is as follows:
Step 1.
Open a integration services project in visual studio
Step 2.
Add a existing package in the solution explorer
Step 3.
Select SQL server and type in the adress of the SSISserver where your package is located. Then click on the dots on right side of the screen and select the package path.
answered Nov 8 at 10:38
ppijnenburg
143110
one way to view the package in visual studio is as follows:
Step 1.
Open a integration services project in visual studio
Step 2.
Add a existing package in the solution explorer
Step 3.
Select SQL server and type in the adress of the SSISserver where your package is located. Then click on the dots on right side of the screen and select the package path.
answered Nov 8 at 10:38
ppijnenburg
143110
answered Nov 8 at 10:38
ppijnenburg
143110
answered Nov 8 at 10:38
ppijnenburg
143110
answered Nov 8 at 10:38
ppijnenburg
143110
143110
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53199796%2fhow-to-access-dtsx-file-in-sql-agent-job-step-in-sql-server-2016%23new-answer', 'question_page');
}
);
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
It's in the SSIS catalog. Take a look at "exporting an SSIS package in managent studio" mssqltips.com/sqlservertip/1428/…
– Nick.McDermaid
Nov 8 at 10:58