How to fix SQL job and SSIS package error : from when application is not running in userinteractive mode is not valid operation?

Bidyadhar Nayak 0 Reputation points
2023-08-25T08:27:02.0233333+00:00

When I am running a job in SQL server, trying to run SSIS package in job history. Description: showing form when the application is not running in userinteractive mode is not a valid operation.

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,197 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,367 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Bidyadhar Nayak 0 Reputation points
    2023-08-28T13:41:17.5333333+00:00

    The script task issue is database not able to connect through OLEDB connection inside Script task.

    The message box Login failed. Username and password invalid.