Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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