I am creating a Data Transformation Servics Package that will modify some data that is imported from text files. to import the text files into tables in the database I will use the Bulk Insert DTS task. There are two files that will be imported into 2 tables (1 table for each file).
I need to have 1 format file create for each file so that I can select the format file in the Bulk Insert task. I have attached a sample of the text files that will be imported as well as a SQL file containing the table that each of these files will be imported to. I only require the format file that will allow the data from the text files to be successfully imported into the tables. I strongly prefer bidders with some SQL DTS experience and who have worked with Bulk Insert taska dn created format files in the past.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
SQL Server 2000