Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nord
Posting Yak Master
126 Posts |
 Posted - 2012-02-10 : 09:46:35
|
| Hi,I have some question....I have ssis and i would like ,job send parametr like brand,bd,username,pasword to ssis and run ssis,how i can do it?thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 10:39:27
|
| you can do it by adding the parameters as variables in ssis. then in job steps you can go to values tab and set the values for these variables with required values you need to pass and ssis will automatically assign them to variables for use inside it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2012-02-13 : 00:40:45
|
| Which code i need write to job?"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /FILE "C:\Users\echepeleutser\Documents\Visual Studio 2008\Projects\Integration Services Project1\Integration Services Project1\fournisseur.dtsx" /CHECKPOINTING OFF /SET "\Package.Variables[User::Server_name].Value"; "\WMLDEV-96\" /REPORTING EWCDI thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-13 : 10:15:39
|
| it should be of format"\package.variables[variablename].Value";"your variable value"------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2012-02-13 : 10:27:31
|
| Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-13 : 10:38:07
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
parametr into job