Find SSIS package which calls stored procedureError while running SSIS Package job in SSMSHow can I invoke an...
Why is airport car rental so cheap
What is the reason behind this musical reference to Pinocchio in the Close Encounters main theme?
Is layered encryption more secure than long passwords?
Can I combine Divination spells with Arcane Eye?
Why Is Image Exporting At Larger Dimensions Than In Illustrator File?
Is there a way to pause a running process on Linux systems and resume later?
How do I know my password or backup information is not being shared when creating a new wallet?
How to modify 'inter arma enim silent leges' to mean 'in a time of crisis, the law falls silent'?
How to typeset a small black square as a binary operator?
How bad is a Computer Science course that doesn't teach Design Patterns?
Are encryption algorithms with fixed-point free permutations inherently flawed?
A cancellation property for permutations
What did Putin say about a US deep state in his state-of-the-nation speech; what has he said in the past?
Exploding Numbers
How can guns be countered by melee combat without raw-ability or exceptional explanations?
Why does this quiz question say that protons and electrons do not combine to form neutrons?
Can you wish for more wishes from an Efreeti bound to service via an Efreeti Bottle?
What is the name of this perspective and how is it constructed?
Ramanujan's radical and how we define an infinite nested radical
Why would you use 2 alternate layout buttons instead of 1, when only one can be selected at once
Confusion about different running times of two algorithms in C
Is Screenshot Time-tracking Common?
Coworker is trying to get me to sign his petition to run for office. How to decline politely?
Is it possible to detect 100% of SQLi with a simple regex?
Find SSIS package which calls stored procedure
Error while running SSIS Package job in SSMSHow can I invoke an SSIS package from SQL Agent, via T-SQL, using a proxySSIS package hits “login failed for user” when simultaneous operations occur against the same target databaseExecuting SSIS Package from a stored procedure with different user privilegesLogging Stored Procedure Parameter ValuesHow to get the current line number from an executing stored procedureChange SSIS package authorsSSIS Promote Package - Move Some Stored ProceduresExecuting SSIS catalogue package from a different machine, authentication failRunning SSIS jobs sequentially in T-SQL
We are trying to catch errors into an Error Log Table, similar to below.
We have many Master SSIS packages, calling many stored procedures.
Following code will log into the Error Log Table. Is there a SQL reserved keyword to find the SSIS package which executed the stored procedure?
insert into dbo.ErrorLogData
(
ErrorNumber
,ErrorDescription
,ErrorProcedure
,ErrorState
,ErrorSeverity
,ErrorLine
,ErrorTime
,SSISPackage --???
)
VALUES
(
ERROR_NUMBER()
,ERROR_MESSAGE()
,ERROR_PROCEDURE()
,ERROR_STATE()
,ERROR_SEVERITY()
,ERROR_LINE()
,GETDATE()
-- what is reserved keyword for SSIS package?
);
https://www.tech-recipes.com/rx/53462/sql-server-error-logging-and-reporting-within-a-stored-procedure/
sql-server sql-server-2016 stored-procedures ssis logging
asked 10 mins ago
Joe Smith 8435Joe Smith 8435
195
add a comment |
We are trying to catch errors into an Error Log Table, similar to below.
We have many Master SSIS packages, calling many stored procedures.
Following code will log into the Error Log Table. Is there a SQL reserved keyword to find the SSIS package which executed the stored procedure?
insert into dbo.ErrorLogData
(
ErrorNumber
,ErrorDescription
,ErrorProcedure
,ErrorState
,ErrorSeverity
,ErrorLine
,ErrorTime
,SSISPackage --???
)
VALUES
(
ERROR_NUMBER()
,ERROR_MESSAGE()
,ERROR_PROCEDURE()
,ERROR_STATE()
,ERROR_SEVERITY()
,ERROR_LINE()
,GETDATE()
-- what is reserved keyword for SSIS package?
);
https://www.tech-recipes.com/rx/53462/sql-server-error-logging-and-reporting-within-a-stored-procedure/
sql-server sql-server-2016 stored-procedures ssis logging
asked 10 mins ago
Joe Smith 8435Joe Smith 8435
195
add a comment |
We are trying to catch errors into an Error Log Table, similar to below.
We have many Master SSIS packages, calling many stored procedures.
Following code will log into the Error Log Table. Is there a SQL reserved keyword to find the SSIS package which executed the stored procedure?
insert into dbo.ErrorLogData
(
ErrorNumber
,ErrorDescription
,ErrorProcedure
,ErrorState
,ErrorSeverity
,ErrorLine
,ErrorTime
,SSISPackage --???
)
VALUES
(
ERROR_NUMBER()
,ERROR_MESSAGE()
,ERROR_PROCEDURE()
,ERROR_STATE()
,ERROR_SEVERITY()
,ERROR_LINE()
,GETDATE()
-- what is reserved keyword for SSIS package?
);
https://www.tech-recipes.com/rx/53462/sql-server-error-logging-and-reporting-within-a-stored-procedure/
sql-server sql-server-2016 stored-procedures ssis logging
asked 10 mins ago
Joe Smith 8435Joe Smith 8435
195
We are trying to catch errors into an Error Log Table, similar to below.
We have many Master SSIS packages, calling many stored procedures.
Following code will log into the Error Log Table. Is there a SQL reserved keyword to find the SSIS package which executed the stored procedure?
insert into dbo.ErrorLogData
(
ErrorNumber
,ErrorDescription
,ErrorProcedure
,ErrorState
,ErrorSeverity
,ErrorLine
,ErrorTime
,SSISPackage --???
)
VALUES
(
ERROR_NUMBER()
,ERROR_MESSAGE()
,ERROR_PROCEDURE()
,ERROR_STATE()
,ERROR_SEVERITY()
,ERROR_LINE()
,GETDATE()
-- what is reserved keyword for SSIS package?
);
https://www.tech-recipes.com/rx/53462/sql-server-error-logging-and-reporting-within-a-stored-procedure/
sql-server sql-server-2016 stored-procedures ssis logging
sql-server sql-server-2016 stored-procedures ssis logging
asked 10 mins ago
Joe Smith 8435Joe Smith 8435
195
asked 10 mins ago
Joe Smith 8435Joe Smith 8435
195
asked 10 mins ago
Joe Smith 8435Joe Smith 8435
195
asked 10 mins ago
Joe Smith 8435Joe Smith 8435
195
asked 10 mins ago
Joe Smith 8435Joe Smith 8435
195
195
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f230431%2ffind-ssis-package-which-calls-stored-procedure%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f230431%2ffind-ssis-package-which-calls-stored-procedure%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
