Last post Jan 23, 2017 09:38 AM by kaushalparik27
Jan 23, 2017 08:06 AM|mnmhemaj|LINK
I have an SSIS package to update tables in a database from different databases.
Some databases are located in our subsidiaries like China, Singapore etc.
Before populating the tables I do a truncation of the tables.
Sometimes there are problems with the SQL connection to subsidiary databases and the tables are empty as only the truncation is executed.
So before truncation I want to do a check if the database connection is available. If not, I won’t neither truncate nor insert data.
How can I do that in SSIS?
Jan 23, 2017 09:38 AM|kaushalparik27|LINK
check if the database connection is available
Practically, database connection would be dependent on "at this moment network status/speed". So, it is quite possible that at the time of checking Network speed and connection is fine and you are able to connect but when actually performing insert operation
the database connection get lost in between.
Alternatively, what you can make use of Database Transaction, Create temporary tables to transfer data from subsidiary databases first and then move data from those temporary tables to actual tables. This approach would be more fail safe then getting data
lost in between insert operation
hope it helps./.