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 » connect » SQL Server   (RSS)
  • Have SSIS' differing type systems ever caused you problems?

    One thing that has always infuriated me about SSIS is the fact that every package has three different type systems; to give you an idea of what I am talking about consider the following: The SSIS dataflow's type system is made up of types called DT_*  (e.g. DT_STR, DT_I4) The SSIS variable type system is based on .Net datatypes (e.g. ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 14, 2011
  • 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
  • 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
  • RSS feed for SQL Server Connect feedback

    Have you heard of Microsoft Connect? It is a Microsoft website dedicated to soliciting feedback about bugs and feature suggestions for their products and SQL Server has a dedicated space on that website at That much you probably knew. What you might not know is that the site provides an RSS feed ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 19, 2010
  • Extended Properties in Object Explorer Details – Vote on Connect

    After a discussion with a friend of mine, I’ve opened a suggestion on Connect to request to have Extended Properties visible in the main Object Explorer Details window. This will be especially useful for creating self-documenting database, since that window can easily provide additional information about, for example, column in a table or in a ...
    Posted to Davide Mauri (Weblog) by manowar on September 15, 2009
  • And sometime Connect works... slowly...

    Almost two years ago I wrote a post about the abuse of the ''it's by design'' answer Microsoft gives to many bugs. You know, I think that a bug in design produces the same results (if not worst) than a bug in implementation. I also had a long discussion about the reason why that specific issue should have considered a bug or not. But that's ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 16, 2009
Privacy Statement