This way, you have the possibility to access reports directly through the Database Explorer tree.Ĭonsidering the data export and import wizards that work in the background mode, you are able to easily export your queries, triggers and procedures to HTML, PDF, CSV or XML format and import data from Excel or Access.Īlso, the application enables you to perform database validations and provides you with the ability of rebuilding or recomputing database indices. More helpful is that SQL Manager Lite for InterBase and Firebird enables you to quickly build complicated queries without any SQL knowledge however, if you want to change these queries, you need to know how they work.Īnother feature worth mentioning is the Report Wizard that the utility comes with, allowing you to create simple reports in a few clicks so you can manage them more easily the same way as if they were database objects. This way they can easily filter and group data, copy and paste only the selected rows, or simply export data to SQL scripts. Also, you have the possibility to group registered databases by host name.īeing intended for users, mostly database administrators, the application comes also with advanced Unicode data manipulation tools. What’s more, the application comes with support for multiple connections, so you can manage various databases using a user-friendly window. To sum things up, SQL Manager Lite for InterBase and Firebird provides you with useful visual and text editing tools designed for query building.SQL Manager Lite for InterBase and Firebird is a comprehensive utility designed for users who need the maintain, organize and administer InterBase and Firebird databases.īecause it comes with a powerful and intuitive interface, the application enables you to quickly connect to a database by specifying the host name and the SQL role, selecting the protocol and choosing the database you want to connect to.
DTSExecResult and passing value of connection string and excel path.
After that I'm trying to invoke package by c WPF application by. I have set the connection string and excel file path by expression. SQL Manager Lite for InterBase and Firebird is a comprehensive utility designed for users who need the maintain, organize and administer InterBase and Firebird databases.īecause it comes with a powerful and intuitive interface, the application enables you to quickly connect to a database by specifying the host name and the SQL role, selecting the protocol and choosing the database you want to connect to. I have created a SSIS package to import the excel to sql.