Clear package from an other Application

[Former Member]

Hi!

Is it possible to run a clearpackage from from one application that runs the clear on an other package.

I am in the application "rapport" and I will like to run a clear on the application "Prognos".

I put this "info" line in the package but the clear is still made on the "rapport" application

INFO(%APP%, PROGNOS)

INFO(%TEMPFILE%,%TEMPPATH%%RANDOMFILE%)

'Modify Export task

'----

---

TASK(EXPORT_ZERO,APPSET,%APPSET%)

TASK(EXPORT_ZERO,APP,%APP%)

TASK(EXPORT_ZERO,USER,%USER%)

TASK(EXPORT_ZERO,FILE,%TEMPFILE%)

TASK(EXPORT_ZERO,SQL,%SQLDUMP%)

TASK(EXPORT_ZERO,DATATRANSFERMODE,2) 'Export from sql

'Modify Load Cube task

'----

---

TASK(LOAD CUBE,APPSET,%APPSET%)

TASK(LOAD CUBE,APP,%APP%)

TASK(LOAD CUBE,USER,%USER%)

TASK(LOAD CUBE,FILE,%TEMPFILE%)

TASK(LOAD CUBE,DATATRANSFERMODE,4) 'import into Cube

TASK(LOAD CUBE,DMMCOPY,0) 'Accept Calc member

TASK(LOAD CUBE,PKGTYPE,0) 'Clear Package Type

TASK(LOAD CUBE,CHECKLCK,%CHECKLCK%)

TASK(CLEAR COMMENTS,APPSET,%APPSET%)

TASK(CLEAR COMMENTS,APP,%APP%)

TASK(CLEAR COMMENTS,USER,%USER%)

TASK(CLEAR COMMENTS,DATATRANSFERMODE,0) ' 0 means clear comments

TASK(CLEAR COMMENTS,SELECTIONORFILE,%TEMPFILE%)

TASK(CLEAR COMMENTS,ENABLETASK,%ENABLETASK%) '1 means execute , others will skip this task

TASK(CLEAR COMMENTS,CHECKLCK,%CHECKLCK%)

'----

---

< Detail> -

---

'Should not change below

'----

---

BEGININFO (%SQLDUMP%)

select %FACTDIMS%,0 as SIGNEDDATA

FROM

( SELECT %FACTDIMS%,0 as SIGNEDDATA FROM TBLFACT%APP% WHERE %SELECTION%

UNION ALL

SELECT %FACTDIMS%,0 as SIGNEDDATA FROM TBLFACTWB%APP% WHERE %SELECTION%

UNION ALL

SELECT %FACTDIMS%,0 as SIGNEDDATA FROM TBLFAC2%APP% WHERE %SELECTION%

) as ZeroTable

group by %FACTDIMS% OPTION(MAXDOP 1)

ENDINFO

[Former Member]

Worked when i defined:

INFO(%DIMS%) and [INFO(%FACTDIMS%) with the right dimensions

[Former Member]

Daniel,

Just change all %APP% to Prognos and it should work:

IE

TASK(EXPORT_ZERO,APP,%APP%)

will then be

TASK(EXPORT_ZERO,APP,PROGNOS)

Alwin

[Former Member]

Hi!

I have tried this but something goes wrong.

I think it is the row:

TASK(EXPORT_ZERO,SQL,%SQLDUMP%)

%SQLDUMP% gets the dimension from the application where I execute the DTS package and in my case the dimension differ between the application.

How can i change the %SQLDUMP% to get the dimensions from the right application?

TASK(EXPORT_ZERO, SQL,

select [ENHET],[GRUPP],[AKTIVITET_PRO],[DELPROJ_PRO],[INDATATYP],[KATEGORI],[KONTO_DTL],[KONTO_PRO],[PART],[PRODUKT_PRO],[PROJEKT_PRO],[TIMEID],[RESURS_PRO],0 as SIGNEDDATA

FROM

( SELECT [ENHET],[GRUPP],[AKTIVITET_PRO],[DELPROJ_PRO],[INDATATYP],[KATEGORI],[KONTO_DTL],[KONTO_PRO],[PART],[PRODUKT_PRO],[PROJEKT_PRO],[TIMEID],[RESURS_PRO],0 as SIGNEDDATA FROM TBLFACTRAPPORT WHERE (INDATATYP='IMPORT' OR INDATATYP='MOTPART') AND KATEGORI='UTFALL' AND TIMEID=dbo.fn_Timeid('2008.OCT')

UNION ALL

SELECT [ENHET],[GRUPP],[AKTIVITET_PRO],[DELPROJ_PRO],[INDATATYP],[KATEGORI],[KONTO_DTL],[KONTO_PRO],[PART],[PRODUKT_PRO],[PROJEKT_PRO],[TIMEID],[RESURS_PRO],0 as SIGNEDDATA FROM TBLFACTWBRAPPORT WHERE (INDATATYP='IMPORT' OR INDATATYP='MOTPART') AND KATEGORI='UTFALL' AND TIMEID=dbo.fn_Timeid('2008.OCT')

UNION ALL

SELECT [ENHET],[GRUPP],[AKTIVITET_PRO],[DELPROJ_PRO],[INDATATYP],[KATEGORI],[KONTO_DTL],[KONTO_PRO],[PART],[PRODUKT_PRO],[PROJEKT_PRO],[TIMEID],[RESURS_PRO],0 as SIGNEDDATA FROM TBLFAC2RAPPORT WHERE (INDATATYP='IMPORT' OR INDATATYP='MOTPART') AND KATEGORI='UTFALL' AND TIMEID=dbo.fn_Timeid('2008.OCT')

) as ZeroTable

group by [ENHET],[GRUPP],[AKTIVITET_PRO],[DELPROJ_PRO],[INDATATYP],[KATEGORI],[KONTO_DTL],[KONTO_PRO],[PART],[PRODUKT_PRO],[PROJEKT_PRO],[TIMEID],[RESURS_PRO] OPTION(MAXDOP 1)

)