If you’re using Visual Studio 2019 with SSIS, you may encounter an error or two when you start. One error is “incompatible” tacked onto the name of your SSIS project in parentheses: Another error you may encounter is found in the Migration Report, a local htm file that contains information about the the attenpted Visual …
Continue reading SSIS in Visual Studio 2019
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
SSIS in SSMS Version 18: Try SSIS in Azure Data Factory
There’s a new option when you right-click the Integration Services Catalogs node in SSMS v18: “Try SSIS in Azure Data Factory”: Clicking the “Try SSIS in Azure Data Factory” option in SSMS v18 opens the (new) Integration Runtime Creation Wizard (ISIRCreationWizard.exe, which is found in the <installation drive>:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn directory): …
Continue reading SSIS in SSMS Version 18: Try SSIS in Azure Data Factory
SSIS in SSMS Version 18
Version 18 of SQL Server Management Studio (SSMS) has been out for a few weeks now, but I just now had the opportunity to install it and tinker. There are a lot of new features! Here’s a list of SSIS-related features: Added support to allow customers to schedule SSIS packages on Azure-SSIS IRs that …
Continue reading SSIS in SSMS Version 18
Free Webinar: Build and Load a Staging Database with Biml
The next free webinar from Enterprise Data & Analytics is titled Build and Load a Staging Database with Biml – happening 29 May 2019 at 12:00 PM EDT. Abstract Watch Andy Leonard, Microsoft Data Platform MVP and BimlHero, create a Biml solution that would build and load a staging database using Biml with minimal configuration. …
Continue reading Free Webinar: Build and Load a Staging Database with Biml
The Recording for “A Data Science Story” by Shannon Lowder is Available
Shannon Lowder (@shannonlowder | shannonlowder.com) did a fantastic job presenting the true story of a data science project. He presented the problem he was trying to solve, the places he looked for data, issues and obstacles he encountered, and solutions he developed. Enjoy! Links Storm Events files NOAA Hail Data files Microsoft Azure Machine Learning: …
Continue reading The Recording for “A Data Science Story” by Shannon Lowder is Available
Azure-SSIS Starts Faster
I had the honor to deliver “Moving Data with Azure Data Factory at SQL Saturday – Atlanta this weekend. Because Azure changes daily, I fired up an Azure-SSIS instance Integration Runtime the morning of my presentation and walked through my demo. I play a game I call, “What’s Changed in Azure!” It’s a fun game. …
Continue reading Azure-SSIS Starts Faster
SSIS Script Task Error
Has this ever happened to you? You’re tooling along building an SSIS package. You configure a Script Task, press the F5 key, and BAM! Error! DTS Script Task has encountered an exception in user code:Project name: ST_…Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) …
Continue reading SSIS Script Task Error
The Recording for “Is Power BI Right for You?”
Eugene Meidinger (@SQLGene) did a fantastic job answering the question, “Is Power BI Right for You?” today! Want More? Eugene is delivering a full-day training event titled Power BI: Implementing the Other 90% 23 Jun 2019. Register today!
Anders Schneiderman on Changing the World
Earlier this year, Frank (@Tableteer) and I had the honor of interviewing Anders Schneiderman (LinkedIn) on Data Driven. The episode is now live and titled Anders Schneiderman on Why We Need to Prepare Communities for the Future of Work. Anders has a plan to help people leverage emerging technology to transform their destiny. Anders’ plan …
Continue reading Anders Schneiderman on Changing the World
Free Webinar: A Data Science Story
From Shannon Lowder, Data Scientist, BimlHero: “You’ve all heard about data scientists, and seen job postings for them. But what is the job like, really? “Let me share the story of my first official data science project. While sharing the story I’ll stop to point out the skills used that many DBAs, PowerShell junkies, BI …
Continue reading Free Webinar: A Data Science Story