![sql business intelligence development studio sql business intelligence development studio](https://www.mssqltips.com/tipimages2/2970_img3.jpg)
OLE DB Source editor screen enables developers to preview source data.īI developers can exclude columns from export list in Columns tab by clearing checkbox beside column names or rename the output column nameīy pressing OK buton, the configuration of the OLE DB Source component is complete. It is also possible to define a SQL query as the source of export data task by choosing the "SQL command" data access mode.Ĭontinue the SSIS package source editor by selecting the table or view name I also plan to export all data stored in database table HumanResources.Department, I choose "Table or view" in the "Data access mode". I'm using SQL Server 2008 R2 sample database AdventureWorks2008R2 for the SSIS package tutorial as data source. SQL Server BI developers can easily create new SQL Server data connections for the data source to export to flat file. I will not demonstrate here how OLE DB Source object will be configured for database connection to SQL Server. Let's configure source component as SQL Server for sample SSIS package.Ĭhoose OLE DB Source component from Tools and drag-drop it onto Data Flow designer surface.ĭouble click on OLE DB Source object to configure the data source for reading.
![sql business intelligence development studio sql business intelligence development studio](http://dataeasy123.com/wp-content/uploads/2016/10/postpic8.png)
Since we will directly export data from SQL Server table to text file without any transformation, we will not use any of the Data Flow Transformation tasks.Īs last step, we need to identify the destination component which is the flat file in our sample SSIS package. When you double click on Data Flow Task object on design view a new tab "Data Flow designer surface" will be active to configure data flow task.įirst we'll configure data source component, which is SQL Server database in our SSIS tutorial. Since our aim in this SSIS tutorial is to export data from SQL Server to flat file, we will choose Data Flow Taskĭouble click or drag-drop Data Flow Task object on to the Control Flow surface of the SSIS package in design view. These tools can be configured for solutions of common tasks like bulk insert, executing sql scripts, executing FTP commands, send mail, back up database, rebuilding index, or even shrink database task. On the left side of the Business Intelligence Development Studio, you will see a Toolbox containing tools developed for specific tasks. You can rename it by a right click on the SSIS package and choosing Rename in context menu. The Integration Services project will create a default empty SSIS package titled Package.dtsx under SSIS Packages folder in Solution Explorer window. Name the SQL Server Integration Services project as "SSIS Tutorial". Then choose "Integration Services Project" from Visual Studio installed templates. I've SQL Server 2008 R2 Business Intelligence Development Studio installed on my computer so I'll be working on SQL Server 2008 R2 and its tools for this SSIS example.Ĭreate new SSIS project following BIDS menu options "File > New > Project." Open SQL Server Business Intelligence Development Studio.