Hi I was going through your videos they were really helpful thanks for your videos.I have a doubt I am handling fail-over scenarios and I have passed an listener IP in fail-over string can you give some suggestions on how to handle these strings dynamically for three instances UAT,PROD etc.
Thank a lot for simplifying the concept and presented in video.. i have one doubt, we created a package like above in Dev Environment and my next step is how to send it for UAT Environment and Prod Environment.
Hi, once you have created package in dev environment, then in the SQL Server Data Tools (Visual Studio), you need to rebuild the project, which will create *.ispac file inside a folder in the Bin directory of your project. You can copy the bin directory to the Prod Environment, double click on .ispac file, it will open the same GUI which you seen here, you can deploy in similar way there.
Salaams Akil. Excellent series and explanation. Thank you so much for sharing. I had a quick question if I may. I am planning to setup replication for one of our clients. The aim is to replicate only a few tables to the secondary database. However, due to the size of the dB and the amount of transaction logs that are being generated, would it be possible to use SSIS instead of Replication? Any pointers or advice will be highly appreciated.
Wa alikum asslam Nazim Bhai. Yeah SSIS is one of the best way to replicate the data between 2 servers. I have created a video on almost same topic, may be below video can help you to get an idea th-cam.com/video/DEx7mDhSkp4/w-d-xo.html th-cam.com/video/8dRIjVhKoKs/w-d-xo.html
Thank you. You can do that. You just need to deploy the project here. Just create a new project in Visual Studio and then deploy the Project by selecting the parent folder of the project and you will see the new project inside the parent folder as well inside the Projects folder.
Thanks a lot. I have a small question. I did the same thing but instead of project parameter, I used a variable to store the FilePath. When executing from management studio, I was able to change the path just like how you did with the parameter. So, do you think both work similarly?
Project Parameter's scope will be for all packages inside a project, however an SSIS variables scope will be limited to that particular SSIS package only. You can not change the value of Project parameter inside the SSIS package, however SSIS variables value can be changed during package execution. So there were 2 basic differences between both, although if your case suits package variable then you can use them. Thanks.
@@learnssis you are saying we can't change the project parameter value but you changed the value during execution from file1 to file2!! Can you please clarify.
@@CRVgarage, we can't change the value inside the SSIS package, for example we can't modify the value from File1 to File2 inside the SSIS package, we can give the value outside the SSIS package, but when the package is running, in any task like in script task or in expressions you can not modify the value of Project parameter, however you can set any value to any SSIS variable any time in the SSIS package. Thanks.
@@learnssis and also , you already created the package and you said this the package, learner’s wants to show them one by one . So don’t jump. Keep up it.
One doubt here.If we are loading multiple files say in for each loop to a database table then the project parameter (which cannot be changed dynamically during package run time).How this can be solved using parameters.
@@nitagawade3330 Sorry I have not tried this thing. Normally when I check if something is running on the sql server, I run sp_who2 and then check the result on sql server.
Can you try this one ? The resolution is to change the SSIS project TargetServerVersion property. Right-click on the project an choose Properties. On the screen that loads change the TargetServerVersion value to the version of SQL Server you're using.
I don't think we have any limitation as such. But if you have a lot of packages and you let the packages open while closing the solution, then it can take a lot of time to open the project again as it will try to validate the connection string for all packages. thanks.
Awesome bro, thank you, exactly what I needed !!
Glad it helped you.
Thanks for making such an informative videos on SSIS
You are most welcome Manali Arora.
Your videos are much easy to understand. Can you please upload videos for SSRS
Thanks a lot for your comment. Yeah I am planning to work on creating the videos on SSRS too, but it will take some time :)
Very good and clear understand able topics.
Thanks Manas for your comment.
Hi I was going through your videos they were really helpful thanks for your videos.I have a doubt I am handling fail-over scenarios and I have passed an listener IP in fail-over string can you give some suggestions on how to handle these strings dynamically for three instances UAT,PROD etc.
Thank a lot for simplifying the concept and presented in video.. i have one doubt, we created a package like above in Dev Environment and my next step is how to send it for UAT Environment and Prod Environment.
Hi, once you have created package in dev environment, then in the SQL Server Data Tools (Visual Studio), you need to rebuild the project, which will create *.ispac file inside a folder in the Bin directory of your project. You can copy the bin directory to the Prod Environment, double click on .ispac file, it will open the same GUI which you seen here, you can deploy in similar way there.
Salaams Akil. Excellent series and explanation. Thank you so much for sharing. I had a quick question if I may. I am planning to setup replication for one of our clients. The aim is to replicate only a few tables to the secondary database. However, due to the size of the dB and the amount of transaction logs that are being generated, would it be possible to use SSIS instead of Replication? Any pointers or advice will be highly appreciated.
Wa alikum asslam Nazim Bhai. Yeah SSIS is one of the best way to replicate the data between 2 servers. I have created a video on almost same topic, may be below video can help you to get an idea
th-cam.com/video/DEx7mDhSkp4/w-d-xo.html
th-cam.com/video/8dRIjVhKoKs/w-d-xo.html
@@learnssis Jazakallah Little Brother :-)
osm explanation sir,😍😍 here i have one doubt i want to create new project inside the Projects folder how to create it?
Thank you. You can do that. You just need to deploy the project here. Just create a new project in Visual Studio and then deploy the Project by selecting the parent folder of the project and you will see the new project inside the parent folder as well inside the Projects folder.
Great video, thank you!
Thanks for your comment.
Thanks a lot. I have a small question. I did the same thing but instead of project parameter, I used a variable to store the FilePath. When executing from management studio, I was able to change the path just like how you did with the parameter. So, do you think both work similarly?
Project Parameter's scope will be for all packages inside a project, however an SSIS variables scope will be limited to that particular SSIS package only. You can not change the value of Project parameter inside the SSIS package, however SSIS variables value can be changed during package execution. So there were 2 basic differences between both, although if your case suits package variable then you can use them. Thanks.
@@learnssis you are saying we can't change the project parameter value but you changed the value during execution from file1 to file2!! Can you please clarify.
@@CRVgarage, we can't change the value inside the SSIS package, for example we can't modify the value from File1 to File2 inside the SSIS package, we can give the value outside the SSIS package, but when the package is running, in any task like in script task or in expressions you can not modify the value of Project parameter, however you can set any value to any SSIS variable any time in the SSIS package. Thanks.
@@learnssis Got it. Parameters stay put during runtime but Variables could change. Thanks so much!!
@@CRVgarage welcome.
Great
Your video is really helpful but you’re fast when you are doing copy and past
Yeah you are right, sometimes I might be fast with few things, just to make the video shorter. I will take care of it.
@@learnssis and also , you already created the package and you said this the package, learner’s wants to show them one by one . So don’t jump. Keep up it.
@@niguseatilahun4893 got your point. I agree sometimes I am too fast with the things, I am trying to improve them in new videos.
One doubt here.If we are loading multiple files say in for each loop to a database table then the project parameter (which cannot be changed dynamically during package run time).How this can be solved using parameters.
Hello, for this scenario you need to use the SSIS Variable. SSIS Variables can be changed within the package.
Hi, my 'Create Catalog' button is disable, I can't find how to make this enable. SSMS V 18.12, installed Integration Services.
Please close the SSMS and reopen it and try again.
@@learnssis solved. SSMS didn't let to create catalog because I already have simple db named 'SSISdb'. After drop problem was solved. :)
Awsome!!!
Good to know that you liked the video.
Hello sir...can you tell mi...how to get list of all ssis packges which running on sql server
@@nitagawade3330 Sorry I have not tried this thing. Normally when I check if something is running on the sql server, I run sp_who2 and then check the result on sql server.
My script task is corrupting while deploying how can I resolve this
Can you try this one ? The resolution is to change the SSIS project TargetServerVersion property. Right-click on the project an choose Properties. On the screen that loads change the TargetServerVersion value to the version of SQL Server you're using.
great
Thank you.
I have a doubt I cant see integration service catalog in my sql server can u pls help me on that
Check if you have Sysadmin rights on the machine.
If we have different name then how to define package name for deployment
Sorry did not get your question. By this method all packages in a project will be deployed to SSIS catalog. It is package independent.
sir i want to create a package of a view which has duplicate records
Sorry I did not get your point, what you want to do inside ssis package ?
how many packages can create in one project
I don't think we have any limitation as such. But if you have a lot of packages and you let the packages open while closing the solution, then it can take a lot of time to open the project again as it will try to validate the connection string for all packages. thanks.
Aguiwgga. Urwufja