Đang chuẩn bị liên kết để tải về tài liệu:
beginning microsofl sql server 2008 programming phần 9

Chúng tôi sẽ không đi vào chi tiết thực sự về điều này, bởi vì các tùy chọn có sẵn sẽ khác nhau tùy thuộc vào các nguồn dữ liệu đặc biệt OLE DB mà bạn đã chọn. Thật vậy, các điểm thực sự của thời điểm này chỉ là: SSIS sẽ làm thay đổi hộp thoại để cung cấp cho | Chapter 18 Getting Integrated with Integration Services We re not going to go into real detail on this because the options available will vary widely depending on the particular OLE DB data source you ve selected. Indeed the real point of the moment is just that SSIS will alter the dialog to give you contextual choices that are relevant to the particular OLE DB data source you re using. In the preceding example I ve simply clicked the Column names in the first data row option and it s time to click Next again. This takes us to choices for selecting what data we want out of our source database. We have two choices here Copy This has us do a straight copy out of a table or view. Query This allows us to select out of pretty much any operation that s going to yield a result set. Let s start by taking a look at the Query option. If you choose this option and click Next you get yet another dialog this one pretty boring in the sense that all it does is give you a box where you can enter in the text of your query. See Figure 18-5. Figure 18-5 In my example here I ve shown where we could be setting up to export a list of employees that we hired in our first month of business. If you want to test this you can type the query and then try testing it with the Parse button to make sure that the query you want to run is syntactically valid or you can copy it into a query window in the Management Studio and test it there. Then click Next to get to the dialog box shown in Figure 18-6. 547 Chapter 18 Getting Integrated with Integration Services Figure 18-6 For starters this sets us up to decide what we want our flat file to look like. I can easily change the row delimiter. For example if you re exporting for use in a Linux or UNIX based system you may want to choose just a line feed rather than the line feed carriage return option. You can click Preview to see whether your query looks like it s going to return the data that you expect. See Figure 18-7. Figure 18-7 Click OK and you .