April 10, 2019 at 2:04 pm
I created and saved an SSIS package. On the "Control Flow" screen, I would expect to see a "Run" or "Execute" button, so I can manually run the package & test the results.
Is there such an option ?
April 10, 2019 at 8:47 pm
If you developed the package as part of a solution, there will be a run button in the ribbon at the top, or in the debug menu.
If you create/modify a package outside of a solution, then this will be replaced by a button labeled "Attach to process". This will try to attach the package execution to a process on the machine (you select which one). I am not sure what the implications are of attaching the SSIS package execution to one process or another would be (especially when it comes to the 32/64-bitness of the process you are attaching to).
April 11, 2019 at 1:32 pm
Seems strange not to have a "RUN" button inside a stand-alone package.
April 11, 2019 at 5:18 pm
I created and saved an SSIS package. On the “Control Flow” screen, I would expect to see a “Run” or “Execute” button, so I can manually run the package & test the results.
Is there such an option ?
How did you create the package? Was it created in Visual Studio - or through SSMS import/export?
What version of SSDT are you using?
You should be able to right-click the object and execute that task. If there are multiple tasks you want to execute like this - then place them in a sequence container and execute the sequence container.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply