In order to follow the steps as indicated, you will need access to a table in a database on the SQL Server 2005 as well as knowledge of the nature (format) of the file and its location.
The following are the major steps in this exercise:
Use/create a flat text file whose contents need to be transferred.
Create a SQL Server database table with columns that can accept the contents of the file created in the previous step.
Create a BI Project and add a Bulk Insert Task.
Configure the Bulk Insert Task.
Build and execute the package.
Normally, this file should be available, as this is the ...