Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Execute Default Logic from Stored Procedure

Hi,

Maybe someone could help me with this problem. I am working on a project where I have to execute a DTSX package (DefaultLogic.dtsx) through a stored procedure directlly on the SQL Server. I know how to call the DefaulLogic.dtsx, but my problem is how to push the necessary variables to it. Please see the code below.

Your help is greatlly appriciated.

Dejan R.

-


Declare @cmd varchar(1000)

Declare @ssispath varchar(1000)

// Input Variables //

Declare @CATEGORY_DIM varchar(25)

Declare @ENTITY_DIM varchar(25)

Declare @TIME_DIM varchar(25)

Set @CATEGORY_DIM = 'BUDGET'

Set @ENTITY_DIM = '3000'

Set @TIME_DIM = '2011.JAN'

// Execute DTSX Package //

set @ssispath = 'C:\some_path\DefaultLogic.dtsx'

select @cmd = 'dtexec /F "' + @ssispath + '"'

select @cmd = @cmd + ' /SET \Package.Variables[User::MODIFYSCRIPT].Properties[Value];"' + ??? How to push all variables ??? + '"'

exec master..xp_cmdshell @cmd

-


Former Member
Not what you were looking for? View more on this topic or Ask a question