Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SSIS packages or Script for ETL

SSIS packages or Script for ETL

SSIS packages or Script for ETL

I am creating my ETL using SSIS packages move my 5 databases into one database.

The DBA at the client is real hesitant about using this instead of using a really long script file he used before that has all the T-Sql in it.

His reasoning is that the SSIS is too complicated and that no one at the company knows how to use it and he feels he would be forced to make any changes to it after we leave and would not be able to offload changes to other database personnel.

The reasoning may be valid from his point of view but I am trying to find good reasons why SSIS is better.  Maybe I am wrong.

I am trying to find out if my reasoning is valid or not and if there are other reasons to use.

Reasons I gave are:

1. Able to break the ETL into more manageable pieces.
2. Certain tasks will run in parallel
3. Be able to handle multiple results of a query easier
4. Notification built in and easier
5. Error handling built in and easier.
6. Other DBs would normally like to learn and use the new technology which would also make them more valuable.




RE: SSIS packages or Script for ETL

DBA's 'get up and go to bed' with SQL scripts. From their point of view SSIS may seem like overkill. An ETL specialist will probably prefer the SSIS solution.

If this is a one time requirement then using a script is perfectly acceptable. If it is part of a regular process outside the DBA's competence then SSIS would probably be the better solution

Ties Blom

RE: SSIS packages or Script for ETL

Based on what you say, you are implementing the solution and handing it off to them where they will take over development.  So I'd use scripts if that is what they are comfortable with.  Also, if you have your ETL on the same server as the DW, you can get some quicker loads with scripts over data flow tasks in SSIS.

However, if you do plan on supporting the installation yourself, then you wouldn't want the client making their own modifications so you should be able to use what you want as long as they can provide systems support for it.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close