by Jeanne Combrinck | Jun 13, 2018 | SQL Girl
It can be confusing to know which tool in the SSIS toolbox to use when trying to execute a PowerShell script from within SSIS. The best task to use is an Execute Process Task. Under General you can give it a name and a description. This post first appeared...
by Jeanne Combrinck | Jun 12, 2018 | SQL Girl
There isn’t much online about saving an output of data to an XML file. When trying with a file system task it throws errors. There is a workaround for this. You can use a data flow task in SSIS to export to a flat file that is an XML file. You simply need to have a...
by Jeanne Combrinck | Dec 19, 2017 | SQL Girl
There are some people who cancel a SSRS report because its taking to long by just closing visual studio or their browser. Then they reopen SSRS/browser and try and view the report again. In the mean time the previous report they were trying to run the query is still...
by Jeanne Combrinck | Nov 24, 2017 | SQL Girl
Recently I was trying to send a file via Email in SSIS. For the connection to the file I was using a variable as the file name changes everyday. This post first appeared at http://thesqlgirl.com/2017/11/24/ssis-email-task-delay-validation/. The author is Jeanne...
by Jeanne Combrinck | Nov 22, 2017 | SQL Girl
After restarting a server that has MDS on, I could no longer access MDS via the browser. This seemed very strange as I have restarted the server multiple times and it had never done this before. Turns out the Application Pool had stopped for MDS. So I started it up...
by Jeanne Combrinck | Nov 14, 2017 | SQL Girl
A while ago I was having some issues with SSIS and moving files. There was a hidden file called thumbs.db When SSIS was running the move file task it would fail because it can’t place duplicate files in the same location. The thumbs.db file was the problem. Even...