What else can we do? What are our other options? That’s where Powershell comes in: it’s a tool which can quite literally take care of almost everything. It’s possible to handle this in SSIS but it’s more complex than it seems. Imagine creating an Excel based SSIS package & loading new data into the database on a weekly or daily basis & every single time the dynamic Excel file is updated. They’re entitled to their perspectives but in my opinion, SSIS can be a bit tricky when it comes to loading Excel data. Instead, imagine that you want to automate the process of loading Excel data into SQL Server. How would you do it? Some people might suggest using SSIS to load the data easily on SQL Server. It’s a manual work for loading files into SQL using a wizard. Have you ever heard of the traditional Import/Export Wizard in MS-SQL? It’s an add-on in MS-SQL that allows you to manually import flat files into your database. In this blog, I would love to share my learning on this cool PowerShell feature for excel import using “ ImportExcel” module. It can do everything from creating folders to moving files to restoring databases by using PowerShell Scripting: a compact scripting language that simplifies life for us developers. Windows PowerShell is a tiny yet powerful utility tool used by DBAs & Microsoft developers all around the world. Windows PowerShell Integrated Scripting Environment (ISE)
0 Comments
Leave a Reply. |