Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSIS format grade level Expand / Collapse
Posted Friday, March 15, 2013 3:16 PM


Group: General Forum Members
Last Login: Friday, November 20, 2015 12:04 PM
Points: 1,871, Visits: 3,520
I have an excel file with student records, I would like to create an SSIS to import them into SQL table.

I have a question for a column GradeLevel.

The format is P, K, 01, 02, 03,...11,12.

The source file we received about this column most of time are in the correct format.
But sometimes, they omit the leading 0, so instead of 01-09, they show up like 1-9.

How can I use an expression in SSIS to format this column to 01-09 no matter they send us the correct or wrong format, and also keep other grade levels like P,K, 10-12.

Post #1431788
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse