this is the file task

Once I change the loop retrieve file name to fully qualified it loads the file but the file task doesn't work.

I got it working using the Kingsway excel connector. The Microsoft excel connector wont accept the metadata.

Thanks for the replies.
I am still unable to connect to the excel xlsx files, These are being generated by IBM TM1. If open and save the excel file...

I worked it out, both the source folder and source file variables have to resolve before running in the loop. So run the file variable with a file before adding...

The first thing I have done is find the rows where there are multiple brackets, so there is a odd number.

            
September 6, 2017 at 6:48 am
            
#1958333

            
            
                                                
        

I found a way to do the like in the join that appears to be working.

UPDATE #temptitle3
     SET SupplementaryInformation = SUBSTRING(Title,CHARINDEX('(',Title),LEN(Title))
     FROM #temptitle3
     JOIN @textsvalueBG...

I think the problem is the IN it needs to be a IN Like from title to %val%. How do I make it a like?

UPDATE...

I have written a Cursor, but the same issue is happening, columnid is not increasing by 1 each time through the loop. Any suggestions?

DECLARE @ColumnID...

Thanks for the reply.
Unfortunately your row_Number() returns the same as when I tried to use it, which is why I switched to trying using a while loop. The Row_Number()...

I do want the 100, but it doesn't work it gets syntax error?

I finally managed to resolve the required format issue.

I built two tables one for the headers row VCR\CCR and one for lines BTP\CTD. If you are interested they were...

Apologies for the bad format, attached is the DDL & DML Statements.

Insert statements;

INSERT INTO [dbo].[VehicleAnalysisVCR]

([VCRRecType]

,[VCRCustNo]

...