I am currently pulling in 60 tables from a Sybase database into SQL Server 2000. To do this I have set up 6 DTS packages each with 10 transformations, and a global package which runs each DTS.
Adding new tables is convoluted and can cause problems, and also transfer speed is quite slow as...
I am trying to run an executable on my local pc using the xp_cmdshell stored proc.
The app will only run on the server however.
eg.
exec master..xp_cmdshell 'c:\executable.exe'
where c:\executable.exe is a file held on the local pc.
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.