Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

Try It



33

FIGURE 413

30. Click New next to the drop-down list labeled “Flat File connection manager.”

31. Select Delimited from the Flat File Format screen that appears. Click OK.

32. Then the Flat File Connection Manager will appear.

33. Click Browse and select a directory on your computer where the flat file will reside. Name the

file FullName.txt.

34. Accept all the defaults and click OK.

35. Back on the Flat File Destination Editor click Mappings, located at the top left of the screen.

36. Ensure that each column is mapped accordingly, for example, FirstName to FirstName.

Click OK.

37. Right-click the package in the Solution Explorer and select Execute Package.

889633c04.indd 33 8/16/10 9:13:48 PM

34



LESSON 4 Understanding ssis

38. When the package is complete it will resemble the screen shown in Figure 4-14.

FIGURE 414

39. If you click the Progress tab you can view each individual step that was executed during the

package run.

40. Click the square blue button on the menu bar to stop the package.

41. Browse to the location on your computer that you specified in Step 33.

42. Open the FullName.txt file. The text file should contain three columns, FirstName,

LastName, and FullName, which were derived in the package.

Please select Lesson 4 on the DVD to view the vid ...