Excel File Destination

jn93 651 Reputation points
2023-03-07T06:47:55.05+00:00

Hi All,

I have SSIS DB source connected produce data in excel file destination. Before load in the data, I have Exceute SQL task to create table under connection type EXCEL. Why do my SSIS is failing to in create table task? I have setup a dynamic file which for excel file path:D:\ and excel version number:4. When I try run it give me error connection manager not set properly or permission error. I think I don't have the permission error since I can move file using file system task. Any other thing I should check

Error Message:

User's image

SSIS:

User's image

User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. jn93 651 Reputation points
    2023-03-09T01:18:03.3033333+00:00

    Hi @ZoeHui-MSFT I can run after install distribute inside my local machine.

    1 person found this answer helpful.
    0 comments No comments

  2. Olaf Helper 40,656 Reputation points
    2023-03-07T07:03:04.2366667+00:00

    Why do my SSIS is failing to in create table task?

    You haven't posted any error message so it's impossible to guess.

    Please provide more details, complete error message and more informations.


  3. ZoeHui-MSFT 32,506 Reputation points
    2023-03-08T02:48:16.5666667+00:00

    Hi @jn93,

    I could re-produce the issue as shown below.

    User's image

    I found that my excel is read-only so that the package fail, you may also double check the excel or create a new excel file for a try to see if the issue is occurred by the special file.

    If this do not work, try to set Runas64Bit project property as TRUE. 

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments