SSIS Package Corrupted - How to resurrect?
A SQL Server SSIS project is corrupted when I pull it up in Visual Studio. However, the job behind this project/package is still running correctly and it is creating the proper extract file. Is there a way to pull the SSIS package down from the server as opposed to pulling it from a local project file? We tried restoring from an earlier backup version but that was also corrupted somehow. The timestamp on the file doesn't show it as having been modified for years so we're not sure what went wrong at this point we're just trying to resurrect the project/package. Any help you can provide is appreciated.
ssis
asked Sep 1 '15 at 12:59
maggief83maggief83
134
add a comment |
A SQL Server SSIS project is corrupted when I pull it up in Visual Studio. However, the job behind this project/package is still running correctly and it is creating the proper extract file. Is there a way to pull the SSIS package down from the server as opposed to pulling it from a local project file? We tried restoring from an earlier backup version but that was also corrupted somehow. The timestamp on the file doesn't show it as having been modified for years so we're not sure what went wrong at this point we're just trying to resurrect the project/package. Any help you can provide is appreciated.
ssis
asked Sep 1 '15 at 12:59
maggief83maggief83
134
I've generally been able to open .dtsx files just copied from the production server in SQLServer BI Design Studio, if thats what you are asking.
– Frank Thomas
Sep 1 '15 at 13:04
1
I was able to figure it out. in mgmt. studio I connected to server/integration services, expanded the packages, right clicked on the package, chose Export. Thank you
– maggief83
Sep 1 '15 at 16:20
add a comment |
A SQL Server SSIS project is corrupted when I pull it up in Visual Studio. However, the job behind this project/package is still running correctly and it is creating the proper extract file. Is there a way to pull the SSIS package down from the server as opposed to pulling it from a local project file? We tried restoring from an earlier backup version but that was also corrupted somehow. The timestamp on the file doesn't show it as having been modified for years so we're not sure what went wrong at this point we're just trying to resurrect the project/package. Any help you can provide is appreciated.
ssis
asked Sep 1 '15 at 12:59
maggief83maggief83
134
A SQL Server SSIS project is corrupted when I pull it up in Visual Studio. However, the job behind this project/package is still running correctly and it is creating the proper extract file. Is there a way to pull the SSIS package down from the server as opposed to pulling it from a local project file? We tried restoring from an earlier backup version but that was also corrupted somehow. The timestamp on the file doesn't show it as having been modified for years so we're not sure what went wrong at this point we're just trying to resurrect the project/package. Any help you can provide is appreciated.
ssis
ssis
asked Sep 1 '15 at 12:59
maggief83maggief83
134
asked Sep 1 '15 at 12:59
maggief83maggief83
134
asked Sep 1 '15 at 12:59
maggief83maggief83
134
asked Sep 1 '15 at 12:59
maggief83maggief83
134
asked Sep 1 '15 at 12:59
maggief83maggief83
134
134
I've generally been able to open .dtsx files just copied from the production server in SQLServer BI Design Studio, if thats what you are asking.
– Frank Thomas
Sep 1 '15 at 13:04
1
I was able to figure it out. in mgmt. studio I connected to server/integration services, expanded the packages, right clicked on the package, chose Export. Thank you
– maggief83
Sep 1 '15 at 16:20
add a comment |
I've generally been able to open .dtsx files just copied from the production server in SQLServer BI Design Studio, if thats what you are asking.
– Frank Thomas
Sep 1 '15 at 13:04
1
I was able to figure it out. in mgmt. studio I connected to server/integration services, expanded the packages, right clicked on the package, chose Export. Thank you
– maggief83
Sep 1 '15 at 16:20
I've generally been able to open .dtsx files just copied from the production server in SQLServer BI Design Studio, if thats what you are asking.
– Frank Thomas
Sep 1 '15 at 13:04
I've generally been able to open .dtsx files just copied from the production server in SQLServer BI Design Studio, if thats what you are asking.
– Frank Thomas
Sep 1 '15 at 13:04
1
1
I was able to figure it out. in mgmt. studio I connected to server/integration services, expanded the packages, right clicked on the package, chose Export. Thank you
– maggief83
Sep 1 '15 at 16:20
I was able to figure it out. in mgmt. studio I connected to server/integration services, expanded the packages, right clicked on the package, chose Export. Thank you
– maggief83
Sep 1 '15 at 16:20
add a comment |
1 Answer
1
active
oldest
votes
In my case only project file gets corrpted, leaving all other dependent files(packages, project params, connections etc) as they are. So i generally create a new project file and add all the existing files to it and its good to go.
answered Jan 16 at 17:59
Sanjay KattimaniSanjay Kattimani
1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f965802%2fssis-package-corrupted-how-to-resurrect%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In my case only project file gets corrpted, leaving all other dependent files(packages, project params, connections etc) as they are. So i generally create a new project file and add all the existing files to it and its good to go.
answered Jan 16 at 17:59
Sanjay KattimaniSanjay Kattimani
1
add a comment |
In my case only project file gets corrpted, leaving all other dependent files(packages, project params, connections etc) as they are. So i generally create a new project file and add all the existing files to it and its good to go.
answered Jan 16 at 17:59
Sanjay KattimaniSanjay Kattimani
1
add a comment |
In my case only project file gets corrpted, leaving all other dependent files(packages, project params, connections etc) as they are. So i generally create a new project file and add all the existing files to it and its good to go.
answered Jan 16 at 17:59
Sanjay KattimaniSanjay Kattimani
1
In my case only project file gets corrpted, leaving all other dependent files(packages, project params, connections etc) as they are. So i generally create a new project file and add all the existing files to it and its good to go.
answered Jan 16 at 17:59
Sanjay KattimaniSanjay Kattimani
1
answered Jan 16 at 17:59
Sanjay KattimaniSanjay Kattimani
1
answered Jan 16 at 17:59
Sanjay KattimaniSanjay Kattimani
1
answered Jan 16 at 17:59
Sanjay KattimaniSanjay Kattimani
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f965802%2fssis-package-corrupted-how-to-resurrect%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I've generally been able to open .dtsx files just copied from the production server in SQLServer BI Design Studio, if thats what you are asking.
– Frank Thomas
Sep 1 '15 at 13:04
1
I was able to figure it out. in mgmt. studio I connected to server/integration services, expanded the packages, right clicked on the package, chose Export. Thank you
– maggief83
Sep 1 '15 at 16:20