SSIS package hangs on Setting Source ConnectionExecuting SSIS packageSQL Server 2008 SSIS package compatabilitySQL Server 2008 Recovery Mode reverts from FULL to SIMPLEExecute SSIS package from a SQL Agent on another serverSQL 2005 SSIS and PackageSQLServer2008 CopyDatabaseWizard Job Fails - Unable to determine if owner of job has server accessEdit SQL Server SSIS PackageThe package failed to load due to error 0xC0011008 Error Loading from XMLDistributed and/or Parallel SSIS processingSQL server agent job to execute SSIS package fails, package succeds if run manually
Zombie diet, why humans?
Can a US President have someone sent to prison?
Can I use the PWM pins as regular digital input/output pins?
Why won't the ground take my seed?
What does Mildred mean by this line in Three Billboards Outside Ebbing, Missouri?
How to determine what is the correct level of detail when modelling?
Children's short story about material that accelerates away from gravity
Is it allowed to spend a night in the first entry country before moving to the main destination?
Should I hide continue button until tasks are completed?
Was touching your nose a greeting in second millenium Mesopotamia?
Is it bad to describe a character long after their introduction?
Generate and graph the Recamán Sequence
How to start learning the piano again
In which public key encryption algorithms are the private and public key not reversible?
In the context of a differentiator circuit, what is a “current-sensing resistor”?
Does a centaur PC also count as being mounted?
Mean Value Theorem: Continuous or Defined?
Alphabet completion rate
Does the UK have a written constitution?
How hard is it to sell a home which is currently mortgaged?
In native German words, is Q always followed by U, as in English?
How fast can a ship with rotating habitats be accelerated?
How can I create headings like these in Microsoft word 2010?
How should I behave to assure my friends that I am not after their money?
SSIS package hangs on Setting Source Connection
Executing SSIS packageSQL Server 2008 SSIS package compatabilitySQL Server 2008 Recovery Mode reverts from FULL to SIMPLEExecute SSIS package from a SQL Agent on another serverSQL 2005 SSIS and PackageSQLServer2008 CopyDatabaseWizard Job Fails - Unable to determine if owner of job has server accessEdit SQL Server SSIS PackageThe package failed to load due to error 0xC0011008 Error Loading from XMLDistributed and/or Parallel SSIS processingSQL server agent job to execute SSIS package fails, package succeds if run manually
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have an SSIS package that has been executing successfully for the last 7 years.
All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via End Task. I can access all of the databases but cannot run this package.
I believe one of our helpdesk admins may have messed something up when setting up the backup jobs on our backupexec server.
Can anyone give me some help as to what the cause could be? I have understood it to be a permissions error, but I am not clear where that could be.
security sql-server-2008 ssis
edited Jan 27 '12 at 6:48
Kenny Rasschaert
7,8073 gold badges34 silver badges56 bronze badges
asked Jan 10 '12 at 21:05
kereberoskereberos
1012 bronze badges
add a comment |
I have an SSIS package that has been executing successfully for the last 7 years.
All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via End Task. I can access all of the databases but cannot run this package.
I believe one of our helpdesk admins may have messed something up when setting up the backup jobs on our backupexec server.
Can anyone give me some help as to what the cause could be? I have understood it to be a permissions error, but I am not clear where that could be.
security sql-server-2008 ssis
edited Jan 27 '12 at 6:48
Kenny Rasschaert
7,8073 gold badges34 silver badges56 bronze badges
asked Jan 10 '12 at 21:05
kereberoskereberos
1012 bronze badges
add a comment |
I have an SSIS package that has been executing successfully for the last 7 years.
All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via End Task. I can access all of the databases but cannot run this package.
I believe one of our helpdesk admins may have messed something up when setting up the backup jobs on our backupexec server.
Can anyone give me some help as to what the cause could be? I have understood it to be a permissions error, but I am not clear where that could be.
security sql-server-2008 ssis
edited Jan 27 '12 at 6:48
Kenny Rasschaert
7,8073 gold badges34 silver badges56 bronze badges
asked Jan 10 '12 at 21:05
kereberoskereberos
1012 bronze badges
I have an SSIS package that has been executing successfully for the last 7 years.
All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via End Task. I can access all of the databases but cannot run this package.
I believe one of our helpdesk admins may have messed something up when setting up the backup jobs on our backupexec server.
Can anyone give me some help as to what the cause could be? I have understood it to be a permissions error, but I am not clear where that could be.
security sql-server-2008 ssis
security sql-server-2008 ssis
edited Jan 27 '12 at 6:48
Kenny Rasschaert
7,8073 gold badges34 silver badges56 bronze badges
asked Jan 10 '12 at 21:05
kereberoskereberos
1012 bronze badges
edited Jan 27 '12 at 6:48
Kenny Rasschaert
7,8073 gold badges34 silver badges56 bronze badges
asked Jan 10 '12 at 21:05
kereberoskereberos
1012 bronze badges
edited Jan 27 '12 at 6:48
Kenny Rasschaert
7,8073 gold badges34 silver badges56 bronze badges
edited Jan 27 '12 at 6:48
Kenny Rasschaert
7,8073 gold badges34 silver badges56 bronze badges
edited Jan 27 '12 at 6:48
Kenny Rasschaert
7,8073 gold badges34 silver badges56 bronze badges
7,8073 gold badges34 silver badges56 bronze badges
asked Jan 10 '12 at 21:05
kereberoskereberos
1012 bronze badges
asked Jan 10 '12 at 21:05
kereberoskereberos
1012 bronze badges
asked Jan 10 '12 at 21:05
kereberoskereberos
1012 bronze badges
1012 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
In the SSIS package, locate the Connection Manager for the DB you are trying to connect to. On the properties panel of that connection manager, set the 'Persist Connection' property to TRUE. This will maintain an active connection to the database server through the entire life of the package instead of only creating a connection for a specific task. It's a long shot, but worth a try.
answered Jan 17 '12 at 16:12
OliverAsmusOliverAsmus
1011 bronze badge
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
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%2fserverfault.com%2fquestions%2f348624%2fssis-package-hangs-on-setting-source-connection%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 the SSIS package, locate the Connection Manager for the DB you are trying to connect to. On the properties panel of that connection manager, set the 'Persist Connection' property to TRUE. This will maintain an active connection to the database server through the entire life of the package instead of only creating a connection for a specific task. It's a long shot, but worth a try.
answered Jan 17 '12 at 16:12
OliverAsmusOliverAsmus
1011 bronze badge
add a comment |
In the SSIS package, locate the Connection Manager for the DB you are trying to connect to. On the properties panel of that connection manager, set the 'Persist Connection' property to TRUE. This will maintain an active connection to the database server through the entire life of the package instead of only creating a connection for a specific task. It's a long shot, but worth a try.
answered Jan 17 '12 at 16:12
OliverAsmusOliverAsmus
1011 bronze badge
add a comment |
In the SSIS package, locate the Connection Manager for the DB you are trying to connect to. On the properties panel of that connection manager, set the 'Persist Connection' property to TRUE. This will maintain an active connection to the database server through the entire life of the package instead of only creating a connection for a specific task. It's a long shot, but worth a try.
answered Jan 17 '12 at 16:12
OliverAsmusOliverAsmus
1011 bronze badge
In the SSIS package, locate the Connection Manager for the DB you are trying to connect to. On the properties panel of that connection manager, set the 'Persist Connection' property to TRUE. This will maintain an active connection to the database server through the entire life of the package instead of only creating a connection for a specific task. It's a long shot, but worth a try.
answered Jan 17 '12 at 16:12
OliverAsmusOliverAsmus
1011 bronze badge
answered Jan 17 '12 at 16:12
OliverAsmusOliverAsmus
1011 bronze badge
answered Jan 17 '12 at 16:12
OliverAsmusOliverAsmus
1011 bronze badge
answered Jan 17 '12 at 16:12
OliverAsmusOliverAsmus
1011 bronze badge
1011 bronze badge
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- 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%2fserverfault.com%2fquestions%2f348624%2fssis-package-hangs-on-setting-source-connection%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
