this service imports a text file, donor.txt and imports the first and last names into the person table. Before you start make sure you save the Donot.txt file as unicode.
1. Start Visual Studio
2. Go to File, New Project, and then choose Integration Service Project.
3. Cancel the wizard.
4. In the Control Flow Designer window add a dataflow task object from the toolbox
5. Double click it, or click on the Data Flow Tab
6. Add a Flat file Data Source object from the tool box
7. Double click it to get the properties
8. Give the Flat file manager a name, "DonorFlatFileManager" or something
9. Browse to the file Donor.txt
10. Click the check box for first row contains headings
11. Check the preview to make sure you got all the data
12. Now add a new OLEDB Destination object from the toolbox
13. Click on the Flat File Source and connect the green arrow to the destination box
14. Double Click the OLEDB destination object to get the properties
15. Make a new connection manager. It will pop up a dailog
16. Set the server as Localhost, the database as CommunityAssist.
!7. From the drop down list for tables choose Person.
18. Check the column Mappings to make sure that they are correct
19. Run the pagage by going to the menu Debug and choosing run
20. The objects should turn green for success, red for failure
21. If they are red, look at the error messages and correct
22 If they are green, check the database to make sure that it added the records to Person
No comments:
Post a Comment