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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.