What are the Best Practice Principles to develop SSIS Package [duplicate]

This question already has answers here: Does anyone have any good SSIS Best-Practices tips and suggestions? [closed] 开发者_C百科 (11 answers) Closed 7 years ago.

If I want to Develop SSIS Package from scratch what techniques/needs to be fallow in related to design,development,testing and deployment.

---

Here's a few tips:

1) Importing data: loading data into a table can often be sped up by first dropping nonclustered and the clustered indexes, then perform the data load, and finally recreate the indexes (clustered first, then the nonclustered).

2) This one applies almost everywhere: Avoid SELECT *.

---

IMO, SSIS is a software development discipline, just like C# or any other development tool/environment. There is a lot to it. I would start with a good book or tutorial. One of them can be found here: http://www.accelebrate.com/sql_training/ssis_tutorial.htm

Learn also the pros and cons of using the various connection types ADO, OLEDB etc. They each offer different functionality and transaction support. And, if you can, work with SSIS 2008 because it allows you to script objects using C#.

Randy