Search results for query: *

Just a quick alternative solution if you want to use the sp_addlinkedserver procedure to open a connection to your XLS file. The IMEX=1 should solve the mixed format import issues. EXEC sp_addlinkedserver EXCEL, 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'C:\DataTest.xls'...

Hi Tom, Thanks for your comments, it's definately an option, but I would be a little concerned by the sheer amount of combinations that would be possible, and thus the amount of DTS' I would need to create and maintain. When originally looking at the problem, I decided that using the...

Hi All, I wonder if anyone can assist me. I'm trying to create a DTS that will import bespoke XLS files into SQL2K5. I've used the Dynamic Properties Task to control the source data and to point it at the file in question, and I've added an ActiveX task to ensure that the import uses the...

I was struggling for a while with the very same problem, but I finally managed to identify a workable solution. As part of the DTS, add an ActiveX Script Task, and enter the following code. ============= Function Main() dim pkg dim conXL dim prp set pkg = DTSGlobalVariables.Parent set...