Archive

RSSCode Development (24)

Date Title Comments Rating
2011-03-17 When does a Tumbling Window Start in StreamInsight 2 None
2011-02-09 Mouse Clicks, Reactive Extensions and StreamInsight Mashup 0 None
2011-02-06 StreamInsight and Reactive Framework Challenge 0 None
2010-12-05 Hopping/Tumbling Windows Could Introduce Latency. 0 None
2010-11-27 Linqpad and Autocompletion 1 None
2010-11-25 Linqpad and StreamInsight 0 None
2010-08-23 SQL Profiler Through StreamInsight Sample Solution 0 None
2010-06-11 Creating packages in code - Workflow 0 None
2009-07-17 Exploring packages in code 0 3.5
2009-05-19 Creating packages in code – Execute SQL Task 0 4
2009-05-12 Searching for tasks with code – Executables and Event Handlers 0 4
2009-05-07 Maintaining packages with code - Adding a property expression programmatically 0 3.8
2009-03-02 Creating packages in code - Package Configurations 2 3.8
2009-02-23 Creating packages in code - Flat File Source to OLE-DB Destination (SQL Server) 8 3.9
2009-02-02 CreationName for SSIS 2008 and adding components programmatically 0 3.8
2009-01-29 Creating packages in code - OLE-DB Source to Flat File File Destination 8 3
2009-01-29 Creating packages in code - OLE-DB Source to Raw File Destination 0 4
2009-01-29 CreationName for SSIS 2005 and adding components programmatically 1 2.5
2008-11-03 Backup or transfer SSIS Packages 2 4.4
2008-10-28 Expression Date Functions 4 4.4
2008-03-06 Extending SSIS with custom Data Flow components (Presentation) 0 2.8
2007-10-13 Extending SSIS with Custom Tasks (Presentation) 0 2.5
2004-11-22 When to use ProcessInput or PrimeOutput in your Component 0 None
2004-11-08 How to add an icon to your component 0 None

RSSComponent Downloads (9)

Date Title Comments Rating
2009-05-01 Trace File Source Adapter 5 5
2008-10-29 Checksum Transformation 49 3.3
2008-10-20 File Watcher Task 79 3.1
2008-10-15 Row Count Plus Transformation 13 None
2008-10-15 Row Number Transformation 23 3.8
2008-10-11 Regular Expression Transformation 10 4.4
2008-10-11 RegexClean Transformation 24 4.7
2008-10-11 Data Generator Source Adapter 0 5
2008-05-09 Trash Destination Adapter 10 4.8

RSSConferences (10)

Date Title Comments Rating
2011-06-21 SQLBits 9 goes to Liverpool 0 None
2009-08-21 Swiss SQL Server Saturday, Zurich, September 19th 0 None
2009-08-11 Donald Farmer comes to SQLBits 0 None
2009-02-18 SSIS Performance Tuning Seminar (1 day) 0 4.3
2009-02-09 SQLBits IV Conference 0 4
2009-02-08 Techfest 2009 Conference Poland 0 1
2009-02-08 C2C Conference In Poland 0 None
2009-02-08 PASS European Conference 0 5
2009-01-27 SQLBits IV session voting open 0 None
2008-12-27 SQLBits IV Session Submission now open. 0 3.5

RSSConfiguration (5)

Date Title Comments Rating
2009-12-08 Script Task/Component and Template Information 0 5
2008-10-28 Building a Successful ETL Project 0 4.4
2008-10-28 Create MSDB Folders Through Code 0 2
2004-12-06 Using Parent Package Variables in Package Configurations 1 2.2
2004-11-30 Easy Package Configuration 11 5

RSSData Flow (18)

Date Title Comments Rating
2010-11-12 Using the Script Component as a Conditional Split 2 None
2010-05-29 Sorting data in the SSIS Pipeline (Video) 3 None
2010-05-14 Optimising Lookups with the Cache Transform (Video) 2 4.7
2010-05-14 The Pipeline Limiter in SQL Server Integration Services (Video) 0 4.7
2009-05-01 Trace File Source Adapter 5 5
2009-02-18 Attunity Oracle CDC Solution for SSIS - Beta 0 4.5
2008-10-31 SSAS Cache Warming Using SSIS 15 4.6
2008-10-28 Expressions 0 5
2008-10-28 Expression Date Functions 4 4.4
2008-03-06 Extending SSIS with custom Data Flow components (Presentation) 0 2.8
2007-09-19 Multicast Transform and Threading in SQL Server 2008 0 4.5
2007-09-10 Pipeline Memory Limiter 0 None
2005-05-26 Handling different row types in the same file 6 5
2005-05-06 Log Events and Pipeline Events 0 None
2005-05-05 Parallel Execution Properties 0 None
2005-04-04 Generating Surrogate Keys 2 4
2004-09-01 Get all from Table A that isn't in Table B 19 5
2004-08-02 The Script Component as a Transformation 7 4.1

RSSData Mining (7)

Date Title Comments Rating
2010-05-27 Explaining the State Transitions Viewer in Sequence Clustering 0 None
2010-05-27 MSDN Article for the GetClusterCharacteristics Stored Procedure 0 None
2009-08-11 Manchester UG Presentation Video 0 5
2009-06-09 Integrating Data Mining into your BI Solution (Presentation) 0 5
2009-05-18 July SQL Server UG Event in Manchester 0 5
2009-01-22 Data Mining Time Series presentation 0 None
2008-11-01 More Value From Data Using Data Mining Presentation 0 4.7

RSSDenali (2)

Date Title Comments Rating
2010-11-13 My Favourite Two Buttons in Denali CTP1 SSIS 2 None
2010-11-11 Import SSIS Project in Denali CTP1 0 None

RSSDestinations (2)

Date Title Comments Rating
2008-05-09 Trash Destination Adapter 10 4.8
2008-03-06 Extending SSIS with custom Data Flow components (Presentation) 0 2.8

RSSExecution (8)

Date Title Comments Rating
2011-02-09 Mouse Clicks, Reactive Extensions and StreamInsight Mashup 0 None
2011-02-06 StreamInsight and Reactive Framework Challenge 0 None
2010-08-29 Issuing Current Time Increments in StreamInsight (A Practical Example) 0 None
2009-09-12 Change Data Capture Webinar 0 3
2009-08-03 Where is my app.config for SSIS? 9 4.7
2008-10-28 Create MSDB Folders Through Code 0 2
2008-10-28 Logical OR in Control Flow to Skip Task 1 3.3
2005-10-07 Comparing Overhead on the Execution Methods 0 None

RSSGeneral (14)

Date Title Comments Rating
2010-08-10 A deadlock was detected while trying to lock variables in SSIS 3 None
2010-05-27 Explaining the State Transitions Viewer in Sequence Clustering 0 None
2010-05-27 MSDN Article for the GetClusterCharacteristics Stored Procedure 0 None
2010-05-12 Data Profiling without SSIS 2 5
2009-09-12 Change Data Capture Webinar 0 3
2009-01-07 Sorting MSDB package folders 6 4.3
2008-11-01 Tips and Tricks in SSIS Presentation 0 3.6
2008-10-28 Building a Successful ETL Project 0 4.4
2008-10-28 Create MSDB Folders Through Code 0 2
2008-10-28 Redistribute SSIS 0 4.5
2008-09-24 SQL Server Editions and Integration Services 2 4.5
2007-08-27 Where To Find Integration Services Packages in SQL Server 1 3.7
2005-06-09 SSIS and SQL Server Instances 0 4.3
2005-05-09 What is Validation? 1 2

RSSLinqpad (2)

Date Title Comments Rating
2010-11-27 Linqpad and Autocompletion 1 None
2010-11-25 Linqpad and StreamInsight 0 None

RSSNews (5)

Date Title Comments Rating
2011-07-11 Red Gate join the SSIS custom component club 0 None
2010-08-12 SQL Bits 7 - 30th September - 2nd October 2010 in York 0 None
2010-04-21 Hosting woes 0 5
2009-02-18 Attunity Oracle CDC Solution for SSIS - Beta 0 4.5
2008-10-23 Welcome to the new SQLIS site 0 4.5

RSSPresentations (39)

Date Title Comments Rating
2011-05-11 Attunity Webcast on Real Time Optimisation For Microsoft BI 0 None
2011-01-23 StreamInsight Precon at SQLBits 8 in Brighton 0 None
2010-10-20 SSIS Field Notes – SQLBits 7 Presentation 1 None
2010-08-23 SQL Profiler Through StreamInsight Sample Solution 0 None
2010-08-04 Streaming Profiler Data Through StreamInsight 0 None
2010-07-18 Performing a Left Anti Semi Join in StreamInsight 0 None
2010-07-01 Talking about StreamInsight in a pub in Maidstone, Kent 0 None
2010-07-01 Talking StreamInsight At Usergroup in London 0 None
2010-04-21 Design Patterns for SSIS Performance (Presentation) 0 5
2010-01-05 User Group Meeting in Dundee (Scotland) 0 5
2009-09-12 Change Data Capture Webinar 0 3
2009-08-21 Swiss SQL Server Saturday, Zurich, September 19th 0 None
2009-08-11 Manchester UG Presentation Video 0 5
2009-08-11 Donald Farmer comes to SQLBits 0 None
2009-06-09 Integrating Data Mining into your BI Solution (Presentation) 0 5
2009-05-21 SSIS Tips & Tricks (Presentation) 0 3.6
2009-05-18 July SQL Server UG Event in Manchester 0 5
2009-05-13 UK SQL Server User Group Events (June) 0 4
2009-05-13 UK SQL Server User Group Event (May) 0 5
2009-02-18 SSIS Performance Tuning Seminar (1 day) 0 4.3
2009-02-09 SQLBits IV Conference 0 4
2009-02-08 Techfest 2009 Conference Poland 0 1
2009-02-08 C2C Conference In Poland 0 None
2009-02-08 PASS European Conference 0 5
2009-01-27 SQLBits IV session voting open 0 None
2009-01-22 Data Mining Time Series presentation 0 None
2009-01-06 UK BI User group Meeting Next Week 0 None
2008-12-27 SQLBits IV Session Submission now open. 0 3.5
2008-11-12 SQLBits 3 – The Movies 0 5
2008-11-01 Tips and Tricks in SSIS Presentation 0 3.6
2008-11-01 More Value From Data Using Data Mining Presentation 0 4.7
2008-09-25 More value from your data through data mining (Presentation) 0 None
2008-09-25 SSIS Tips, Tricks and things I do (Presentation) 1 None
2008-03-13 Making more of SSIS in 2008 (Presentation) 0 4.5
2008-03-06 Extending SSIS with custom Data Flow components (Presentation) 0 2.8
2007-10-15 Preview of SSIS in SQL Server 2008 (Presentation) 0 1
2007-10-15 Advanced Topics in SQL Server 2005 SSIS (Presentation) 2 None
2007-10-13 Extending SSIS with Custom Tasks (Presentation) 0 2.5
2005-05-19 SQL Server Integration Services - Thinking Outside of the DTS Box (Presentation) 0 None

RSSScripting (9)

Date Title Comments Rating
2010-11-12 Using the Script Component as a Conditional Split 2 None
2009-12-08 Script Task/Component and Template Information 0 5
2009-07-02 Downloading a file over HTTP the SSIS way 24 5
2009-06-10 Logging connection strings 1 3
2008-10-30 Escaping In Expressions 0 3.8
2008-10-28 Expressions 0 5
2007-08-23 Script Task Breakpoints in SQL Server 2008 1 3
2005-04-04 Generating Surrogate Keys 2 4
2004-08-02 The Script Component as a Transformation 7 4.1

RSSSources (6)

Date Title Comments Rating
2011-01-18 SSIS and StreamInsight Working Together. 0 None
2010-05-29 Sorting data in the SSIS Pipeline (Video) 3 None
2009-05-01 Trace File Source Adapter 5 5
2008-10-31 SSAS Cache Warming Using SSIS 15 4.6
2008-10-11 Data Generator Source Adapter 0 5
2008-03-06 Extending SSIS with custom Data Flow components (Presentation) 0 2.8

RSSSpatial (1)

Date Title Comments Rating
2011-03-31 Spatial Portrait 0 None

RSSStreamInsight (17)

Date Title Comments Rating
2011-03-17 When does a Tumbling Window Start in StreamInsight 2 None
2011-02-09 Mouse Clicks, Reactive Extensions and StreamInsight Mashup 0 None
2011-02-06 StreamInsight and Reactive Framework Challenge 0 None
2011-01-23 StreamInsight Precon at SQLBits 8 in Brighton 0 None
2011-01-18 SSIS and StreamInsight Working Together. 0 None
2010-12-29 Showing Edge Shaped Event Duration in StreamInsight using Debugger 0 None
2010-12-05 Hopping/Tumbling Windows Could Introduce Latency. 0 None
2010-11-25 Linqpad and StreamInsight 0 None
2010-08-29 Issuing Current Time Increments in StreamInsight (A Practical Example) 0 None
2010-08-23 SQL Profiler Through StreamInsight Sample Solution 0 None
2010-08-15 Additional Columns in StreamInsight Event Flow Debugger 0 None
2010-08-04 Streaming Profiler Data Through StreamInsight 0 None
2010-08-02 AdvanceTimePolicy and Point Event Streams In StreamInsight. 0 None
2010-07-18 Performing a Left Anti Semi Join in StreamInsight 0 None
2010-07-01 Talking about StreamInsight in a pub in Maidstone, Kent 0 None
2010-07-01 Talking StreamInsight At Usergroup in London 0 None
2010-05-28 StreamInsight Licensing 0 None

RSSTasks (8)

Date Title Comments Rating
2010-05-04 Have you used the ExecutionValue and ExecValueVariable properties? 1 5
2009-12-08 Script Task/Component and Template Information 0 5
2008-10-28 Logical OR in Control Flow to Skip Task 1 3.3
2008-10-28 Disabling tasks through Expressions 2 4.5
2008-10-28 Expression Date Functions 4 4.4
2008-10-20 File Watcher Task 79 3.1
2007-10-13 Extending SSIS with Custom Tasks (Presentation) 0 2.5
2005-10-09 The Execute SQL Task 72 4.7

RSSTools (5)

Date Title Comments Rating
2010-11-25 Linqpad and StreamInsight 0 None
2010-06-09 SSIS Expression Editor & Tester 3 None
2009-07-10 New SSIS tool on Codeplex – SSIS Log Analyzer 0 4.5
2009-02-18 Attunity Oracle CDC Solution for SSIS - Beta 0 4.5
2008-11-03 Backup or transfer SSIS Packages 2 4.4

RSSTraining (5)

Date Title Comments Rating
2011-01-23 StreamInsight Precon at SQLBits 8 in Brighton 0 None
2009-02-18 SSIS Performance Tuning Seminar (1 day) 0 4.3
2008-12-27 SQLBits IV Session Submission now open. 0 3.5
2008-10-14 SSIS Performance Training Seminar 1 5
2008-10-14 Integration Services Deep Dive Training Course 4 5

RSSTransformations (16)

Date Title Comments Rating
2011-07-11 Red Gate join the SSIS custom component club 0 None
2011-01-18 SSIS and StreamInsight Working Together. 0 None
2010-05-29 Sorting data in the SSIS Pipeline (Video) 3 None
2009-12-08 Script Task/Component and Template Information 0 5
2009-02-18 Attunity Oracle CDC Solution for SSIS - Beta 0 4.5
2008-10-31 SSAS Cache Warming Using SSIS 15 4.6
2008-10-29 Checksum Transformation 49 3.3
2008-10-28 Expressions 0 5
2008-10-28 Expression Date Functions 4 4.4
2008-10-15 Row Count Plus Transformation 13 None
2008-10-15 Row Number Transformation 23 3.8
2008-10-11 Regular Expression Transformation 10 4.4
2008-10-11 RegexClean Transformation 24 4.7
2008-03-06 Extending SSIS with custom Data Flow components (Presentation) 0 2.8
2007-09-19 Multicast Transform and Threading in SQL Server 2008 0 4.5
2004-08-02 OLE-DB Command Transformation 10 5

RSSUser Group (11)

Date Title Comments Rating
2010-07-01 Talking about StreamInsight in a pub in Maidstone, Kent 0 None
2010-07-01 Talking StreamInsight At Usergroup in London 0 None
2010-01-05 User Group Meeting in Dundee (Scotland) 0 5
2009-08-11 Manchester UG Presentation Video 0 5
2009-06-09 Integrating Data Mining into your BI Solution (Presentation) 0 5
2009-05-21 SSIS Tips & Tricks (Presentation) 0 3.6
2009-05-18 July SQL Server UG Event in Manchester 0 5
2009-05-13 UK SQL Server User Group Events (June) 0 4
2009-05-13 UK SQL Server User Group Event (May) 0 5
2009-02-18 SSIS Performance Tuning Seminar (1 day) 0 4.3
2009-01-06 UK BI User group Meeting Next Week 0 None

RSSVideos (5)

Date Title Comments Rating
2010-08-04 Streaming Profiler Data Through StreamInsight 0 None
2010-07-18 Performing a Left Anti Semi Join in StreamInsight 0 None
2010-05-29 Sorting data in the SSIS Pipeline (Video) 3 None
2010-05-14 Optimising Lookups with the Cache Transform (Video) 2 4.7
2010-05-14 The Pipeline Limiter in SQL Server Integration Services (Video) 0 4.7

RSSWhitepapers (2)

Date Title Comments Rating
2008-09-25 Immediacy Demands a Change of Focus 0 5
2008-09-25 Real Time Data Integration 0 5

RSSWorkflow (10)

Date Title Comments Rating
2011-01-18 SSIS and StreamInsight Working Together. 0 None
2008-10-28 Logical OR in Control Flow to Skip Task 1 3.3
2008-10-28 Disabling tasks through Expressions 2 4.5
2005-10-03 Meaning of the On Success Workflow Constraint 4 1
2005-06-15 Shredding a Recordset 31 4.8
2005-05-31 Looping over files with the Foreach Loop 58 4.8
2005-05-05 Parallel Execution Properties 0 None
2004-08-10 For Loop Container Samples 16 4.3
2004-08-02 Workflow Constraints - Logical OR 0 5
2004-08-02 Introduction to Expressions on Workflow 1 4.2

Uncategorized (2)

Date Title Comments Rating
2010-06-28 Follow me on Twitter 0 None
2000-01-01 Styles post test html posts with code 0 None

Total

138 posts
569 comments
433 raters
Welcome to SQLIS.com our free SQL Server Integration Services (SSIS) resource site.

MVP

RecentComments

Comment RSS