25112
asked on
ssis - create files and move it to another server?
Using SSIS, can you run 2 queries against a database and create 2 csv files as the output of the SELECT statement from SQL Server A, and then move it to a folder in another server (ServerB)?
if yes, what specific tasks in ssis will help for each of the above?
right now I am thinking of using net use & COPY DOS commands to copy the files, but if SSIS makes it more efficient, i should consider it.
thanks.
if yes, what specific tasks in ssis will help for each of the above?
right now I am thinking of using net use & COPY DOS commands to copy the files, but if SSIS makes it more efficient, i should consider it.
thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER