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 » sql server » sql server integration services   (RSS)
Showing page 3 of 4 (36 total posts)
  • Introducing SSIS Reporting Pack for SQL Server code-named Denali

    In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali: What's new in SSIS in Denali Introduction to SSIS Projects in Denali Parameters in SSIS In Denali SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali The SSIS Catalog is responsible for ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 8, 2010
  • SSIS Server, Catalogs, Environments & Environment Variables in SSIS in Denali

    In the last few days I have written 3 blog posts covering some new features in SQL Server Integration Services (SSIS) in the next version of SQL Server, code-named Denali: Introduction to SSIS Project in Denali Parameters in SSIS in Denali The new Execute Package Task in Denali In this blog post I’m moving onto talking about the new ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 13, 2010
  • The new Execute Package Task in SSIS in Denali

    In my blog post of 10th November Introduction to SSIS projects in Denali I spoke of how, in Denali, SSIS packages can collectively be distributed as a single unit called a Project. I want to start digging into the advantages that Projects bring and the first such example is the new Execute Package Task. If we compare the old and new then the ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 12, 2010
  • Parameters in SSIS in Denali

    In my last blog post Introduction to SSIS Projects in Denali I talked about the new Project deployment model that is coming in the next version of SQL Server Integration Services (SSIS); working hand-in-hand with Projects is another new feature – Parameters. Parameters are similar to Variables in SSIS today that we all know and (ahem) love but ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 11, 2010
  • Introduction to SSIS Projects in Denali

    The next version of SQL Server has been unveiled and it has a codename of Denali (aka SQL11, not aka SQL2011). SQL Server Integration Services (SSIS) is receiving quite an overhaul in Denali and over the next few days I’m going to outline some of the changes. Today? Projects! In SSIS today (i.e. prior to Denali) we build these things called SSIS ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 10, 2010
  • Some thoughts on Visual Studio database references and how they should be used for SQL Server BI

    Over the past few weeks I have been making heavy use of the Database tools in Visual Studio 2010 (formerly known as datadude, DBPro, VSTS for Database Professionals or one of a plethora of other names that it has gone by over the past few years) and one of the features that has most impressed me has been database references.   Database ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 14, 2010
  • Newly closed Connect items auger well for SSIS in Denali

    Todd Mcdermid spoke recently on his blog post Integration Services vNext Coming Soon about how some recently closed Connect items had encouraged him as to the future of SSIS. Also, Matt Masson from the SSIS team has written a similarly encouraging blog post about some upcoming SSIS enhancements at Upcoming Product Changes. Now its my turn. Just ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 10, 2010
  • Don’t turn the dataflow into a cursor [SSIS]

    I saw a thread on the SSIS forum today that went something like this: I have the following dataset: AccountNo Date DailyMovement 00000001 28/08/2010 10 00000001 29/08/2010 5 00000001 ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 31, 2010
  • Be wary of using UNC paths in SSIS packages

    I have recently discovered what I believe to be a bug in SQL Server Integration Services (SSIS) 2008 and am taking the opportunity herein to warn about it so that nobody else gets stung by it. The bug concerns the use of Uniform Naming Convention (UNC) paths inside a .dtsx package (i.e. paths that start with a “\\”). I have managed to reproduce a ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 19, 2010
  • SSIS Lookup component tuning tips

    Yesterday evening I attended a London meeting of the UK SQL Server User Group at Microsoft’s offices in London Victoria. As usual it was both a fun and informative evening and in particular there seemed to be a few questions arising about tuning the SSIS Lookup component; I rattled off some comments and figured it would be prudent to drop some of ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 18, 2010
Privacy Statement