I have a similar issue. I have a stored proc which creates sql dynamically and I have no idea which columns will be returned.

I need to create a report...

No, public did not work without creating a user in the target db first, which is what I am trying to avoid.

Perfect!!

I was able to install my CLR functions into a db called Library and then use these scripts to enable having all users call the functions without needing to create...

Althout that solution will work, it still would require one to add every user created (even in the future) to that group. Is there any way to allow all...

Ok, I have figured out how to do this.

For some reason the Microsoft.SqlServer.DTSRuntimeWrap assembly was installed in the GAC and the dll was deep in a GAC folder which you...

Ok. I have figured out (though not sure I understand why it is this way) that in a script task for some reason you can not reference the wrapper...

How can I view the security log? This is on a file server.

I did run FileMon while running the package and was very surprised to see the amount of...

I am now able to view that there is a package in the db with the name given, but I can not figure out how to view the package.

I want...

Perfect! Thank you.

I am having the same issue. I have created an SSIS package using the import data to import data from a flat file and have opted to save it...