To delete a Catalog folder using SSIS Catalog Compare, right-click the folder and click Delete Folder: You are prompted to confirm folder deletion: If the folder contains additional Catalog artifacts, the user is prompted again to confirm the deletion of the folder and all contents: Let’s take a short break right here and consider some …
Continue reading Delete SSIS Catalog Folders With SSIS Catalog Compare
Category:SSIS
Anatomy of a Catalog Reference Script in SSIS Catalog Compare
A Catalog Reference script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Header Documentation The script begins with a header documentation similar to that shown here: When executed, the Project Reference script header documentation portion displays in the Messages output window of SQL Server management Studio (SSMS): The statements …
Continue reading Anatomy of a Catalog Reference Script in SSIS Catalog Compare
Anatomy of an Environment Script in SSIS Catalog Compare
An SSIS Catalog Environment script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Declarations and Header Documentation The script begins with a declaration of Transact-SQL parameters that support SSIS Catalog Environment Variables contained within an SSIS Catalog Environment. These parameters are placed at the top of the script for …
Continue reading Anatomy of an Environment Script in SSIS Catalog Compare
Anatomy of an SSIS Catalog Connection Literals Script in SSIS Catalog Compare
An SSIS Catalog Connection Literals script is automatically generated using several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Declarations and Header Documentation The script begins with a declaration of Transact-SQL parameters that will be used to provide literal overrides. These parameters are placed at the top of the script for easy access by …
Continue reading Anatomy of an SSIS Catalog Connection Literals Script in SSIS Catalog Compare
Honored to Present Faster SSIS at SQL Saturday Boston 22 Sep 2018!
I am honored to present Faster SSIS at SQL Saturday Boston 22 Sep 2018! Check out this schedule – there are a bunch of smart people presenting – plus me! Abstract Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows …
Continue reading Honored to Present Faster SSIS at SQL Saturday Boston 22 Sep 2018!
PASS Summit 2018 Starts in 10 Weeks!
Can you believe the PASS Summit 2018 begins only 10 weeks from today (27 Aug 2018)? I confess, this is sneaking up on me fast! I will be there. Will you? Where Can You Find Andy at the PASS Summit 2018? Precon! Monday 5 Nov 2018, I’m delivering a full-day pre-conference session titled Intelligent Data …
Continue reading PASS Summit 2018 Starts in 10 Weeks!
I am a Product Manager (No, I’m Not… But I Can Explain)
I was about to click the Publish button for this post about my new role as a product manager when my friend and brother, Scott, called. I mentioned it and Scott said, “You’re not just a product manager. You’re a problem-solver.” Scott is correct. Hence the parentheses in the title of this post. “Is This The …
Continue reading I am a Product Manager (No, I’m Not… But I Can Explain)
Announcing SSIS Catalog Compare Version 3!
I’m so happy to announce the release of SSIS Catalog Compare version 3! SCCv3 Speaks Cloud In May, Microsoft announced the general availability of Azure Data Factory SSIS Integration Runtime. Customers immediately began deploying SSIS from on-premises servers to the cloud. Some quickly recognized some gaps in the process, such as: On-premises, enterprises have the …
Continue reading Announcing SSIS Catalog Compare Version 3!
A Tale of Two Properties: SSIS ProjectVersion and TargetServerVersion
I’m typing this at 4:30 AM IST in my hotel room in Bengaluru, India. It’s not unusual that I am awake at 4:30 AM. It is unusual that I’ve been awake since around 1:15 AM. I am attending and presenting at the Data Platform Summit 2018 and, obviously, still adjusting to the time zone. It is …
Continue reading A Tale of Two Properties: SSIS ProjectVersion and TargetServerVersion
Use Biml to Build a Local Copy of an Azure SQL DB – a Free Webinar
Join me 30 Aug 2018 at noon EDT for another free webinar titled Use Biml to Build a Local Copy of an Azure SQL DB. This webinar is inspired by a social media post by a friend. His company is using Azure SQL DB in Production. They want to make a copy of the Production …
Continue reading Use Biml to Build a Local Copy of an Azure SQL DB – a Free Webinar