Focal Point
[CLOSED] Run SSIS Package PASSING PARAMETER from WEBFOCUS

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9867016096

July 26, 2018, 09:03 AM
v_ani
[CLOSED] Run SSIS Package PASSING PARAMETER from WEBFOCUS
Hello,
This is first time I am trying pass parameter from WEbfocus to run SSIS package.Can any one help me what are the steps. Do I have to create synonym for SSIS package. I appreciate any one help me...

-DEFAULT &START_YEARMT='201807';
-DEFAULT &END_YEARMT='201807';
SET SQLENGINE=SQLMSS
SQL EX [server].DBASE.DBO.SPROC &START_YEARMT,&END_YEARMT;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS MPHOLD
END
-EXIT

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
July 27, 2018, 09:46 AM
FP Mod Chuck
v_ani

Are you getting an error when running it like this? If the ssis package is in fact a stored procedure you can create a synonym and then use WF to run it.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats