Create user name and logins using SSIS
Step 1: Drag and drop execute SQL Task Step 2: Edit and provide connection string information Provide server name and select database Step 3: In SQL statement, provide SQL as shown in bellow CREATE LOGIN TestLogin WITH PASSWORD = 'Test@123' Step 4: Drag and drop another SQL execute task Step 5: Edit and provide connection string information Step 6: CREATE USER Balu FOR LOGIN TestLogin Step 7: Before creating of user and login Step 8: Execute task Step 9: