This means that something as trivial as a sick day can result in a system or data problem ... Flat File Import into SQL Server Now that you’ve automated the fetching of your flat file via ...

but you will need to export the data from the database, probably do an EBCDIC -> ascii translation, process the export so that it will import into SQL server, then import into SQL server.

Enter PowerBI (at www.powerbi.com). PowerBI is a set of add-ins to Excel 2013 which combines the data management features of SQL Server relational databases and SQL Server Analysis Services (SSAS) ...