How to Use Business Intelligence Server OLEDB Command Data Flow Transformations
Data transformations import data from one database to another, but you must configure the transformation in your Business Intelligence Server to make the transformation. The OLEDB drivers perform the data flow transformations, and the configurations set up how the data is transported. You set up a transformation package on your SQL server to handle the imported data.
Other People Are Reading
Instructions
-
-
1
Open the SQL Server Management Studio software on your database management desktop. Log in to your server and open the transformation package you want to use with the services.
-
2
Click the "Data Flow" tab. In this tab's toolbox, drag and drop a "Data Transformation" icon from the toolbox to the center designer. This creates the step in the designer. Right-click the new icon in the package and select "Advanced Editor."
-
-
3
Type the source and destination database information in the "OLEDB Connection" section. After you create the connection, a list of tables display, so you can set up the transformation service.
-
4
Select a table and table column for each field in the source database. Choose a datatype from the drop-down menu to tell the server how to transform the data. Click "OK" to save the package changes. Click the "File" and "Save" menu item to save it to the package service.
-
5
Close the package in the editor. Right-click it and select "Run" to run the transformation service immediately after making the changes.
-
1
