Extending SSIS Part 2 - SSIS Programmatically / Dynamically Building Packages

Question

Post reply

Extending SSIS Part 2 - SSIS Programmatically / Dynamically Building Packages

Ira Warren Whiteside

SSCrazy

Points: 2146
More actions
October 9, 2008 at 10:18 pm

#194429

Comments posted to this topic are about the item Extending SSIS Part 2 - SSIS Programmatically / Dynamically Building Packages
[font="Comic Sans MS"]Ira Warren Whiteside[/font]

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Anipaul SSC-Insane Points: 24681 More actions · Answer 1

Anipaul

SSC-Insane

Points: 24681

October 10, 2008 at 5:07 am

#883344

Nice one...:)

luckochan Valued Member Points: 50 More actions · Answer 2

luckochan

Valued Member

Points: 50

December 26, 2008 at 11:18 am

#917880

Good article.. can you post the whole source code ?

Ira Warren Whiteside SSCrazy Points: 2146 More actions · Answer 3

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).

[font="Comic Sans MS"]Ira Warren Whiteside[/font]

luckochan Valued Member Points: 50 More actions · Answer 4

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..

Ira Warren Whiteside SSCrazy Points: 2146 More actions · Answer 5

Excellent, send an email to ira.whiteside@actualitybusinessintelligence.com I would like to help.

[font="Comic Sans MS"]Ira Warren Whiteside[/font]

Ira Warren Whiteside SSCrazy Points: 2146 More actions · Answer 6

The code for this article is now available here

[font="Comic Sans MS"]Ira Warren Whiteside[/font]

burri.rahul Grasshopper Points: 21 More actions · Answer 7

burri.rahul

Grasshopper

Points: 21

August 2, 2010 at 5:49 am

#1200933

I want source code i am able to find that one

Ira Warren Whiteside SSCrazy Points: 2146 More actions · Answer 8

Thanks send me an email at iwhiteside@iwhiteside.com

[font="Comic Sans MS"]Ira Warren Whiteside[/font]

Upsert SSC Veteran Points: 296 More actions · Answer 9

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.

akula.sandeepkumar 10659 Grasshopper Points: 17 More actions · Answer 10

I think the domain of http://actualitybusinessintelligence.com/articles.aspx is expired.

its throwing following error message.

actualitybusinessintelligence.com expired 25 days ago!

I am looking for buiding a dynamic package how can download the source code.

Kannan Vignesh SSC Eights! Points: 851 More actions · Answer 11

Hi,

Good Day..!

i would like to add variable in excel file path expression. how can i add programatically in excel connection manager.

thanks in advance

regards
Kanna