Hello
I've got an SSIS package that displays a database is read-only error (full error below) when running a Truncate table query from a SQL task . The data base is not read only as I can execute the same task successfully from another package.
[Execute SQL Task] Error: Executing the query "TRUNCATE TABLE dbo.MyTableName" failed with the following error: "Failed to update database "mydBName"
because the database is read-only.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.
The properties are the same for each task ...
Am I missing a property setting or something else in the package.
Thanks in advance
Ron