THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SSIS   (RSS)
Showing page 2 of 46 (455 total posts)
  • Stop an SSIS Package

    There are several ways to stop and executing SSIS package. If the package is executing in the SSIS Catalog, you can use the SSISDB.[catalog].stop_operation stored procedure. Stop_operation has one parameter – a bigint named @operation_id. You can execute the stored procedure thus: exec SSISDB.[catalog].stop_operation @operation_id = ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 25, 2016
  • Use Biml to Remove Spaces from Flat File Column Names

    I hate a space in a database column name. Kent Bradshaw and I are updating our demo for loading National Provider Index (NPI) file data (We plan to present on this soon… more later…). The NPI files currently have 329 fields and almost every one of them contains spaces: I had 5 minutes, so I decided to fix it with Biml. I first created an SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 6, 2016
  • Migrating SSIS Projects and Parameters, Part 1 is Live at SQL Server Central!

    Have you ever moved an SSIS project from one SSIS Catalog to another? With Catalog Environments and References? If you haven’t, you may be in for a surprise when you try. First, why should you try? “SSIS is software development.” – Andy, circa 2008 Best practices for software development apply to SSIS. One of those practices is: Never ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 21, 2016
  • I’m Presenting Biml and SSIS Execution Frameworks at RichmondSQL 9 Jun!

    I am honored to present Biml and SSIS Execution Frameworks 9 Jun 2016 at the Richmond SQL Server Users Group! The meeting starts at 6:30 PM EDT and will be held at 4600 Cox Rd in Glen Allen, VA. Biml and SSIS Execution Frameworks You’ve probably heard that it’s a data integration best practice to build small, unit-of-work SSIS packages. ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 26, 2016
  • I’m Presenting Biml and SSIS Execution Frameworks at CharlotteSQL 8 Jun 2016!

    I am honored to present Biml and SSIS Execution Frameworks 8 Jun 2016 at the Charlotte SQL Server User Group! To learn more about meetings at the Charlotte SSUG sign up for their newsletter or follow them on Facebook, Twitter, and LinkedIn. Biml and SSIS Execution Frameworks You’ve probably heard that it’s a data integration best practice to ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 25, 2016
  • IESSIS1 2-6 May 2016 in Chicago!

    Want to learn more about SSIS (from me!)? IESSIS1: Immersion Event on Learning SQL Server Integration Services is 2-6 May in Chicago! It’s not too late to register. This 1-300-level, 5-day, SQL Server Integration Services (SSIS) training class was created to train technology professionals in the fine art of using SSIS to build data ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 19, 2016
  • Announcing Biml Academy!

    Announcing Enterprise Data & Analytics Biml Academy – 5 Days of Free Training – 9-13 May! Welcome to Biml Academy! Join me for a five-day online event and learn Biml now! [Recording] Biml Academy – Lesson 0 – SSIS Design Patterns – Before we dive into code generation, let’s discuss and demonstrate some SSIS Design Patterns. ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 30, 2016
  • The Recording for DILM with SSIS Catalog Compare is now Available

    The recording for the (free!) Enterprise Data & Analytics webinar “DILM with Catalog Compare” is now available. Registration is required. Enjoy! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on March 30, 2016
  • Easy SSIS Migration with SSIS Catalog Compare Recording is Available!

    The recording for the webinar titled Easy SSIS Migration with SSIS Catalog Compare is now available! Enjoy! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on February 15, 2016
  • Microsoft is Listening

    There’s a back-story to my post titled SSIS 2016 CTP 3 and Data Flow Column LineageID. I’ll get to the story in a minute, but first I’d like to say that every company has excellent customer service. You don’t believe me? Ask them, “Company, do you have excellent customer service?” They will all answer, “Yes. Yes we do.” Microsoft has been ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 8, 2016
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement