score:0
You can create an event handler onPostExecute of the pacakge and add the proc on an execute SQL Task in there
OR
add all your current components inside a sequence container and drag the green arrow to a new execute sql task component with your procedure. Double click the green arrow and select "Completion" instead of "Success"
score:0
OnPostExecute gets executed for every tasks. So this is not good for a requirement that expects OnPackageEnd kind of an event.
score:3
Well I think the simplest thing is to add the execution of the proc as a second step in the job that executes the package, you can specify there that you can go to the next step on failure as well as on success.
Or you put the Exec SQL task to execute the package at the end of the process (that gets the success branch) and put it in the event handler for all failures (we do the event handler at the package level not for individual steps), we do that for one step where we run the same proc but with different input values in case of failure or success.
score:5
In the package put all the tasks in a container. And below the container put the execute proceduer task and for precedence constraint choose values as "Completion"(The line will be in Blue color, green by default). So irrespective of the package status (success or fail) the stored proc will be executed.
More questions
- SSIS Event (or something) when a package ends
- Disabling SSIS Package Validation when Loading a Package in the VS Designer
- Why does my ODBC connection fail when running an SSIS load in Visual Studio but not when running the same package using Execute Package Utility
- How to schedule SSIS package to run as something other than SQL Agent Service Account
- How do you get an SSIS package to only insert new records when copying data between servers
- CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server
- How to execute SSIS package when a file is arrived at folder
- Can't access a network share when executing a package from the SSIS Catalog
- SQL Agent Job failes when trying to execute SSIS package due to some permission issues
- SSIS package fails to process all rows with C# Script task when started with SQL Server Agent
- How to Make SSIS Package Fail When There's No Row
- SSIS package fails when runs by sql job agent
- When I save SSIS package the changes are lost
- SQL Job sql ssis job ERROR: "the package failed to load due to error 0xC0010014 this occurs when CPackage::LoadFROMXML fails
- Visual Studio 2019 SSIS package does not run when starting in IDE (only validates)
- "Error at Data Flow Task" in SSIS package when trying to simulate CASE expression
- SSIS package fails when run by SQL Agent - "Invalid character value for cast specification"
- Evaluated variable and successfully evaluated package in VS-2017 SSIS does not work when executed in ssms
- SSIS Package loading data from Excel fails when run as a job
- Trigger SSIS package when a file is uploaded to Azure blob storage
- How to know SSIS run package issue when trying to execute
- SSIS package failure when executed in windows task schedule
- Error encountered when executing SSIS package
- SSIS stuck in validation when running package (SQL Server 2016)
- SSIS package - Script task does not get executed when triggered through SQL Job Agent
- SSIS package can't access directory when run on SQL Server
- Why does child SSIS package's .dtsx file get opened in BIDS when running parent package in debug mode?
- Parser NULL (DTEParseMgd) error when trying to set up SSIS package job
- Package part debugging is not supported when starting SSIS package
- Some of the tasks in the SSIS package failed when I migrated the package to another server
More questions with similar tag
- Match Columns in Table A to Row Values in Table B to update another Column in Table B
- Django SQL Server Error: "Cannot create new connection because in manual or distributed transaction mode."
- Where can I find debugging errors in my SSIS package?
- Whats wrong with this SQL statement for table variable bulk insert
- Extended Events - Object cannot be added to the event session
- Decimal Truncation/Rounding difference in console and though JDBC
- Only the first character of random id is inserted to the sql table
- SQL to Subtract timestamps in same column but different rows
- Paging in Common Table Value Expression(CTE), OFFSET/FETCH and Inner SELECT
- How to Select Column With Max Value In T-SQL?
- Pyodbc MS SQL Server - Chinese turns into gibberish
- Complex Joining multiple tables in SQL Server for a fact table
- Count occurences of a pattern in SQL Server column
- C# use script to create database
- SQL Server running a filecheck on a different server
- update granted on view, but cannot update underlying table, why?
- Enforcing exclusivity in table inheritance: composite foreign key vs check constraint
- MVC 4 Return null even the value does exist in database
- Conversion of 12 Hour Clock to 24 Hour Clock in SQL Server
- Search SQL DB's For A Specific Word
- Create New SQL Server Database in Visual Studio 2017
- select * columns but group by two specific columns in sql
- Transaction in middle of SQL Server Full bckup
- SQL Chinese formatting year part of a date
- insert into table values(int ,int ,time ,time ) Sql Server
- Need T-SQL Query for Groups and Islands
- Trigger on affected column
- must declare the scaler variable in sql
- SQL Server query with subquery to LINQ query
- Not SELECTing a row if it is empty