Importing fields split/combine

Posted on 2012-09-18
Last Modified: 2012-09-25
I need to import an excel sheet data into a table. See the attached files.

Let me take the first 2 rows in Excel sheet as example. I have two places need help.  

1. Imported dest table requestid field should be REQ120810-092 (format: REQYYMMDD-Log#, YYMMDD is the Date field in excel row.)

2. Split period & time columns in sheet and import in dest table as starttime & endtime  fields with the format.

How can I achieve the above two tiems? Thanks.
Question by:minglelinch
    LVL 16

    Accepted Solution

    You can use SSIS to pull the Excel data into a table, probably as all strings. Once that works, start playing with the SSIS to create derived columns from the first two fields that contain your digits in the correct sequence.

    BTW, I should tell you that combining several pieces of data into one field is considered fundamentally bad practice.


    LVL 1

    Author Closing Comment

    Thanks for the comments.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now