152 Variable and parameter in ssis

variable and parameter in ssis
Download files and scripts: drive.google.c...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
variable and parameter in ssis
What is difference between variables and parameters in SSIS?
What is variable in SSIS?
SSIS Parameters vs Variables
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@Marina1BEL]

thanks for all your explanations

[@learnssis]

Thank you Marina.

[@prashanthtalla]

Thanks a lot. How to create the Project Parameters that can be sourced from a config file like DBName, UserName, Passwd? And how to encrypt Passwd? In Informatica, you have a tool called pmpasswd using which we can encrypt the passwd and use it in the config file.

[@learnssis]

In SSIS we can create the Project Parameters but the value to project parameters can be provided either from a sql query, or from a sql agent job. kzbin.info/www/bejne/Z3ilo4B4j7h0paM You can not provide the value to project parameter from a file. You can create SSIS variable and you can pass the value to ssis variable from batch file, sql agent job, xml config file.

[@ankitsaxena565]

Sir, I'm working as SQL support engineer now i want to move on ETL,so nowadays best tell dor job and also career growth,is it good time learning ssis or learning add which js better because my background is SQL support engineer

[@learnssis]

If you have good knowledge about SQL server, then it will be very easy for you to learn ssis and make use of SQL. Because in SSIS packages, a lot of code is written in SQL, and if you have good background in SQL then it can help a lot to get a job on ETL. As the interviewer mainly focuses on SSIS and SQL questions.

[@ankitsaxena565]

​@@learnssisthank you sir for your valuable response, but I want to move on to the etl tool which is good ADF AZURE DATA FACTORY or ssis because I'm a little bit confused ki kon sa seekhna chahiye ssis ya azure data factory

[@OneNI83]

Good Video.Can you explain how these values are overwritten by SSIS environment when deployed in sql server?

[@learnssis]

Thanks. I have videos created on these topics, you can check them here kzbin.info/www/bejne/jJPbloBngJ1_d7c kzbin.info/www/bejne/rpKleoyumpqkjKM kzbin.info/www/bejne/rpq7qHafmbN5r5I kzbin.info/www/bejne/e5-7fYiQjt2Al9k

[@sadafperween5368]

Hi, I am currently working in IT as ETL developer using SSIS technology. I want to talk to you. How can I contact you ?

[@learnssis]

Email me at [e-mail]

[@sadafperween5368]

​@@learnssis have sent an email. Could you please check