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

Can anyone tell me.

Let's assume I have to go for setup of sql server and I have a 20 GB
database and daily transaction is around 200 KB size. Can any one tell me
what I have to do for setup sql server like what are the configuration and
what are the step I have to consider.
Thanks
John
For the most parts, SQL Server is smart enough to figure out the appropriate
configuration during installation. However, there are things to consider
before you install (hardware requirements, disk layout, etc...) and things
to do after you're done (maintenance).
Suggest you check out http://www.microsoft.com/sql/ and review some of the
installation and management papers then come back here with specific
questions.
joe.
"John" <naissani@.hotmail.com> wrote in message
news:Olt0u6cFFHA.1348@.TK2MSFTNGP14.phx.gbl...
> Let's assume I have to go for setup of sql server and I have a 20 GB
> database and daily transaction is around 200 KB size. Can any one tell me
> what I have to do for setup sql server like what are the configuration and
> what are the step I have to consider.
> Thanks
> John
>