Thursday, March 22, 2012

Can I create Packages programatically

For example assume that there is a DTS That takes some SELLS data from an oracle database and sum the sells for each month.

I can create the package visually, but what about if I want to create it programatically. I want to make a software for Balance Scorecard in which the users dont need to know Integration Services. they should have a consoloe for asking where to get an Indicator value. and the program should create it programatically.Yes, look in books online under Integration Services programming. There's a good reference there.sql

No comments:

Post a Comment