February 8, 2014 at 10:56 am
Hi,
I am not in expert level in SSIS. Your.Your inputs are highly appreciated .
I have created an SSIS package with few of the input parameters . This been called by .bat file by passing these parameters .But the problem here package gets called but given input parameter has not been taken,instead package takes value from the designer.
Please advice me ....
February 8, 2014 at 1:40 pm
Hi,
you can use the /set Parameter in your script.
For more help please read
http://technet.microsoft.com/en-us/library/ms162810(v=sql.105).aspx
Regards,
René
February 11, 2014 at 5:04 am
My code looks like this ...
Even i passed these parameters process LOAD_DDA.dtsx take only those values which sets on design time .
DTExec.exe /F "D:\SSIS\Packages\LOAD_DDA.dtsx" > "\\Packages\log\output.txt"
/SET \package.variables[User::IN_FileConnString].Value;"\\Files\DDA_TARS_012014.txt"
/SET \package.variables[User::IN_fiscal_year_nbr].Value;2014
/SET "\package.variables[User::IN_month_nbr].Value";01
/SET \package.variables[User::IN_SSIS_log].Value;"\\Packages\SSISlog.log
if any one experience please advice me a solution
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply