SQL Server 2005 Import/export

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...

How to import Microsoft Access to SQL Server 2005

hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa

How to upload data from Excel into SQL Server 2005

hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav