Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Extending SSIS Part 2 - SSIS Programmatically / Dynamically Building Packages Expand / Collapse
Author
Message
Posted Thursday, October 9, 2008 10:18 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
Comments posted to this topic are about the item Extending SSIS Part 2 - SSIS Programmatically / Dynamically Building Packages

Ira Warren Whiteside
Post #583726
Posted Friday, October 10, 2008 5:07 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,371, Visits: 1,391
Nice one...:)


Post #583870
Posted Friday, December 26, 2008 11:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:57 AM
Points: 2, Visits: 70
Good article.. can you post the whole source code ?
Post #625978
Posted Friday, December 26, 2008 11:45 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
thanks, I'll update the link on our website this weekend. If you havent already done so sign up for our beta and I 'll send out a notice on Sunday (12/28/2008).

Ira Warren Whiteside
Post #625988
Posted Friday, December 26, 2008 1:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:57 AM
Points: 2, Visits: 70
thanks.... i'm looking forward to develop an ssis package to import data from different types of text files( diff:metadata).

the package needs to be configured dynamically with the field names of the input file and the output colum name...may be using a XML file...

so that a new package need not be developed for different types of files , if the transformation on the files are same..
Post #626029
Posted Friday, December 26, 2008 4:04 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
Excellent, send an email to ira.whiteside@actualitybusinessintelligence.com I would like to help.

Ira Warren Whiteside
Post #626053
Posted Tuesday, March 3, 2009 4:34 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291

The code for this article is now available here


Ira Warren Whiteside
Post #667167
Posted Monday, August 2, 2010 5:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 17, 2013 7:53 AM
Points: 1, Visits: 62
I want source code i am able to find that one
Post #962100
Posted Monday, August 2, 2010 9:11 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
Thanks send me an email at iwhiteside@iwhiteside.com

Ira Warren Whiteside
Post #962564
Posted Sunday, February 2, 2014 5:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 5:24 AM
Points: 5, Visits: 231
Pretty helpful. We are using this framework at our office to automate some SSIS tasks. One question though:
1) sometimes the source and destination columns in our tasks don't line up on case sensitivity. How can I wire up a source input column to the destination in the data flow without it bombing if for instance the source column reads "sku_nbr" and the destination reads "sku_Nbr"?

Any help is greatly appreciated.
Post #1537170
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse