SSIS Suggestions

[Vimalsoft Pty Ltd]

Good Day All i have a Function in my app that is doing a lot of data Validation and Manipulation, This is normally allowed to take longer than 5 minutes because of amount of data. The sp's are optimized and they perform well. But lately we had a new client that has a high demand. One of the table had a million records. I thought of using SSIS to perform this function and execute the package from the C# code. Questions: As SSIS is good in Performance in such Situation, Do you think its a good idea to take that Route ? What can you Suggest and thinks to put in mind when i will have to add SSIS to my ASP.NET Project ? Thanks

Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/