We have a web app that maintains data in a SQL server database. We need to
run a monthly job that processes this data (complex logic) and then outputs
the contents of several resulting tables to an FTP server. This FTP data is
then sucked into an Orable application and processed. We need a second
monthly job that reades the Oracle return codes (to see if the data was
processed corectly) and updates the SQL server tables with information about
what was processed.
Can an SSIS package handle these types of operations and what is the best
way to set this up?

On Jun 9, 8:43 pm, mscertified <rup... (AT) tigerlily (DOT) com> wrote:
Of course it does.
I haven't been working with SSIS for a long time, but with the
information you provided i'd create two packages: the first that
process and send to Oracle, the second that retrieves from Oracle and
update you're master DB.
In SSIS (this is new in respect of DTS) there's a specific task for
FTP commands (send, retrieve, create/delete dirs, etc) so you can
accomplish file sending with it.
If you have to connect directly to Oracle DB, i believe that you must
have installed Oracle client in the machine on which the package will
run in order to successfully connect.
There's a plenty of ways to accomplish data processing. The easisest
(for me) is oledb command, oledb source and so on.

Bye,
Matteo

On Jun 9, 8:43 pm, mscertified <rup... (AT) tigerlily (DOT) com> wrote:
Of course it does.
I haven't been working with SSIS for a long time, but with the
information you provided i'd create two packages: the first that
process and send to Oracle, the second that retrieves from Oracle and
update you're master DB.
In SSIS (this is new in respect of DTS) there's a specific task for
FTP commands (send, retrieve, create/delete dirs, etc) so you can
accomplish file sending with it.
If you have to connect directly to Oracle DB, i believe that you must
have installed Oracle client in the machine on which the package will
run in order to successfully connect.
There's a plenty of ways to accomplish data processing. The easisest
(for me) is oledb command, oledb source and so on.

Bye,
Matteo

On Jun 9, 8:43 pm, mscertified <rup... (AT) tigerlily (DOT) com> wrote:
Of course it does.
I haven't been working with SSIS for a long time, but with the
information you provided i'd create two packages: the first that
process and send to Oracle, the second that retrieves from Oracle and
update you're master DB.
In SSIS (this is new in respect of DTS) there's a specific task for
FTP commands (send, retrieve, create/delete dirs, etc) so you can
accomplish file sending with it.
If you have to connect directly to Oracle DB, i believe that you must
have installed Oracle client in the machine on which the package will
run in order to successfully connect.
There's a plenty of ways to accomplish data processing. The easisest
(for me) is oledb command, oledb source and so on.

Bye,
Matteo

On Jun 9, 8:43 pm, mscertified <rup... (AT) tigerlily (DOT) com> wrote:
Of course it does.
I haven't been working with SSIS for a long time, but with the
information you provided i'd create two packages: the first that
process and send to Oracle, the second that retrieves from Oracle and
update you're master DB.
In SSIS (this is new in respect of DTS) there's a specific task for
FTP commands (send, retrieve, create/delete dirs, etc) so you can
accomplish file sending with it.
If you have to connect directly to Oracle DB, i believe that you must
have installed Oracle client in the machine on which the package will
run in order to successfully connect.
There's a plenty of ways to accomplish data processing. The easisest
(for me) is oledb command, oledb source and so on.

Bye,
Matteo

On Jun 9, 8:43 pm, mscertified <rup... (AT) tigerlily (DOT) com> wrote:
Of course it does.
I haven't been working with SSIS for a long time, but with the
information you provided i'd create two packages: the first that
process and send to Oracle, the second that retrieves from Oracle and
update you're master DB.
In SSIS (this is new in respect of DTS) there's a specific task for
FTP commands (send, retrieve, create/delete dirs, etc) so you can
accomplish file sending with it.
If you have to connect directly to Oracle DB, i believe that you must
have installed Oracle client in the machine on which the package will
run in order to successfully connect.
There's a plenty of ways to accomplish data processing. The easisest
(for me) is oledb command, oledb source and so on.

Bye,
Matteo

On Jun 9, 8:43 pm, mscertified <rup... (AT) tigerlily (DOT) com> wrote:
Of course it does.
I haven't been working with SSIS for a long time, but with the
information you provided i'd create two packages: the first that
process and send to Oracle, the second that retrieves from Oracle and
update you're master DB.
In SSIS (this is new in respect of DTS) there's a specific task for
FTP commands (send, retrieve, create/delete dirs, etc) so you can
accomplish file sending with it.
If you have to connect directly to Oracle DB, i believe that you must
have installed Oracle client in the machine on which the package will
run in order to successfully connect.
There's a plenty of ways to accomplish data processing. The easisest
(for me) is oledb command, oledb source and so on.

Bye,
Matteo

On Jun 9, 8:43 pm, mscertified <rup... (AT) tigerlily (DOT) com> wrote:
Of course it does.
I haven't been working with SSIS for a long time, but with the
information you provided i'd create two packages: the first that
process and send to Oracle, the second that retrieves from Oracle and
update you're master DB.
In SSIS (this is new in respect of DTS) there's a specific task for
FTP commands (send, retrieve, create/delete dirs, etc) so you can
accomplish file sending with it.
If you have to connect directly to Oracle DB, i believe that you must
have installed Oracle client in the machine on which the package will
run in order to successfully connect.
There's a plenty of ways to accomplish data processing. The easisest
(for me) is oledb command, oledb source and so on.

Bye,
Matteo

On Jun 9, 8:43 pm, mscertified <rup... (AT) tigerlily (DOT) com> wrote:
Of course it does.
I haven't been working with SSIS for a long time, but with the
information you provided i'd create two packages: the first that
process and send to Oracle, the second that retrieves from Oracle and
update you're master DB.
In SSIS (this is new in respect of DTS) there's a specific task for
FTP commands (send, retrieve, create/delete dirs, etc) so you can
accomplish file sending with it.
If you have to connect directly to Oracle DB, i believe that you must
have installed Oracle client in the machine on which the package will
run in order to successfully connect.
There's a plenty of ways to accomplish data processing. The easisest
(for me) is oledb command, oledb source and so on.

Bye,
Matteo