etl.laptop (9/26/2013)
I made a practice problem for myself - Using SSIS, make a package to load data from text files located on a Server P, load these files into a table in Server Q. Can I also run this package from a third Server R ? Or should the package be run from Server Q itself because that is where the destination tables are.Main task - It is easy to load it from my local machine. But, how do I load text files from a different server, i.e not on my system which has the SSIS ?
The only restriction you could have is when you use the SQL Server Destination. This component can only be used when the SSIS package is run on the destination server. All the more reason to avoid it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP