Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
taara
Starting Member
1 Post |
 Posted - 2008-04-07 : 01:31:52
|
| Thanks in advance! I am new to SQL Server Development. I will be working on a project which requires a good understanding of SSIS. What are the usual scenarios or tasks I will be given when working on SSIS? Please help!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-07 : 01:51:03
|
| SSIS is used basically as a ETL tool i.e Extract,Transform and Load. You can connect to different types of data sources like Oracle,SQL Server, flat files like excel to extract data, perform some transformation like generating derived columns, lookup information based on source,... and then load the data onto multiple sources using SSIS. For more onfo on SSIS go towww.sqlis.com |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-04-07 : 11:05:36
|
| My 2 cents:It moves data from point a to point b, doing transformations in between. |
|
|
|
|
|
|
links to SSIS