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 5 of 7 (61 total posts)
  • 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
  • The SQL developer gap (Warning: rant coming up)

    I recently submitted a bug to Microsoft Connect concerning the behaviour of the expression language in SSRS, if you’re interested you can read about it here: DateAdd() doesn't throw an error when it has invalid parameters. I got a swift and detailed reply (for which I am grateful) from a fellow on the SSRS team however the content of it wasn’t ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 12, 2010
  • Article: Scripting in SSIS - Part 1

    My latest article - Scripting in SSIS-Part 1 - is available today at SQLServerCentral.com! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on December 29, 2009
  • Twitter Search Term Extraction

    During my presentation A whistlestop tour of SSIS addins yesterday at SQLBits I demonstrated how Jessica Moss & Andy Leonard’s Twitter Task could be used in conjunction with SSIS’s Term Extraction component to discover what people might be saying in their replies to a Twitter user. The Term Extraction component is a little-known and ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 22, 2009
Privacy Statement