THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 2 of 134 (1,333 total posts) < 1 second(s)
  • The Recording for Advanced SSIS Execution is Available

    The recording for the Enterprise Data &amp; Analytics webinar titled Advanced SSIS Execution is now available (registration required). Enjoy! :{&gt; Learn More: SSIS Catalog Compare v2.0 Launch Event 7 Mar 2017! SSIS Catalog Management SSIS Lifecycle Management Related Training: IESSIS1: Immersion Event on Learning SQL Server ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 24, 2017
  • SSIS Catalog Compare v2.0 Launch Event 7 Mar 2017!

    The Data Integration Lifecycle Management Suite (DILM Suite) helps SSIS Developers and Database Administrators manage SQL Server Integration Services (SSIS) deployments in the enterprise lifecycle. Join Kent Bradshaw and me at 1:00 PM EST 7 Mar 2017 for the SSIS Catalog Compare v2.0 Launch Event! In this free webinar we will demonstrate the ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 23, 2017
  • SQL Data Partners Podcast Episode 79: SSIS Catalog

    I was honored to be interviewed by Carlos Chacon (@CarlosLChacon | SQL Data Partners) and Steve Stedman (@SqlEmt | Blog) for the SQL Data Partners podcast. We had a great discussion about the SSIS Catalog. We talked about how the SSIS Catalog works, Data Integration Lifecycle Management (DILM), SSIS Catalog Browser, SSIS Catalog Compare, and the ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 22, 2017
  • An Example of Data Integration Lifecycle Management with SSIS, Part 3

    In this post I will demonstrate how to use SSIS Catalog Environments, References,&#160; and Reference Mappings to override SSIS parameter values at execution time. There three sources of SSIS parameter values: Design-time defaults these are the parameter values developers use when building the SSIS project and packages. SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 22, 2017
  • An Example of Data Integration Lifecycle Management with SSIS, Part 2

    In this post I will demonstrate how to use the SSIS Catalog to execute and monitor an SSIS project. Manual SSIS Package Execution in the SSIS Catalog To execute an SSIS Package manually using the SSIS Catalog, connect to the SQL Server instance that hosts the Catalog using SQL Server Management Studio (SSMS). Once connected, open Object Explorer ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 15, 2017
  • Introducing astreams

    For months, Ive received pings about a screenshot I posted on social media a year or so ago. Plus I needed to wind down. You real runners will know what I mean: You know how you feel after youve covered some distance (for you)? You need to walk around for a bit, you cant just stop cold. You need to wind down. I needed that after the effort ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 12, 2017
  • re: SSIS Catalog Compare

    Hi Mickey, &nbsp; Now that v2 is released, I'm working on videos. Since the videos are not done yet, might I suggest a demo for your boss? I can set up a short meeting - ping me at andy.leonard@dilmsuite.com. &nbsp; The current version of SSIS Catalog Compare (and CatCompare) compares only deployed projects and packages (and environments, ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 12, 2017
  • The Recording for SSIS Catalog Management is Available

    The recording for the Enterprise Data &amp; Analytics webinar titled SSIS Catalog Management is now available (registration is required). In the SSIS Academy: Using the SSIS Catalog series, Kent and I walked through the SSIS Catalog functionality built into SQL Server Management Studio (SSMS). This webinar picks up where SSIS Academy: Using the ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 11, 2017
  • re: SSIS Expression Language and the Derived Column Transformation

    Hi junaib, &nbsp; Assuming that's the order for which you want to test the conditions (check for &quot;passed&quot; first, then check for &quot;clear&quot;, and then check for &quot;ok&quot;), this may work: &nbsp;((SaleAmount &gt; 0) ? &quot;passed&quot; : ((Act_amt &gt; 0) ? &quot;clear&quot; : ((Clear_amt &gt; 0) ? &quot;ok&quot;))) Hope ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 11, 2017
  • re: Secure Connections Management in SSIS, Part 2

    Thank you for you kind words, Richard. :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on January 9, 2017
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement