How to use SSIS with Power Query to extract data from Power BI Premium and insert into local CSV
I was helping and answering some questions on the Power BI community forums and I came across a question where someone was looking to query data from Power BI Premium using SSIS (SQL Server Integration Services). This is definitely possible and I will show you below how I can use SSIS, to query data from Power BI Premium and store…
Automating running PowerShell script which required Administrator elevation via SSIS
UPDATE (08 AUG 2016): I have updated this to use a SQL Server Agent Job instead of the Task Scheduler which proved to not be reliable. What we are going to explain below is the following via an example. Example – We are required to run a PowerShell script which will snapshot a database using Xtreme IO from EMC. In…
SSIS – Creating a process which will check a condition, if it is not ready wait and try again.
So we had a requirement where we wanted to create a waiting for loop, so that if it was not ready it would wait, try again, and if still not ready wait and try again until it got to the Max Number of tries. We also did not want it to error whilst waiting. Example: Check to see if the…
Automating running PowerShell script which required Administrator elevation via SSIS
What we are going to explain below is the following via an example. Example – We are required to run a PowerShell script which will run with elevated privileges. So in order to complete this we have to complete the following below but use a simple PowerShell script which will get all the FileNames from a Folder. Create a BAT…
BI-NSIGHT – SQL Server 2016 CTP 3.0 (SSAS, SSRS, SSIS) – Power BI (Chiclet Visual, SparkPost Content Pack, Weekly Service Update, Personal Gateway Update, Tiles in SharePoint)
I expected this week to be a really interesting week with SQL Pass happening. As I was sure to see some really good and interesting updates from Microsoft and it sure is living up to this. There has been a lot of information on Twitter and on other blogs, so here is my take on the developments. SQL Server 2016…
SSIS – Using SSIS Variable within a SQL Script with Temp Tables – Error at Data Flow Task : No Column information was returned by the SQL Command
Below details what I was trying to do within SSIS and how I got it to work. Overview I was using a SQL Script which contained some temp tables which was used in the result set. When I then put this into an OLE DB Source I would get the error shown below: I then tried to see…
BI-NSIGHT Power BI Sweet IQ , Summer Release – SSIS Feature Pack for Azure – Excel 2016 New Chart Options (Treemap, Sunburst, Histogram, Box & Whisker, Waterfall)
Well this week there were some updates and fortunately not too many so where we go! Power BI – Sweet IQ This week, there was yet another release of a content pack for Power BI, this time it was relating to a company called Sweet IQ. They position themselves as provider that can leverage your local search and increase your…
BI-NSIGHT – SQL Server 2016 – Power BI Updates – Microsoft Azure Stack
Well I have to admit that it seems that the Microsoft machine has been working flat out to get out new products and updates. If my memory serves me, this is the third week in a row that Microsoft has released new products and updates. I am really enjoying it! But hopefully this will slow down, so that we can…
SSIS – Configuring SSIS Package to run job after data loading has completed
In our example below, we are going to be using a SharePoint 2013 Data Alert job which was created in SQL Server Agent, and then insert this into an existing SSIS Project. The reason for doing this, is so that every time our SSIS Project runs, as part of the process, it can then fire off a SQL Server Job….
SSIS – Error Handling and Error emailing for Packages
What the steps below do is to handle error handling for your SSIS packages. And then within the error handling enable it so that you can email the exact error to email addresses so that they are notified when there is an error and what the error was. Example: · In our example we are going to be using…