I only deleted the publication in 'local publication' and the SQL Server deleted the jobs relative this publications, job of distribution and snapshot.

I deleted only the subscriber and publications, but I have others publications in my server.

I didn't disable my distribution ...

I deleted with right mouse button and delete.

sorry my bad english

Ok Gosta,

There was no need to create an SSIS package to run my DTS, I used the DTSRun inside a job, and the process was very fast ...

ex:

DTSRun /S...

OK,

I asked if the packages are saved in the msdb database.

but I must save as dts file.

how can I schedule these packages?

Gosta,

but, In this case my package will be recorded in my MSDB database?

Can I work with several packages as in SQL 2000 and I will not need of my SQL...

Hi Andrew

I have used "select col1, col2 from my table" this improved my performance a little, but yet is very bad ...

Thanks ...

Chris Yannix

I always used OLEDB Provider "Microsoft for oracle DB" with this package my process took 40 minutes to execute, now I changed my packages to use "Oracle provider for...

Gosta Munktell

I know the SQLServer2005_DTS.msi, but to use this solution I need one server to sql2000 to run my packages DTS, and another server to my solution with sql2005....

thanks for your answer,

but I can't use nolock because I extract data from Oracle and I extract all rows of tables.

My SSIS Server and SQL Server are in the...

could anybody help me please

Hi,

ALZDBA, your script is very good. I will trying execute tonight ...

Thank's so much..

Sakthivel Chidambaram, tkank's your hint ..

Sorry my bad English

I use exactly the version 10.2.0.1

I will search the version 10.2.0.3 to do test

thank you

Excuse my insistence, but I am very difiduldade in this process.

I configured a password on packagePassword and in option protectionlevel = EncryptSensitiveWithUserKey

Would be it same?

or in connection managers, how can...

Hi,

In My package I use a login to conect on ORACLE and another to conect to SQL Server, but I don't use login to encrypt the package. Must I...

Hi friends,

Anybody help-me

tranks