March 14, 2018 at 11:37 am
I have not had to use this at my place of work. I've only used SSRS with my TSQL stored procedures. Forgive my question if it seems very elementary. I'd like to know if SSIS could be used for a task like the following:
schedule a stored procedure to run daily
save the results of the stored procedure in an XML file
transfer the XML file to sharepoint or another specified location
Right now I do all of this manually (which is ok for now) and it will need to be automated. The XML File(s) are to be used for QlikSense.
Also, it would be helpful if someone can point me to good SSIS training material or suggest professional training.
Thanks in advance.
March 15, 2018 at 6:51 am
Scheduling the run of the stored procedure is something you do using a SQL Agent Job. The SQL Server Agent Service runs under the security context of its "service account", which must then have write permissions for the folder location you want to place the XML file in. If you can use BCP, you probably won't need SSIS to do this. Look up BCP.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply