CODEWITHSUNDEEP
sql-serverssis
chamara
chamara

Reputation: 12711

Edit .dtsx file without the SSIS project

We got a SSIS maintenance plan package in our client's server which does the database backups (Back Up Database Task). We need to export this package to a new database server and need to change the backup locations and sql serer server configurations in the package.

The problem is we do not have the actual SSIS project but the .dtsx file.It's possible to do the changes just by using .dtsx file design by opening it on SQL Server Data Tools but does it require to do a build and then import the file in to stored packages?

Upvotes: 0

Views: 3099

Answers (1)

ViKiNG
ViKiNG

Reputation: 1334

As per my experience, take a backup of the file, open the file in notepad or notepad++ and edit the locations. it is that simple. And should test first in UAT or PreProd :)

Upvotes: 1

Related Questions