Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    Development of a SSIS 2012 package

    - or -

    Post a project like this
    2500
    $$
    • Posted: 7 years ago
    • Proposals: 1
    • Remote
    • #1062402
    • Awarded
    Allen D.
    has already sent a proposal.
    • 1
    • 1

    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:
    Peter V.
    Peter V.
    96% (5)
    Projects Completed
    5
    Freelancers worked with
    5
    Projects awarded
    46%
    Last project
    8 Nov 2017
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

      There are no clarification messages.
    2500
    $$

    - or -

    Post a project like this
    Peter V.
    Peter V.
    96% (5)
    Projects Completed
    5
    Freelancers worked with
    5
    Projects awarded
    46%
    Last project
    8 Nov 2017
    United Kingdom

    Related project Searches


    Microsoft SQLServer database development comma separated values(csv) database management system (dbms) sql server integration services (ssis)

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    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