Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Script Component Rss

Search for any content tagged script component

   Items 1 to 10 of 10   
 

Creating Inferred Dimension Members with SSIS

This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.  Read more...
By Robert Rubocki 2013/12/24 (first published: 2010/12/08) | Source: SQLServerCentral.com | Category: data warehouse
Rating: |  Discuss |   Briefcase | 8,629 reads

Creating Inferred Dimension Members with SSIS

This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.  Read more...
By Robert Rubocki 2013/12/24 (first published: 2010/12/08) | Source: SQLServerCentral.com | Category: data warehouse
Rating: |  Discuss |   Briefcase | 8,629 reads

Dynamically Map Column Data Based on Column Pattern Profiling

Tutorial on using Script Component, Regular Expression and derived Column Transform to dynamically map different source column types into the appropriate target column for address data.   Read more...
Rating: |  Discuss |   Briefcase | 2,371 reads

SSIS 2008 Script Component variable gotcha..

In a previous post I showed you how to access variables from within an SSIS script component.  More specifically I...  Read more...
By Josef Richberg 2010/02/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,580 reads

Sending SSIS Errors to the Windows Event Log

 In a previous post I explained how to trap for errors in your Script Task and Components and send the information to the SSIS...  Read more...
By Josef Richberg 2010/02/09 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,320 reads

Working with ADO.Net variables in SSIS scripts

I am always looking to improve the performance of my SSIS packages.  I try to do as much work within...  Read more...
By Josef Richberg 2010/01/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,706 reads

Using the Script Component With Multiple Outputs

This article demonstrates the use of the SSIS Script Component to create multiple outputs from unconventional data files.  Read more...
Rating: |  Discuss |   Briefcase | 7,801 reads

Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)

Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)  Read more...
Rating: |  Discuss |   Briefcase | 7,330 reads

SSIS Lookup using a Script Component

What would you do if you want to perform 15 to 30 lookups using the same reference dataset? This is how I did it...  Read more...
Rating: |  Discuss |   Briefcase | 13,064 reads

Using Script Component as a Transformation - SQL School Video

Script components greatly enhance the flexibility of your SSIS packages. MVP Brian Knight shows how you can use this in your transformations.  Read more...
By Brian Knight 2008/11/20 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,960 reads
   Items 1 to 10 of 10