<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tags
Integration Services (SSIS)
,
Script Component
Items 1 to 8 of 8
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
2010/12/08
|
Source:
SQLServerCentral.com
|
Category:
data warehouse
Rating:
|
Discuss
|
Briefcase
|
6,771 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...
By
Ira Whiteside
2010/02/23
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
2,146 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,003 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,435 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...
By
Tim Mitchell
2009/04/15
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
7,477 reads
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
Read more...
By
Ira Whiteside
2009/03/04
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
6,635 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...
By
Sachin Dedhia
2008/12/30
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
12,590 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,856 reads
Items 1 to 8 of 8
Tags
blogs
(2)
address parsing
(1)
ado variables
(1)
asynchronous
(1)
data flow
(1)
data profiling
(1)
data quality
(1)
data warehouse
(1)
derived column
(1)
etl
(1)
fact table
(1)
fuzzy match
(1)
jaro winkler
(1)
lookup transformation
(1)
metadata driven
(1)
pattern profiling
(1)
regular expression
(1)
scd
(1)
scripting
(1)
star schema
(1)
video
(1)
windows event log
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
