Call us at (717) 735-9109, or email at support@rklesolutions.com
There are many times that exchanging data with other systems in the supply chain might be done via text-based files (such as ASCII files, CSV files, and more). Sometimes it is to make the pertinent data available to external systems—like Microsoft® .
Continue reading
I was working through a request from a customer to import an excel spreadsheet into SQL Server on a recurring basis. I decided to create an SSIS Package to accomplish this and then call the package from a job in SQL Server Agent. However, when I ran .
Continue reading
There is often a need for end-users to run SQL Jobs on an ad-hoc basis. This creates a security issue because we don't want to install SQL Server Management Studio on the end-user workstation and we don't want to give out Remote Desktop access to .
Continue reading
