what is the purpose of SSIS packages?

[Former Member]

hi sap guru's

[Former Member]

Hi,

Before SSIS it was called as DTS Package

Set of actions need to happen in a series at given time interval (Daily,weekly,monthly..) with a complex business process. Which are like more complex Jobs schedulabale.

Below are some key steps required by business

1) Control the process flow of stepsu2014Process execution plan will be controlled like sequential, loop it based on condition checks, add certain tasks, declare some variables to use in the package etc...

2) Controls the Data flowu2014(ETL) Extract the data apply any conversion / transformation logic is required based on source and target data and load it.

3) Trigger based on certain action ( Event Based)

4) Send E-mail at the end of the process to the specified users

5) Reuse the same package across applications

SSIS helps you in achieving this.

Different technologies call the same with different names. In SAP, we call them process chains. Hope this helps.

Thank You,

Hanu

Edited by: Hanuyedluri on Aug 5, 2011 6:30 PM

[Former Member]

Hi Sowmya,

SSIS packages are the packages which are created in the SQL server which is the back-end of BPC MS versions. It is not present in BPC NW version as the we have BI as back-end in NW version and we use not SSIS packages but the process chains to run packages.

We use our BPC functions in the SQL server. You need to go to SAP Business Intelligence Development Studio -> MS SSIS folder and create or select packages there itself. You can run these package to load transactional data, master data or copy or move or delete data.

For further reference please check the following link:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/2027ebee-a928-2a10-4485-b88c926f5e24

Hope this resovles your query.

Rgds,

Poonam