Yesterday I started to get the error while running SSIS package in deevelopment environment. It was working day before with no issue. I tried to change connection provider types, tried to use connection in Data Sources, played with connection parameters
in advanced section, but nothing seems to resolve the issue. I tried to run package on development environment from other developer's PC, tried to create brand new package with one SQL task, tried running package on the server from BIDS, bot nothing works.
The only thing that worked was changing type of connection from SQL Authentication to windows while running on server. This is not an option, though per company policy.
Can anybody help?
View Complete Post