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)
 sp execute a dts problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-02-21 : 07:50:34
Eduardo writes "Hi,

Sorry for my english.

Im working in datawarehousing project with SQL SERVER 2000 SP3, I create a store procedure that execute a dts package (this dts process a cube).
When I execute the sp, this finalize without error but when i see the cube in Analysis Services this not processed.
I cant find the error, because the execution of sp dont give me any error.
The code of sp if correct, and if i run the dts with Enterprise Manager, this finalize ok and I can see the cube process.

I waiting for you answer,

Thanks"
   

- Advertisement -