Home Forums SQL Server 2005 SQL Server 2005 Integration Services Extract number,Month name and year from file name RE: Extract number,Month name and year from file name
michal.lisinski
SSCertifiable
Points: 6933
More actions
October 16, 2015 at 6:33 am
#1833773
Hi
Forgive me, I'm very busy today and the first impulse that comes to mind:
//string Month = ls[5];
string m = ls[5];
//month name to int
int NoM = DateTime.Parse("1." + m + " 2015").Month;
Be careful - not tested.
Br.
Mike