Skip to Content

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

Execute Default Logic from Stored Procedure


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 @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


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