Index and length must refer to a location within the string. Parameter Name: length (mscorlib)

Today, I used SSIS to create a small Excel extraction program. The following error occurs during the preview Excel Data:

 

There was an error displayingthe preview.Additional information:

Index and length must refer Toa location within the string. Parameter Name: length (mscorlib)

 

 

 

The reason for this error is that the Excel sheet name is incorrect. The solution is to modify the Excel sheet name. Therefore, when using SSIS to parse the Excel Sheet Name, follow the following rules:

 

1. Make sure that the Excel sheet name is not too long.

 

2. Do not enter spaces before or after the name

 

3. Do not include special characters such as "&" % ".

 

After the Excel sheet name is modified, the data can be properly preview.