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.
12,075 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.
14,494 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,676 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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.