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
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.