SSIS package is executing locally using SSDT but failing to execute any thing from Server
-
Hi all, I have an SSIS package that is executing when I am running from my Local machine using SSDT, but when I am executing using .Net Package.Execute call, its not even touching anything, I tried putting logging within Script tag and many ways, and for same Variables when I set manually and execute from SSDT it executes fine. Any idea helps me man, our deployment depends on this execution, spent a lot of time to understand what's missing, I am using Impersonation, for a file reading etc, its not a complex logic too, just read from db and file puts the file bytes into the db. No error, when I see Package.Execution status gives success but nothing happens in the back-end. Any idea helps me friends, please. If I run manually using SSDT script runs fine just when I am running it from the .Net code.
Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."