Prev: DB profile and account in DB mail SQLSERVER2005
Next: login Failure for database affter adding a stored procedure
From: RG on 1 Feb 2010 11:54
Currently, we have a 90gig db which is updated once daily with more than 60
gig worth of data. The update is written in c# and utilizes stored
procedures. There are only a few transactions, but they are enormous, I
guess to maintain integrity of the data.

Is SSIS solid and reliable for the above purpose? Does it provide high
degree of flexibility and reliability? If yes, considering the above case,
is there a reason to think that SSIS will work better than that of c#/stored
procedures system?

Thanks in advance
 | 
Pages: 1
Prev: DB profile and account in DB mail SQLSERVER2005
Next: login Failure for database affter adding a stored procedure