J
J. Nathalia
Hi
I have been searching the whole day, but can't really find a solution to execute a SQL Server DTS from Access (Data Access Page). However I find several solutions to do it in VB, I would like to have it working from a Access Page (html)
I think the only lacking thing is the reference to the Microsoft DTSPackage Object Library. I have implemented something like
<!--METADATA TYPE="C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll" NAME="Microsoft DTSPackage Object Library" UUID="{DB18F95E-6AF8-11D5-8F50-0090278A2F8E}" version="2.0"--
But this doesn't work. I have also tried to insert the VB code that can be generated when saving a DTS, but this doesn't work either. Does anybody no if this is possible at all
Could someone send an example
Regards
Jeroen
I have been searching the whole day, but can't really find a solution to execute a SQL Server DTS from Access (Data Access Page). However I find several solutions to do it in VB, I would like to have it working from a Access Page (html)
I think the only lacking thing is the reference to the Microsoft DTSPackage Object Library. I have implemented something like
<!--METADATA TYPE="C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll" NAME="Microsoft DTSPackage Object Library" UUID="{DB18F95E-6AF8-11D5-8F50-0090278A2F8E}" version="2.0"--
But this doesn't work. I have also tried to insert the VB code that can be generated when saving a DTS, but this doesn't work either. Does anybody no if this is possible at all
Could someone send an example
Regards
Jeroen