[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 -EXITThis 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