roadrunnerlenny
commented
4 years ago HI @actuarysailor ,
sorry to hear that you are stucked with creating your own task. Unfortunately I am not working with SSIS anymore. The last code I wrote for SSIS was with Visual Studio 2012, and I haven't really followed-up on the changes Microsoft did in the last couple of years. So I can't really help you out there. The only thing that I remember was that SSIS and the toolbox is kind of picky with custom written tasks - I remember that it was only working when using the correct public key when compiling the dll. Look at the code here: https://github.com/roadrunnerlenny/ssiswaittask/blob/af0632d1a104a0e7bbaa58561bf4afb911329beb/ssiswaittask/WaitTaskMain.cs#L14-L29 There is a public key in the attribute. Also, I did some work to create a key file (key.snk). If this wasn't set up properly, SSIS didn't throw an error but just didn't display the task in the toolbox. But this is only an guess, I don't really have a clue what is going wrong here or how things have changes with newer Visual Studio versions.
I mainly downloaded yours to test mine, but that said I have the same issue with both.
Here is what I have done: 1) Install in GAC, and verify it is there 2) Copy to the DTS Task folder locations in Program Files 3) Verify the item is visible in SSIS Toolbox. 4) If I create task from toolbox, it is stored in the SSIS package and the menu’s work.
Issue: When SSIS runs, it just simply says it failed to load task. If I attach the debug handler to the DTS managed host, it get’s me no where... I mean I can put break-points on every method entry etc. for the task, and it’s like the SSIS package just fails to get it.
Next Steps: I am planning to just try this on a different machine and see if I have the same issue.