THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 117 (1,162 total posts) < 1 second(s)
  • re: Managing SSIS Catalog Project Parameter Values

    Hi Stan, &nbsp; I've explored the SSISDB admin stored procedures available in the SSIS Catalog and the methods available in the SSIS .Net assemblies. As always, I am sure there are other ways to accomplish externalization, and each has benefits. Wolfgang Strasser ( presents regularly on the same topic, and he ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 25, 2015
  • re: Managing SSIS Catalog Project Parameter Values

    Hi Kinzleb, &nbsp; Excellent question! &nbsp; Visual Studio forces its paradigm on SSIS development. Most of the time, that works well - but not all of the time. Like you, I like Catalog Environments. But I see gaps in the lifecycle when using them. &nbsp; I've started addressing some (what I perceive as) the gaps with SSIS Catalog Compare ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 25, 2015
  • Presenting at BIG PASS 10 Dec 2015!

    I am honored to announce I will be presenting (remotely) I See a Control Flow Tab. Now What? at BIG PASS in Lake Forest, California 10 Dec 2015 at 6:30 PM PT! This demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up. Register today! :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on November 25, 2015
  • SSIS Catalog Compare 3-Minute Drill

    The actual time is about 3:15 In a new video, I demonstrate how to use SSIS Catalog Compare to deploy an SSIS Project and all configurations metadata from one SSIS Catalog to another. I call it the 3-Minute Drill. Enjoy! :{&gt; Learn more: Product&#160; Catalog Compare 0.5 Browsing the Catalog Catalog Compare 0.5 Comparing Catalogs ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 24, 2015
  • Announcing Three Free Biml and SSIS Webinars

    Thanks to everyone who attended the Biml 101 webinar! The recording and demo files for Biml 101 are available here. Ive scheduled three additional webinars in the series: 1:00 PM ET 16 Dec 2015 - Biml 102: Using Biml as an SSIS Design Patterns Engine 1:00 PM ET 6 Jan 2016 - Introduction to SSIS Frameworks 1:00 PM ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 23, 2015
  • re: Automate ETL Testing: Cross-Server Data Comparison with PowerShell

    This sounds awesome, Merrill! I can't wait to tinker with this code. :{&gt;
    Posted to Merrill Aldrich (Weblog) by andyleonard on November 22, 2015
  • PASS Summit 2015 Feedback

    We are part of an awesome community. The SQL Server Community or SQL Family, as many call it, is astounding. Our annual Big family reunion is the PASS Summit. I received feedback from attendee evaluations the other day and I would like to share some of the feedback for one reason: Many people spoke at the PASS Summit 2015 for the very first time ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 21, 2015
  • Do You Need to Update Your PASS Profile or SQL Saturday Speaker Profile?

    I recently needed to update my PASS and SQL Saturday speaker profiles. I emailed my good friend and Awesome Community Person Karla Landrum for help, and Karla kindly responded with detailed instructions that even I could follow. I decided to capture and share my experience updating my PASS and SQL Saturday profiles. Updating Your PASS ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 20, 2015
  • Learn to Code SSIS: The Execute SQL Task

    Note: This article was first published at SQL Authority. With SQL Server included in the name of SQL Server Integration Services (SSIS), it is easy for people to assume SSIS is simply a database tool or accessory. Let there be no mistake, SSIS is a software development platform. To give you a better understanding of how to use SSIS as a ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 20, 2015
  • Biml 101 Recording and Files Are Now Available!

    I had an awesome time sharing about Biml (Business Intelligence Markup Language) earlier today! Thank you to everyone who registered and turned out for the live presentation. For those unable to make it to the live presentation, the recording is now available for viewing. Ive posted the Mist and SSIS solutions source code. You can get them ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 18, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement