THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SSIS   (RSS)
Showing page 3 of 16 (155 total posts)
  • Announcing the 2013 Biml Workshop 15 Oct 2013 in Charlotte NC!

    This blog has moved! You can find this content at the following new location:
    Posted to Andy Leonard (Weblog) by andyleonard on May 18, 2013
  • SSIS gotcha – Regional Settings can affect your expressions

    I recently stumbled across a nuance of the SSIS expression language which, when you think about, kinda make sense – but it does help to be aware of it. Its concerned with casting of datetime values using the SSIS expression language Take the following expression: (DT_WSTR,30) @[System::ContainerStartTime] That expression casts a datetime ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 9, 2013
  • SSIS 2012 Deep Dive presentation

    This is something I’ve been meaning to blog about for ages but it kept slipping my mind, sorry about that! Wee Hyong Tok from the SSIS product team has built a slide deck that covers some of the deep secrets about SSIS2012 including: Catalog deep dive Security Low level monitoring and troubleshooting The slide deck is available to ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 22, 2013
  • sp_ssiscatalog v1.0.3.0 available now [SSIS]

    I’ve just put out a new version of sp_ssiscatalog. The main change is requesting a list of executions using: exec sp_ssiscatalog @operation_type='execs' returns a new field called relative_duration: This length of the “bar” in that field represents the duration of that execution relative to all the other executions in ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 15, 2013
  • sp_ssiscatalog v1.0.2.0 now available for download [SSIS]

    v1.0.2.0 – what’s in it? Things have been a bit quiet on the sp_ssiscatalog front since I last blogged about it three months ago in December 2012. Rest-assured development continues apace however and today I’m making available a minor update, v1.0.2.0 which is now available for download from Codeplex. For those that don’t know I describe ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 11, 2013
  • Forcing “Custom Properties” of a Data Flow Transformation to support DTS Expression

    Today I was using a 3rd Party Data Flow component that has several Custom Properties for which I need to change some of their values at runtime using a DTS Expression. To mimic the situation let’s use the “Percentage Sampling” that has two Custom Properties: Of the two Custom Properties only some (one in this case) are available also outside ...
    Posted to Davide Mauri (Weblog) by manowar on January 30, 2013
  • Microsoft advocates checkpoints - proceed with caution [SSIS]

    In December 2012 Microsoft published a whitepaper entitled SSIS Operational and Tuning Guide which you can download by clicking here. I have skimmed through the whitepaper and it appears to be a compelling read however a couple of sentences caught my eye that I want to draw attention to here. These sentences refer to the use SSIS checkpoint ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 4, 2013
  • The current state of a MERGE Destination for SSIS

    Hugo Tap asked me on Twitter earlier today whether or not there existed a SSIS Dataflow Destination component that enabled one to MERGE data into a table rather than INSERT it. Its a common request so I thought it might be useful to summarise the current state of play as regards a MERGE destination for SSIS. Firstly, there is no MERGE destination ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 7, 2012
  • The perils of double-dash comments [T-SQL]

    I was checking my Twitter feed on my way in to work this morning and was alerted to an interesting blog post by Valentino Vranken that highlights a problem regarding the OLE DB Source in SSIS. In short, using double-dash comments in SQL statements within the OLE DB Source can cause unexpected results. It really is quite an important read if you’re ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 6, 2012
  • sp_ssiscatalog v1.0.1.0 now available for download

    13 days ago I wrote a blog post entitled Introducing sp_ssiscatalog (v1.0.0.0) in which I first made mention of sp_ssiscatalog, an open source stored procedure intended to make it easy to query the SSIS Catalog. I have been working on some enhancements since then and hence v1.0.1.0 is now available for download from Codeplex. What’s new in this ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 20, 2012
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement