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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 how to use CDO in a DTS : make a simple 'var Sess = CreateObject(

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-03 : 08:45:05
Vincent writes "Function Main()
set Sess = CreateObject("MAPI.Session")
set Sess=null
Main = DTSTaskExecResult_Success
End Function

in a simple task on a SQL 7.0 dont work, he tell me :"...can't create
object"

anybody can explain me why ?

Vincent"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-06-03 : 09:23:29
At a guess...

You don't have that component installed on the machine you are running the package from.

Remember, when you run a package, it runs ON THE MACHINE you are using. If you want it to run on the server, you need to run it as a scheduled job.

Damian
Go to Top of Page
   

- Advertisement -