How to convert transfer data from cvs file to table using SSIS package?
I have csv file in my network shared folder so i need to transfer all those csv file to table in DB..
csv file
Data.csv
Zone Employee EmpID Date
North Alarcon, Vanessa 1425114 20140502
North Appelgren, Richard 1425144 20140502
North Appelgren, Richard 1425144 20140502
North Austin, Benjamin 1425042 20140502
Data(table in sql db)
When i am reading from csv file i am unable to read full name of employee column from csv file because employee full name was separated by a column.How can i fix this problem ??And date column in csv file is in different format how can i fix this and get in 2/5/2014 format.?
Can you please help me guys??
csv file
Data.csv
Zone Employee EmpID Date
North Alarcon, Vanessa 1425114 20140502
North Appelgren, Richard 1425144 20140502
North Appelgren, Richard 1425144 20140502
North Austin, Benjamin 1425042 20140502
Data(table in sql db)
When i am reading from csv file i am unable to read full name of employee column from csv file because employee full name was separated by a column.How can i fix this problem ??And date column in csv file is in different format how can i fix this and get in 2/5/2014 format.?
Can you please help me guys??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes i fixed the problem but while converting to date format i am getting error :(
Hey,
Thanks for the points and comments. I appreciate it.
Have a wee look here for the date conversion thing in SSIS...
http://blogs.msdn.com/b/mattm/archive/2010/08/04/string-to-date-conversion.aspx
(I must admit, I generally pull all the csv stuff in to a load table, all raw, warts and all. Then I clean it up with a SQL statement so, for this I'd Convert the date in SQL rather than SSIS).
T
Thanks for the points and comments. I appreciate it.
Have a wee look here for the date conversion thing in SSIS...
http://blogs.msdn.com/b/mattm/archive/2010/08/04/string-to-date-conversion.aspx
(I must admit, I generally pull all the csv stuff in to a load table, all raw, warts and all. Then I clean it up with a SQL statement so, for this I'd Convert the date in SQL rather than SSIS).
T
ASKER