SSIS:Installation: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
← Older edit
Oscar (talk | contribs)
717 edits
No edit summary
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISIntroNav
 
|QuickStartCollapse=
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
}}
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''SSIS Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Introduction|Introduction]]
|-
|[[SSIS:System Requirements|System Requirements]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Quick Start
|-
|[[SSIS:Installation|SSIS Installation]]
|-
|[[SSIS:Component Installation|Component Installation]]
|-
|[[SSIS:Subscribe|Subscribe]]
|-
|[[SSIS:Project Setup|Project Setup]]
|}
|}
 


{{CustomTOC}}
{{CustomTOC}}
Line 107: Line 84:
==Install Procedure==
==Install Procedure==
To install, download and run the Data Quality Components Executable.
To install, download and run the Data Quality Components Executable.
===Install File===
1. Download and Run the install file.
[[File:SSIS_Install_Welcome.png|link=]]
Click '''Next >''' to continue.


===License Agreement===
===License Agreement===
2. Read and accept the license agreement.
1. Read and accept the license agreement.


[[File:SSIS_Install_Agreement.png|link=]]
[[File:SSIS_Install_Agreement.png|link=]]


 
Click '''Next''' to continue.
===Install Directory===
3. Choose an install directory for the components.
 
[[File:SSIS_Install_Location.png|link=]]




===License Information===
===License Information===
4. Enter your license key, or continue with the install and enter your license key later.
2. Enter your License Key, or continue with the install and enter your License Key later.


[[File:SSIS_Install_License.png|link=]]
[[File:SSIS_Install_License.png|link=]]
Line 135: Line 100:


===Component Selection===
===Component Selection===
5. Select which components to install.
3. Select which components to install.


[[File:SSIS_Install_Components.png|link=]]
[[File:SSIS_Install_Components.png|link=]]


 
Click '''Next''' to continue.
===Start Menu Folder===
6. Choose whether or not you want a Start Menu Folder created and if so, where.
 
[[File:SSIS_Install_StartMenu.png|link=]]




===Review===
===Review===
7. Review your installation settings and ensure that everything is as you want it.
4. Review your installation settings and ensure that everything is as you want it.


[[File:SSIS_Install_Review.png|link=]]
[[File:SSIS_Install_Review.png|link=]]
Click '''Install''' to continue.




===Install===
===Install===
8. Wait for the components to install.
5. Wait for the components to install.


[[File:SSIS_Install_Progress.png|link=]]
[[File:SSIS_Install_Progress.png|link=]]
Line 159: Line 122:


===Finish===
===Finish===
8. Once the Data Quality Components are done installing, you will be prompted to finish the setup.
6. Once the Data Quality Components are done installing, you will be prompted to finish the setup.


[[File:SSIS_Install_Finish.png|link=]]
[[File:SSIS_Install_Finish.png|link=]]
Click '''Finish''' to exit Setup.




You are now ready to start using the Data Quality Components for SSIS.
You are now ready to start using the Data Quality Components for SSIS.


==How to Open SSIS==
==Basics==
===How to Open SSIS===
1. To open SSIS please find the version of SQL Server and open SQL Server Data Tools.
1. To open SSIS please find the version of SQL Server and open SQL Server Data Tools.


==Start New Project==
[[File:SSIS_NewProject_Open.png|link=]]
 
 
===Start New Project===
2. Once SSIS loads, Select New Project. Then under Business Intelligence, select integration services and start a new integration services project.
2. Once SSIS loads, Select New Project. Then under Business Intelligence, select integration services and start a new integration services project.


==Data Flow Tab==
[[File:SSIS_NewProject_01.png|link=]]
3. Our components are installed in the data flow SSIS toolbox. You will need to add a data flow task in order to view the toolbox and our components
 
[[File:SSIS_NewProject_02.png|link=]]
 
 
===Data Flow Tab===
3. Our components are installed in the data flow SSIS toolbox. You will need to add a data flow task in order to view the toolbox and our components.
Otherwise you will not be able to see the correct toolbox in which our components are located in. Our components are only visible in Data Flow Tab.
[[File:SSIS_NewProject_DataFlow.png|link=]]
 


[[Category:SSIS]]
[[Category:SSIS]]

Latest revision as of 01:48, 7 January 2023

← SSIS:Data Quality Components

SSIS Navigation
Introduction
System Requirements
Quick Start
SSIS Installation
Subscribe



The Data Quality Components for SSIS can either be installed fully on-premise or as a web only install. The following sections will detail the install size, delivery method, data required, and install procedure.


Full On-Premise Install

Size
~7GB
Deliverable
Physical Disk or Downloadable Zip File (DQC-SSIS_YYYYMM.zip)
Data
Installs all necessary data files for components that have an option for On-Premise Mode.
Component Mode
Contact Verify Both (Web and Local)
IP Locator Both (Web and Local)
Global Verify Web Only
Personator Web Only
Smart Mover Web Only
Property Web Only
MatchUp Local Only
Fuzzy Match Local Only
Profiler Local Only

Web Only Install

Size
~150MB
Deliverable
Download Only (setup-web.exe)
Data
Installs only the minimum set of required data files.
Component Mode
Contact Verify Web Only (Local not Available)
IP Locator Web Only (Local not Available)
Global Verify Web Only
Personator Web Only
Smart Mover Web Only
Property Web Only
MatchUp Local Only
Fuzzy Match Local Only
Profiler Local Only

Install Procedure

To install, download and run the Data Quality Components Executable.

License Agreement

1. Read and accept the license agreement.

Click Next to continue.


License Information

2. Enter your License Key, or continue with the install and enter your License Key later.


Component Selection

3. Select which components to install.

Click Next to continue.


Review

4. Review your installation settings and ensure that everything is as you want it.

Click Install to continue.


Install

5. Wait for the components to install.


Finish

6. Once the Data Quality Components are done installing, you will be prompted to finish the setup.

Click Finish to exit Setup.


You are now ready to start using the Data Quality Components for SSIS.

Basics

How to Open SSIS

1. To open SSIS please find the version of SQL Server and open SQL Server Data Tools.


Start New Project

2. Once SSIS loads, Select New Project. Then under Business Intelligence, select integration services and start a new integration services project.


Data Flow Tab

3. Our components are installed in the data flow SSIS toolbox. You will need to add a data flow task in order to view the toolbox and our components. Otherwise you will not be able to see the correct toolbox in which our components are located in. Our components are only visible in Data Flow Tab.

Retrieved from "http://wiki.melissadata.com/index.php?title=SSIS:Installation&oldid=19287"