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:
Thanks for sharing :-)
ReplyDeleteThank you for your valuable feedback
DeleteReally good information to show through this blog. I really appreciate you for all the valuable information that you are providing us through your blog.
ReplyDeleteThanks for your feedback
DeleteI appreciate the time you spent finding that information
ReplyDeleteThanks for your feedback
DeleteThanks that really help
ReplyDeleteThanks for your feedback
Delete