Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2013-07-18 : 17:48:45
|
| Hello, I found a package file that is in production. I need to modify the package but the only file is .dtsx. No project, no solution files.When I double-click the file it opens in Visual Studio but only shows the DTS Properties. I want to modify connections, tasks.This package may have been built via the Import/Export wizard.How can I modify the package?Thanks Jack |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-19 : 00:51:51
|
| You need to start a new project of type Integration Server Project in Visual Studio/BIDS and then right click on packages choose add existing package and browse to .DTSX file to get it added to project. Then you would be able to modify connections, tasks etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
How to edit .DTSX files