I have a simple package that imports data from an excel file to a 2008 R2 database.
here is a sample of the excel file
54 Siobhan Kennedy Health
22 Peter OChahan Education
31 Ryan Harkins Finance
My table in the database looks like this:
CREATE TABLE [dbo].[Employee](
[EmployeeID] [int] NULL,
[FirstName] [nchar](50) NULL,
[LastName] [nchar](50) NULL,
[Department] [nchar](50) NULL)
I want to import the data into the database, splitting the name column into firstname and lastname using the SSIS package.
So far (on the data control tab) I have an 'Excel Source' Box and an 'OLE destination' Box.
I think i need to pick an option from the 'Data Flow Transformations' menu in the toolbox. Is this correct?
View Complete Post