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
Author
Message
Posted Friday, March 15, 2013 3:16 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:41 PM
Points: 1,770, Visits: 3,202
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.

Thanks,
Post #1431788
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse