sameerarjuna (2/21/2013)
I am new to SSIS , new to the forum too 😀 .I have been reading books and reading online for the past few days and created a few SSIS packages (Sql Server 2008).
I generally use the Wizard to create SSIS packages , I also know that there is another manual way of
creating the packages without the wizard, which is not as easy.
I wanted to know in terms of best practices, if one way is preferred over the other.
The wizard will create a package to copy data from one place to another - and that's about it. If you want more sophistication - updates, or calculated columns, for example - you'll need to use BIDS. I very rarely use the wizard these days, because the stuff I am developing is too complex for it.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.