documentation regarding dtsx packages

[Former Member]

Hi,

Does there exist any documentation regarding the creation of dtsx packages.

Apart from on the forum, we have been unable to locate any documentation regarding the creation of dtsx packages.

We would like to know things such as what DataTransferMode and ProcessMode controls, and what the various tasks that you can use within dtsx packages are.

We are using SAP BPC 7.0 SP6 on SQL Server 2005. We plan to upgrade to BOPC 7.5 on SQL Server 2008 R2 next year.

Regards,

Mark

[PatrickFavre]

Hi Mark,

You can have a look at following link, where lots of How-to Guides are accessible:

http://wiki.sdn.sap.com/wiki/display/BPX/EnterprisePerformanceManagement%28EPM%29How-to+Guides

There is particularly one speaking about the creation of SSIS packages (for BPC 5.x and SQL 2005). But there is nothing really new in BPC 7.5 an SQL 2008, except that the dll used for BPC tasks are now called for example "OsoftTaskAdmin2008.dll" for SQL 2008, instead of "OsoftTaskAdmin.dll" for SQL 2005.

Hope this information will help you.

Kind Regards,

Patrick

[Former Member]

Patrick,

Thanks for the reply, I had already read this document.

It does not contain any information about what the various tasks are and how to configure them.

Thus far we have been developing by guess work, which I do not like.

Regards,

Mark