Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)

  • RE: Replication Monitor

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

  • RE: Replication Monitor

    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

  • RE: SSIS very slowly

    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...

  • RE: SSIS very slowly

    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?

  • RE: SSIS very slowly

    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...

  • RE: SSIS very slowly

    Hi Andrew

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

    Thanks ...

  • RE: SSIS very slowly

    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...

  • RE: SSIS very slowly

    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....

  • RE: SSIS very slowly

    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...

  • RE: SSIS very slowly

    could anybody help me please

  • RE: Install SQL scripts

    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

  • RE: Package SSIS x64

    I use exactly the version 10.2.0.1

    I will search the version 10.2.0.3 to do test

    thank you

  • RE: Package SSIS x64

    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...

  • RE: Package SSIS x64

    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...

  • RE: Package SSIS x64

    Hi friends,

    Anybody help-me

    tranks

Viewing 15 posts - 1 through 15 (of 16 total)