forum.venkateswarlu.net
      Register      Login
Purpose and use for running a job

2 replies to this topic

Ravi Kiran #1
Member
14 Points
 Posted on 22 Jul 2013 06:28 PM IST

Currently i involved in one project as Test engineer, I am new to SSIS, I want to know What is the need and purpose of a job, Please le me know ASAP

 
SQL Server     742 views     Reply to this topic
Subramaniam R #2
Member
152 Points
 Replied on 23 Jul 2013 11:47 AM IST

As you working with SSIS (SQL Server Integration Service) job is main role for moving the data from source to destination.

Suppose your company wants to get the data from client to your database you can make use of SSIS via jobs. Each day you need to manually or automatically run the job and need to get the data from Source (Client) to your destination(your local database).

 
Reply to this topic
Jahnavi N #3
Member
164 Points
 Replied on 24 Jul 2013 09:42 AM IST Good Scenario.

We are also using SSIS jobs to import data from other Sources like ORACLE and Excel files on weekly basis and some data on Monthly basis.

Using SSIS jobs is the best way to import/export data on periodic basis with transformations and look-ups.

-------
Jahnavi
 
Reply to this topic