Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bugsy
Starting Member
9 Posts |
 Posted - 2006-09-21 : 21:52:18
|
| heyI have VB front end that calls DTS, it works fine (have to copy some DLLs to various places on C drive) - this needs to work on machines that don't have SQL installedHowever once i update DTS to include some dynamic properties, i can't seem to call it from machine of users who don't have SQL. DTS itself works fineDo i have to copy any othe DLLs for this ?thanks |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-21 : 23:31:08
|
| You just need to install the SQLDMO objects.Have a look in BOL and it tells you how to call via VB.Or you can use xp_cmdshell (as you've already discovered) |
 |
|
|
Bugsy
Starting Member
9 Posts |
Posted - 2006-09-22 : 07:03:42
|
| hi Timmyi have it working for a different DTSs, but not the one i need, this one also utilizes Dynamic Properties.So dynamic libraries require something called 'SQLDMO objects.' ?whats BOL ? google suggests BAUSCH LOMB INC. I somehow doubt that's what u meant..>>Or you can use xp_cmdshell (as you've already discovered)i haven't discovered working syntaxis as of yet.. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-22 : 08:30:11
|
| Books Online.Or F1 |
|
|
|
Bugsy
Starting Member
9 Posts |
Posted - 2006-09-22 : 09:25:28
|
| k, i found Books Online's 4 aticles on SQL-DMOmentions nothing in relation to VB |
|
|
|
|
|
|
Running DTS from Visual Basic