February 21, 2013 at 8:18 am
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.
February 22, 2013 at 2:02 am
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply