I have an issue to execute the package in SSMS SSISDB catalog, it failed to open UNC path file share.

I searched and some said the server has to be setup...

Thanks, found the maintenance job, I will certainly change it to fewer than 365 days.

For logging, I see in package design view, you can still design a log file to...

So I guess can view the results from report or more advanced to query the SSIS db.

Then what is that output file on the advanced tab?

Also I guess the database...

Thank you.

With this limitation, it seems I cannot use much the feature that runs package in SSISDB catalog context. But I can do it in SQl agent.

I really do not...

I take it back, thanks for your patience.

I tried again with SQL agent job using SQL service account, it works this time.

But if I run it in SSISDB catalog, which...

I tried using SQL agent job. Get the same error.

If I run the package in package deploy mode that I saved on the file system, I don't have problem.

I just...

I have spent a lot of time to convert packages from package deploy mode to project deploy mode, and only find this is not working for UNC path, and it...

At this time, there is no front end web server or application involved. This is mainly used for some database/data manipulation and reports and preparation for state reports that related...

I should make it a little clear. For most of our databases we have a centralized db server and a separate reporting server for example in our IT department....

Thank you Alan.

The edition we are going to use is Standard, I guess in-memory is not available, but sounds like 32 bits still is a good and appropriate choice.

Thanks,

The server will be a VM not physical. The host will be on SAN disks for data, log, backup drives.

I plan to put on a 8 core, but 16 GB...

I will put CPU thing on another research.

But for implementing and upgrading to new environment, just want to know to put ssis on a separate server or on the ETL...

Thanks for all the tips, they are helpful

When you say BI server, does that mean it hosts all the data warehouse databases?

Still not clear which way I should go?

We can buy another license. just not sure what is the best option to go:

And for now we consider all use physical servers...