February 17, 2016 at 8:30 am
I need to export the results of a stored procedure, text file, to another server on our network. Any thoughts?
February 17, 2016 at 9:46 am
NineIron (2/17/2016)
I need to export the results of a stored procedure, text file, to another server on our network. Any thoughts?
Sure, sounds easy enough. What problems are you envisaging?
February 17, 2016 at 9:50 am
Pardon my ignorance but, I don't know much about SSIS. Is FTPing a choice in the wizard when I set it up? Could you point me to a decent tutorial on the subject?
February 17, 2016 at 4:12 pm
You can use an FTP task in SSIS. You might want to look at Brian Knight's book. Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
It covers the basics of SSIS.
February 18, 2016 at 4:04 am
Thanx.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply