I am using SSIS (SSDT 2017)

Thanks, that has been resolved by firewall rules

I have 64 bit(as part of Office 365) and also 32 bit(AccessDatabaseEngine.exe)

I have deployed to SSISDB and executed from there. Surprisingly, it has executed successfully.

Why is this problem in VS?

Yes, I am running from VS

It is working until yesterday. Nothing changed in the package

Hi,

Issue fixed. I have installed Office 2010 redistributable 32 bit at command prompt with /passive switch

Working now

Thanks

Actually the error is "Could not load table information" So, in the Excel source, table dropdown, no tables displayed.

Hi Friends,

Thanks for the replies. Both solutions worked for me

Hi all,

Thanks. CAST to decimal has worked.

Hi Kevin,

Thanks for the reply.

What are technical analyst's roles and responsibilities.

Thanks

Hi All,

A quick question. I was told to develop data structures for the new datawarehouse. Which tools I can use?

What is the process?

Hi all,

Thanks you very much.

Hi,

Thanks for the reply. It is a straight load.

We have very big datawarehouse. So, we want to reduce the time it runs.

Hi,

Thanks for the reply. It helped me a lot.

Hi

Thanks for the reply. I resolved it. It is just a caching problem.