This has to do with how excel determines what the data type of a column is. It only checks to fist 7 rows, so if the data in the first 7 rows is...
Finally got this to work. I had to add the excel doc as a linked server named excelsource with the command below sp_addlinkedserver 'excelsource',...
This is the query. I think it will work, but I need to reference a table in another database using a different connection than the connection to the...
I have an excel sheet that I import into a table with dts, I then compare the values from the sheet with other tables in the database and update a...
Well it works but not when scheduled. The program that reads the email fails. I believe this is becuase scheduled dts jobs are run by the local...
I have this problem about 90% solved. I had no idea you could run executables with DTS until I went to the website you gave me. I wrote a small...
Hi, I need to import a daily table dump from a group of older sybase databases (sybase ver 4.91 running on vms with the decnet networking...
Thanks for the help. I did test the recovery process on a test bed, and had no problems; however, when I went to restore the db on the production...
I have a Compaq ML570 server with 4 processors, and six 18 gig drives (4 in use, I will be adding the other 2) that I am using for a data warehouse....
Separate names with a comma.
