If you must do it from a stored procedure you can use the following syntax to select from the excel spreadsheet:

insert into table

select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;DATABASE=d:\excelfile.xls', 'Select *...

If you're not worried about losing your history, simply bcp out the contents of the msdb..sysdtspackages table to a file and import or use a dts transformation to move the...

Create a table (results) to capture your results. I'm assuming you would be checking a time period. My example checks every minute starting midnight of 10/1/2005 and ending the minute...

We have domains that are separated by a firewall in our enterprise. When I got tired of trying to make the DTC work I developed the system to use isql/osql...

I personally always use the transformation task since it's the only one that can go both ways. As long as you specify a decent batch size the speed difference between...

This is where company confidentiality agreements come in. If the data really needs to be kept confidential, you should have your sysadmins sign an agreement that they will not look...

Are you saying that each person will get a new fax number? If that is the case, you would load a table (import_table) with two columns (name, fax) and then:

update...