Thanks for the example. You can also override the parameters on the Agent Job Configuration tab that executes a package. So all scheduled job that parameterize connections can deployed across different environments like DEV, QA, and Production by setting the parameter connection in the job definition.
hi @BeardedDev thx for this tutorial its very very helpfull.. if possible ,can you make another video , to deploy SSIS by scripting batch maybe, to make easier and faster to deploy project.. if it can be make, I'm very grateful for it.
The problem that I have is that if I use SQL authentication and use parameters the execution fails stating "...Invalid login for userxxx". I wonder why?
First thing I would check is that the database allows SQL authentication and you can connect through SSMS, if that’s okay then it could be the connection string is not storing the password.
When you talk about areas of the screen like "x is set here" I can't see a mouse pointer so I find it difficult to follow where you are referencing at times.
hi Dev, I am stuck on connection manager error while creating a data flow from dynamics odata feed to an sql server. connection test is ok, table maps all ok but it gives connection manager error while on run 😭
Are you testing on SSDT? That will run under your user account rather than the account setup, you will need to check you have permissions on the data source first. If that is all setup can you provide more details on the error?
Thanks for the example. You can also override the parameters on the Agent Job Configuration tab that executes a package. So all scheduled job that parameterize connections can deployed across different environments like DEV, QA, and Production by setting the parameter connection in the job definition.
hi @BeardedDev thx for this tutorial its very very helpfull.. if possible ,can you make another video , to deploy SSIS by scripting batch maybe, to make easier and faster to deploy project.. if it can be make, I'm very grateful for it.
The problem that I have is that if I use SQL authentication and use parameters the execution fails stating "...Invalid login for userxxx". I wonder why?
First thing I would check is that the database allows SQL authentication and you can connect through SSMS, if that’s okay then it could be the connection string is not storing the password.
When you talk about areas of the screen like "x is set here" I can't see a mouse pointer so I find it difficult to follow where you are referencing at times.
Thanks for the feedback, I will make sure to show the mouse pointer and zoom in on areas in future videos.
hi Dev, I am stuck on connection manager error while creating a data flow from dynamics odata feed to an sql server. connection test is ok, table maps all ok but it gives connection manager error while on run 😭
Are you testing on SSDT? That will run under your user account rather than the account setup, you will need to check you have permissions on the data source first. If that is all setup can you provide more details on the error?