Viewing 15 posts - 16 through 30 (of 54 total)
Is there any additional logs generated when SSIS package would be running? I mean generic logs not error handling that would be added to the package itself
January 23, 2023 at 11:48 am
Sql services are using built in account so NT service\mssqlserver, nt service\sqlserveragent and nt service\msdtsserver140
Ssis package is being ran using the SQL agent account. The job owner was using a...
January 19, 2023 at 3:07 pm
Should it just be the SQL agent account or SQL service and SSIS account?
January 19, 2023 at 2:32 pm
Do you know specifically what folder locations? I have given to SQL server program files folder. Should it have any access to files on C drive like C:\Windows?
January 19, 2023 at 2:31 pm
Should the account need access to any folders relating to SQL services specifically?
January 19, 2023 at 1:08 pm
NT Service\SQLSERVERAGENT
This is what is was using on the old server
I tried with proxy account is well but didn't make a difference
January 19, 2023 at 10:32 am
I select Type SQL Server integration Services Package. Then for package source choose file system and provide the location of the package
January 18, 2023 at 8:16 pm
It is running as a SQL job. This is the way it was running on the previous server so would prefer to use SQL agent than windows task
January 18, 2023 at 6:34 pm
Ok so the only possible issue is permissions are missing somewhere?
I have checked the file using notepad and any locations mentioned I have given full control so I am lost
January 18, 2023 at 2:48 pm
I have given the account all the access it should require but still getting the 3 errors
January 18, 2023 at 12:26 pm
No, I presume when I move a package from one server to another it should work when the SQL version isn't changing
January 18, 2023 at 11:57 am
I thought once the account is in the local admins group for the server it should have all the required access to SQL directories iswell
January 18, 2023 at 11:57 am
I provided the account with explicit permission but still the same errors
January 17, 2023 at 3:02 pm
User is part of the local admin group of the server so should have all the access
January 17, 2023 at 12:36 pm
Yes it works when you script it
January 22, 2020 at 3:10 pm
Viewing 15 posts - 16 through 30 (of 54 total)