Viewing 4 posts - 1 through 5 (of 5 total)
@frederico_fons & @phil_parkin,
many thanks for your assistance,
it's taken a bit of time to diagnose further as the site was reluctant to touch anything on the server in this holiday period...
December 23, 2024 at 6:40 pm
Thanks frederico_fons
I'm running the package by creating a sql agent job, then adding a job step of type "SQL Server Integration Services Package" with the package located on the file...
December 19, 2024 at 12:57 pm
Hi Phil,
I have created the package with no code - fails. Added the 1 line variable declaration - fails again.
Deleting the script component, then the package works without failure. But...
December 19, 2024 at 8:49 am
Thanks for the suggestion Phil.
I'll try that tomorrow when I can get an administrator to create the SSISDB.
The error message was for the script component. Confusingly, a newly created script...
December 18, 2024 at 8:09 pm
Viewing 4 posts - 1 through 5 (of 5 total)