Below is the diagram that takes an excel file and imports into a SQL Database. Along with that is a filepath from a derived column. Inside that filepath contains the jobnumber. Instead of importing the whole path, I just want to extract the Job number wich SUBSTRING (Filepath, 51,12) will work.
I have an OLEDB command that contains the SQL statement to insert (Colum1, column2) values (?,?) into the SQL DB
I understand the SQL Statment using SUBString:
Insert into tableA (Column1, Filepath)
Select Column1, SUBSTRING (Filepath, 51,12) as FilePath from ......
What would be the name of the table that I am selecting from inside the OLEDB Command?