I have a scenario where I am getting data from an excel source using excel connection manager. From that excel, I want to get the sheet name and load it into database table. Sheet name format is: ABCDEF - 12345678
From that sheet name, I want to get only "12345678" and want to load it into database table, please guide.
Thanks in advance.