SSIS and Microsoft Excel

I have a road block that I need to find a work around for. I work on a system where the Databases reside on a soley database server (SQL 2005). I need to run a stored procedure on a nightly basis and export the results into a template excel file and put out on shares. Sounds simple right? Here's...

Cathryn35 pointsBadges:

Error when updating SQL Server 2000 from SQL Server 2005

Hi, I am using sqlServer 2005 and sqlServer 2000. When i update on sqlServer2000 from sqlServer2005 then following error was occured. Msg 682, Level 22, State 148, Line 1 Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

Nileshpatkar825 pointsBadges:

SQL problem

Hi, Iam having two sql servers 2000 and 2005 are installed on the same server. When i run any application it is directily hitting the 2005 serve but i want the application to to hit sql 2000 server only and when i want to hit it to sql 2005 it should hit it means vice vers can some one help me in...

Vemuseshu5 pointsBadges: