How do i connect to database after i installed SSIS 2012?

Question

I am trying to connect to database from Integration Service project from Microsoft visual studio. How do I create a database from SQL SERVER 2012.

did you try Google before posting a question here ? – qre0ct Apr 06 '17 at 17:03 — qre0ct, Apr 06 '17 at 17:03

score 0 · Answer 1 · answered Apr 06 '17 at 16:02

SQL Server Management Studio (SSMS) will allow you to create a database and tables through its graphical user interface. However, I'm guessing what you're looking for is actually an SSIS Connection Manager to an existing database. Look at the connection managers in SSIS, create a new one, and fill in the boxes. What you're doing is building a database connection string. You will need credentials (username and password, or a Windows authenticated user) to connect to the database. Also, you may need to spend some time reading the documentation.

Thanks..finally I connected to database in SSIS – Mathu Apr 06 '17 at 16:16 — Mathu, Apr 06 '17 at 16:16

How do i connect to database after i installed SSIS 2012?

1 Answers1