spen_lang
asked on
SSIS Assign Null to Parameter in SQL Server Agent Job Step
Hi,
I have created an SSIS package with 3 input parameters. 2 parameters are mandatory (Required = True) and 1 parameter is NOT mandatory (Required = False).
I have deployed the package to SSISDB and am running it as a SQL Server Agent job. My question is, how do I set the non-mandatory parameter to blank\Null\Empty?
If I set it to nothing I get the following error message when I click OK.
I have created an SSIS package with 3 input parameters. 2 parameters are mandatory (Required = True) and 1 parameter is NOT mandatory (Required = False).
I have deployed the package to SSISDB and am running it as a SQL Server Agent job. My question is, how do I set the non-mandatory parameter to blank\Null\Empty?
If I set it to nothing I get the following error message when I click OK.
If I'm not mistaken SSIS doesn't support nullable types for it's built in variables which means for instance a null integer in SQL will become zero when assigned as an SSIS variable.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.