question

Amele avatar image
Amele asked

Data type change SSIS.

I am using for each loop container to read excel files and move them to an archive folder, but I forgot to create an archive folder and SSIS automatically move the excel files to .file format, and I couldn't open the file type file. what should I do? Thanks in advance.

replacefilessis excelformattype
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Lukasz8519 avatar image
Lukasz8519 answered

you should try to change extension of this file to .xlsx

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.