Development of a SSIS 2012 package
- or -
Post a project like this2955
$$
- Posted:
- Proposals: 1
- Remote
- #1062402
- Awarded
Description
Experience Level: Intermediate
General information for the business: Consultancy
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: On a weekly basis we get 100+ pipe delimited, with " as a text qualifier, csv files - some empty and some containing 500,000+ rows. We would like for someone to generate a SSIS package that would iterate through a folder of files and upload all these to our SQL Server instance. Ideally to simplify this each file would be uploaded to a database in a table that was made up of its name (minus the .csv) and the date. It would be good if an additional field counting the rows and the date of import could also be added.
We are most interested in the iterative process and as we are not able to provide the actual files will need the person doing this to generate 10 files of varying sizes to show it works. We have sufficient skills in-house to change the variable pointer to our folder with the files and also to reconfigure the data connection to point at our server.
I am not able to provide the actual files but could
Extra notes:
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: On a weekly basis we get 100+ pipe delimited, with " as a text qualifier, csv files - some empty and some containing 500,000+ rows. We would like for someone to generate a SSIS package that would iterate through a folder of files and upload all these to our SQL Server instance. Ideally to simplify this each file would be uploaded to a database in a table that was made up of its name (minus the .csv) and the date. It would be good if an additional field counting the rows and the date of import could also be added.
We are most interested in the iterative process and as we are not able to provide the actual files will need the person doing this to generate 10 files of varying sizes to show it works. We have sufficient skills in-house to change the variable pointer to our folder with the files and also to reconfigure the data connection to point at our server.
I am not able to provide the actual files but could
Extra notes:
Peter V.
97% (6)Projects Completed
6
Freelancers worked with
6
Projects awarded
50%
Last project
10 Sep 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies