Home  >  Blog  >   MSBI  > 

Working With SQL Server Management Studio in SSIS

Rating: 4
  
 
2616
  1. Share:
MSBI Articles

SQL Server Management Studio (SSMS)

a) Open SSMS (SQL server management studio)
b) Select server type in the following

  1. Database engineàTo connect and work with normal database.

  2. Integration service à To and work with normal database.

  3. Analysis service àTo connect and work with analysis service database.

  4. Reporting servicesà To connect and work reporting services databases.

  5. SQL server compact EditionàTo connect and work with mobile applications.

c) Server name –> Either IP Address (or) actual server name.
d) Select authentication –>
i) Window  authentication –> Consider window credentials to logon
ii) SQL server Authentication –> Server database credentials.
Note: Select the option:  ii)for the real time work process.
e) Click connect…. Next…
Creating databases –> Right click on database
New database window
Database Name: DMNEW
–> Click ok
Creating tables –> DBNe3wq –> Tables –> Right click–> Select ‘new tables’
Column         Name               Data Type
PARTY          ID                        Int
PARTY         NAME             VARCHAR (50)
–> Next save the table with a specified Name i.e, PARTY
–> Click OK.

FREE Demo Class From Industry Experts - Enroll Now.!! SSIS training

Adding data to the tables of the database

–> Right  click on TABLE –> Select the option “edit top 200 rows”.
PARTY ID         PARTY NAME
1                                x
2                            VINAY

MindMajix Youtube Channel

Firing Queries on database

  • Go to database(i.e DBNEW)

  • Right click à select new query

  • SELECT* FROM PAETY;

  • Click Execute (or) press “f5”

  • Insert into party values(3,’Mathu’, ‘Hyd’, 5000)

  • Update party set party ID=20 where party ID=222.

Frequently Asked SSIS Interview Questions & Answers

Connecting to the other database
Two ways:

i) By Specifying –> ..
Ex: SELECT * FROM   VINAY-DB.TEST
SELECT * FROM     SIVA_DB.TEST
ii) Taking other database as current database
Syntax: USE
USE  SIVA_DBA
SELECT * FROM
SELECT  * From PARTY_TEST;
Note:  Second way is recommendable if we are firing many queries on the same database (Eg: SIVA_DB)

                                           

Explore SSIS Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

List of Related Microsoft Certification Courses:

 SSRS  Power BI
 SSAS  SQL Server
 SCCM  SQL Server DBA
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
MSBI TrainingDec 06 to Dec 21
MSBI TrainingDec 10 to Dec 25
MSBI TrainingDec 13 to Dec 28
MSBI TrainingDec 17 to Jan 01
Last updated: 04 December 2022
About Author
Ravindra Savaram

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

Recommended Courses

1 /15