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 » SSIS   (RSS)
Showing page 4 of 5 (48 total posts)
  • 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
  • PASS Workshop “Creating a BI solution from A to Z” - Interview

    If you’re still unsure if the workshop I’ll deliver at PASS Summit the next November - “Creating a BI solution from A to Z” - is a good choice for you or not, you can get some more details reading the brief interview here: PASS Summit Post-Con Preview - Davide Mauri Where you’ll find answers to the following questions: Is there an audience ...
    Posted to Davide Mauri (Weblog) by manowar on September 16, 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
  • Default value for OLE DB Destination FastLoadMaxInsertCommitSize in SQL Server 2008 [SSIS]

    The FastLoadMaxInsertCommitSize property of the OLE DB Destination is used to determine how many rows should be committed as a single transaction when using the FastLoad option. In SQL Server Integration Services (SSIS) 2005 the default value for this property was zero which meant “regardless of the number of rows, commit all of them under a ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 6, 2010
  • CozyRoc demonstration videos

    Lately I have been working with software vendor CozyRoc to help them demonstrate their wares to the SSIS community. As part of that work I have produced a series of videos that demonstrate ten of the tasks and components that CozyRoc provide for to help you with your SSIS development. Here is a list of those videos along with links to them on ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 14, 2010
  • Visio stencils for SSIS

    My colleague Peter Avenant pointed out to me today that there are some Visio stencils available for SSIS. According to a blog post entitled Useful Visio stencil set for SQL Server 2005 by Josh Robinson they can be downloaded in a zip file and indeed, at the time of writing, they can. However, the supposed accompanying web page no longer exists ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 3, 2010
Privacy Statement