sqlsql-serverssis-2008
Validations within the SSIS
I currently have the following flow in an SSIS
My question is, is there any way to place an OLE DB, which allows me to insert information into a table called errors if Excel Source fails, in a few words, if the Excel file does not exist, I want to save 3 things in the table of errors, which would be, the date, an action and the message it produces. Is it possible to do this?
Solution
You can find it through Event Handler Tab in SSIS Paackage on the right of Parameters tab.
For further details, to accomplish your needs, please explore the Event Handler in SSIS, as you can see there is "OnError" right there, and there are plenty of options which occuring events that you may want to validate or make actions with, which also this including Error.
- SQL Server Operating system error 5: "5(Access is denied.)"
- Modelling a Meals / Recipes / Foods database
- Shapiro-Wilk test
- Select rows for a specific date using TIMESTAMP datatype
- How do I DELETE with WHERE and IN using a composite primary key?
- String Matching Struggle
- SQL-Server: Error - Exclusive access could not be obtained because the database is in use
- Apache Spark: "with as" vs "cache"
- What COLLATE should i set to use all kind of possible languages?
- Authenticate from Linux to Windows SQL Server with pyodbc
- SQL query to return total and percentage calculation grouped by day
- MYSQL - SELECT NULL otherwise latest DATE per group
- Add an incremental categorical column
- Create Table Computed Value
- PostgreSQL Crosstab Query
- WHERE clause that needs to be NULL or NOT NULL
- A mathematical way to divide overlapping time ranges into hours
- Replacing window function OVER() with WINDOW clause reference yields different results
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- Dateadd for moving 7 day avg VS (partition by price order by date rows between 6 preceding and current row)
- SQL Server does not exist or access denied
- Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
- Checking if a value exists in database
- Redshift GROUP BY ALL syntax not supported
- Sum by ID in another table
- How to store SQL query result into variable to include in a later SELECT statement
- Dapper: is it possible to customize the type mapping of a specific field of a specific type?
- MySQL query finding values in a comma separated string
- Overlay table mechanism in SQLite
- Python SqlAlchemy adding escape characters to json string while inserting in postgresql json column, so queries not working