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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2007-09-10 : 09:16:54
|
| SSIS as a ETL tool Guys,I currently doing microsoft's hands-on training tutorial for SSIS. I realized that its not an comprehensive ETL tool as it was advertised to me. I see it more of a package tool for all imports, exports which include DML scripts. In my scenario I have to convert 10 source data tables to destination schema tables. i normally use DML scripts to convert the data. Once I have mapping between source and destination tables it does not take more than hour to write DMl scripts. But when I try to use SSIS its taking me more time to create data flow tasks and create a package. And does SSIS support all the sql server 2005 string functions.Any comments/inputs would help.Thanks |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-09-11 : 07:14:48
|
| No, it's definitely more than that. In common with most ETL tools these days, it's more of a development 'platform' (in the style of Ab Initio). In what way do you see it as not comprehensive? The area I'd like to see improved is greater meta data integration in terms of data lineage, and integrated profiling and DQ. Other than that, I've not found much I couldn't do with it. Your requirement doesn't sound particularly challenging. What problems are you running into? SSIS has its own expression language. In addition to this, you have access to VB.net via script tasks, and can also potentially use SQL string functions in SQL-based tasks/adapters.Mark |
 |
|
|
|
|
|
SSIS as ETL tool?