Working With SQL Server Management Studio in SSIS

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.

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

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 –> ..
                                           

List of Related Microsoft Certification Courses: