I've SQL Server 2005 and I want to move online data to reporting database server on daily basis.
So, I want to use Integration Services option i.e.
> I'll export data into flat files from online database through SQL Server Agent
> Then I'll place those flat files on FTP server
> Then same kind .dtsx package will be created on reporting database server.
> On this, first, flat files will be downloaded from FTP server
> Then it will be imported on reporting database server.
The question is that....
What is the requirement (Software/Network) for SSIS implmentation, advantages and disadvantages also?