76 What are variables and Parameters in SSIS

[@pw.70]

Hi, at 04:15 you said you can supply zero (0). Is this specific to anything? Does this relate to a result ID in anyway or is it an arbitrary value?

[@learnssis]

When you select the variable at that place then the index starts from 0. If you have more variables to add then you can add more variables and start increasing the index to 1 then 2 and then 3 and so on.

[@pw.70]

@@learnssis - Fantastic - thank-you very much. This has been a very educational video.

[@learnssis]

@@pw.70 Thank you.

[@akshata85]

All videos are informative ..

[@khushik8994]

Great Content...watching all your SSIS Interview Questions video in a row...

[@learnssis]

Good to know Khushi that you liked them. I bet you can find some of the questions in ssis interviews.

[@sameerunawane]

while creating audit log table i am facing issue as "Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "IF NOT EXISTS(select * from INFORMATION_SCHEMA.TAB..." failed with the following error: "An explicit value for the identity column in table 'config_table' can only be specified when a column list is used and IDENTITY_INSERT is ON.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."

[@learnssis]

It seems like you are trying to insert a record to the identity column id. Do not provide a value for Id column.

[@aryasree4672]

I am using sql server authentication.So can I use project params for host, db,username and password.Pls reply

[@learnssis]

yes, you can use them.

[@nagmanchi]

Hi sir, in my package, variables under scope is coming default name as "package" only instead of our package name.. Please give me solution for getting our package name what we give under scope. i'm using visual studio 2019.

[@learnssis]

Change the name property of SSIS package to what ever you want your ssis variable scope to be and the scope of the package will change automatically.

[@mylifecycle8657]

Hi, Can we pass multiple values in project parameter?

[@learnssis]

Ideally a single value is passed in a single project parameter. For example if you need to pass the server name and database name to the ssis packages using Project parameter then create 2 project parameters one for server name and another one for database name, but yes if you want to pass multiple values in a single parameter then you can pass it, but in SSIS package you would need to extract the concatenated value and assign it to proper ssis variables.

[@sunilbadugu1211]

Hi ,how to send ssrs report to different user according to theire region , report should contain only thire region not all regions , ex : I belongs to India , I should receive only Indian region report ,pls help

[@learnssis]

I don't have much experience on SSRS. As far as I am aware there is some subscription option in SSRS to send the email but I have not extensively worked with SSRS.

[@sathiyamoorthi9224]

Hi Aqil, you are doing amazing work . Could you please share the video how do use aggregate functions like min(id ) ,max (id ),max(date ) in excute SQL task by using dynamic variables and dataflow also .means need to get max id and min id and Max date column and insert records to another table There is no video in KZbin how do use aggregate functions in excute SQL task and dataflow task by using dynamic variables. Could you please upload above mentioned comments. It will help to us . Thanks for understanding!!

[@BTECH123]

Please resend the format for writing variables and expressions. I lot previous bro. 🌹🌹🌹

[@learnssis]

Can you check the description of this video, I should have shared the code used in this video.

[@BTECH123]

@@learnssis no bro, once you sent me how to write expressions few months back. I lost that message

[@learnssis]

@@BTECH123 What is your email id , send me a test email on [e-mail] ?

[@chirinebelfkih7417]

Je suis une étudiante , j'ai fais un travail pratique en ssis , je l'ai finis et j'ai chargè le datawerehouse , le problème je veux créer un paramètre pour créer les connexions , je ne sais pas comment faire merci de me réponse svp ,

[@jaikrishna511]

Perfect 👍keep up your good work

[@learnssis]

Thank you Jai.

[@Juan-Hdez]

Useful. Thank you.

[@learnssis]

You are most welcome Juan Hernandez.

[@jesusantoniorozozapata8981]

great, this is very great, i can understand, i think that you can do tutorials about iss and api ..you can regards

[@learnssis]

Thank you so much for your kind words.

[@muralimuthyala1965]

thank you

[@learnssis]

Thank you Murali.

[@sandeeppai25]

Thanks

[@learnssis]

Thanks Sandeep.

[@learner_SSIS]

Hi aqil, how to move sql agent jobs from one server to another using ssis

[@learnssis]

SQL Server agent jobs won't be moved using ssis. What you would need to do is that generate the create sql server agent job script from one server and copy it and then execute the same script on another server.