Scheduling the SSIS package which is using SQL Server Authentication to connect to Database

Dear Friends,

There is only a small change required to schedule the SSIS package which is using SQL Server authentication to connect to Database other than Windows authentication (Go through the blog Schedule SSIS through SQL Server Management Studio... to know how to schedule the SSIS package)

Go to step properties (Means Add step or edit step window) -- After selecting the package ,Click on Data sources Tab. There we can see all the connections of SSIS package which we selected. The make the check box "True" for that connection string which is using SQL Server authentication. Then edit the connection string by inserting the SQL server User's password after the User ID

For Eg: Data Source=Databaseservername;User ID=test;pwd=tstpwd;Initial Catalog=testdb;Provider=SQLOLEDB;Persist Security Info=True;

For more clarification refer the following image