My Twitter DMs are open @AndyLeonard. Ask me a question about SSIS, ADF, or Biml. I may answer it with a blog post, a video, or both. Today’s Andy Answer is an answer to an SSIS question received via @AndyLeonard direct message: Using SSDT, I have 3 variables: one for the file path, one for …
Continue reading Andy Answers: Format a Flat File Name
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. :{>
Enterprise Data & Analytics Welcomes Eugene Meidinger!
I am honored and thrilled to welcome Eugene Meidinger (@SQLGene | blog | LinkedIn | Pluralsight) to the Enterprise Data & Analytics team! Eugene is self-described as a Business Intelligence Consultant but I think he’s being modest (in my humble opinion… see what I did there?). Eugene has authored three Pluralsight courses on the topics Power BI, DAX, Power Pivot, and SSAS. His …
Continue reading Enterprise Data & Analytics Welcomes Eugene Meidinger!
SSIS Project Connection Manager Naming Error
I am sometimes asked, “Andy, how do I start a technical blog?” I demonstrate one way here – a way that has served me well with search engines. 1. Describe how the error occurred.2. Copy the error message, post it as text. 3. Describe the solution. I am helping a large enterprise client migrate their data integration …
Continue reading SSIS Project Connection Manager Naming Error
Start Azure-SSIS, Execute Package, Stop Azure-SSIS
Last August, I had a blast at the Data Platform Summit 2018 in Bengaluru, India. One highlight of the trip was meeting and conversing with the Azure Data Factory SSIS Integration Runtime Product/Program Manager, Sandy Winarko. Sandy and I swapped coder stories and talked about data integration design patterns and I learned a few new …
Continue reading Start Azure-SSIS, Execute Package, Stop Azure-SSIS
Mean Time to Identify Failure
While managing a team of 40 ETL developers, I wanted to track lots of metrics. Some of the things I wanted to track were technical, like SSIS package execution times. Some metrics were people-centric. Andy’s First Rule of Statistics states: You can use statistics for anything about people, except people. Andy – circa 2005 It was …
Continue reading Mean Time to Identify Failure
Updates to the ADF Execute SSIS Package Activity
Last night I presented Moving Data with Azure Data Factory to a packed house at the Richmond Azure User Group. The crowd was engaged and asked awesome questions. I had a blast! Surprise! I rehearsed many of my demos before the presentation and even updated my slides. One thing I did not do was rehearse configuring an …
Continue reading Updates to the ADF Execute SSIS Package Activity
New Trusted Site Required when Connecting to Azure SQL DB
I got pinged about a new trusted site requirement when I tried to connect to Azure SQL DB this morning. https://aadcdn.msftauth.net is the URL. I added the URL to Internet Explorer’s Trusted Sites: I was then able to connect to Azure SQL DB and add a rule for my IP using SQL Server Management Studio (SSMS).
SSIS Catalog Compare Version 4 – Three Videos
I am excited to announce general availability of SSIS Catalog Compare version 4! I made three short-ish (~2 minutes each) videos demonstrating some of the capabilities of the product. I really like the SCCPAC files and SCCPAC Deployment Wizard, which are only available in the Enterprise Edition. Use SCCPAC Deployment Wizard to Lift and Shift …
Continue reading SSIS Catalog Compare Version 4 – Three Videos
T-SQL Tuesday #111 – What is Your “Why?”
“Why do you do what you do?” This month’s T-SQL Tuesday topic by Andy Leonard.
Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!
I am honored to announce I will be delivering Intelligent Data Integration through SSIS – a day-long SQL Saturday 841 – Dallas pre-conference session 31 May 2019! Description: What is Intelligent Data Integration? SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data …
Continue reading Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!