Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS-Problem with Passing Parameters Expand / Collapse
Author
Message
Posted Saturday, February 08, 2014 10:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 7:40 AM
Points: 47, Visits: 151
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 ....
Post #1539517
Posted Saturday, February 08, 2014 1:40 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:29 AM
Points: 2,488, Visits: 1,135
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é
Post #1539527
Posted Tuesday, February 11, 2014 5:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 7:40 AM
Points: 47, Visits: 151
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
Post #1540139
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse