• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

Importing fields split/combine

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.
sheet.xls
destable.JPG
0
minglelinch
Asked:
minglelinch
1 Solution
 
DcpKingCommented:
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.

hth

Mike
0
 
minglelinchAuthor Commented:
Thanks for the comments.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now