October 15, 2011 at 12:46 am
what ever we do in ssis package we can do in sql server.
but why we use ssis.plese tell me some Reasion.why we use ssis
October 16, 2011 at 4:54 pm
I know more about what can be done with SSIS than what can be done in SQL, so some of these things probably are doable in SQL; but this just highlights one reason for using SSIS over stored procs.
Here goes:
SSIS may better fit some peoples' skill set (not everyone knows how to do everything in SQL)
SSIS has different security features and issues.
SSIS allows you to work with many and varied disparate sources, in memory, all at the same time.
SSIS provides a gui for development work, more understandable/maintainable (depends on the scenario).
SSIS provides some 'out of the box' functionality.
SSIS transformations are somewhat source agnostic, you can change the source connection and the transformation logic still works (not necissarily the case in SQL).
SSIS provides access to .NET.
But basically if you can meet your requirements quickly and easily with SQL (and someone other than you will still be able to maintain/understand what has been done) then there's no real reason to use SSIS, unless it's already a standard and you ought to conform to it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply