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 3 of 135 (1,341 total posts) < 1 second(s)
  • 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
  • An Example of Data Integration Lifecycle Management with SSIS, Part 1

    In this post I will provide some details about the demo SSIS project. I will then focus on version control and deployment. What DILM Is and Is Not Data Integration Lifecycle Management (DILM) is not about data integration development. DILM is about everything else: Configurations Management Version Management ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 8, 2017
  • Announcing SSIS Catalog Compare and CatCompare Version 2

    I am pleased to announce the release of SSIS Catalog Compare and CatCompare version 2. You can purchase a bundle that includes both products (and saves you some money) or can purchase each product separately: SSIS Catalog Compare and CatCompare. If youre interested in learning more about the functionality provided by the products you can ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 6, 2017
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement