July 9, 2009 at 8:57 am
I'm currently taking on the position of "default" DBA at my organization. We are trying to send data to another company and I'd like to know what all the options are. We need to send a small amount of data to this company on a daily basis SQL 2005 - SQL 2005.
1. Create SSRS report, schedule it to send a .CSV file to email. I think this would be the easiest approach from our end.
2. Create a SP and use web service to push the data?
3. Push data to FTP site using SSIS?
4. Replication?
I'd like to know what the experts do. Any help would be much appreciated.
July 9, 2009 at 9:08 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic750332-361-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply