I want to write code that checks count and properties of files on an SFTP server from SQL Server SSIS package. As far I know the easiest way to do this without scripting is to use CLR in a stored procedure. Being very familiar with C# I can write the code easily but I need to understand deployment.
Do I need a reference to the DB. When I do that I get a gazillion errors. I am also worried about overwriting changes to my DB. I just want to add the new Stored Procedure. Please advice how this is done usually