Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Integration Services (SSIS), Metadata Rss

   Items 1 to 3 of 3   

Generate multiple SSIS packages using BIML and metadata

Although BIML is very powerful, you wouldn’t use it to generate one package at a time. Using metadata, we can generate multiple packages on the fly. Koen Verbeeck illustrates how to convert the BIML script for generating the import package to a dynamic package generating machine.   Read more...
By Additional Articles 2013/12/26 | Source: | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 2,983 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,479 reads

How SSIS and Other Tools Obtain Metadata

How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.  Read more...
By Renato Buda 2008/11/03 | Source: | Category: fmtonly
Rating: |  Discuss |   Briefcase | 7,376 reads
   Items 1 to 3 of 3   
address parsing (1)    
biml (1)    
data profiling (1)    
derived column (1)    
fmtonly (1)    
pattern profiling (1)    
regular expressions (1)    
script component (1)    
temp tables (1)