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 2008 » ssis   (RSS)
  • SQL Server Configuration timeouts - and a workaround [SSIS]

    Ever since I started writing SSIS packages back in 2004 I have opted to store configurations in .dtsConfig (.i.e. XML) files rather than in a SQL Server table (aka SQL Server Configurations) however recently I inherited some packages that used SQL Server Configurations and thus had to immerse myself in their murky little world. To all the people ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 30, 2011
  • Speaking at Philly Code Camp 2008.2 Saturday

    I will be presenting Change Data Capture, Incremental ETL, and SSIS 2008 to Philadelphia Code Camp 2008.2 Saturday, 17 May 2008! The good folks in Philadelphia always do a great job with Code Camps and the attendance numbers are growing to reflect that! They're sold out again. Great job! :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on May 14, 2008
  • When All Else Fails, SSIS Scripting to the Rescue

    Background  I'm working on an SSIS package that FTPs files from heterogeneous sources to Windows servers. I currently have three types of servers in the mix: Windows, Unix, and iSeries. When I first started this phase of the project, I tested the SSIS FTP Task and it worked well... on two out of three.  Durnit. Hope Floats (or at ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 28, 2008
  • SSIS 2008 Data Profiling Task

    Jamie Thomson has posted a great series on the SSIS 2008 Data Profiling Task. The Data Profiling Task allows developers to quickly assess key statistics about data in a database table. When I say ''statistics'' I mean things like column value and length distribution, column null ratio, column patterns, and functional dependencies. You ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 12, 2008
Privacy Statement