Loading ...
Sorry, an error occurred while loading the content.

Re: [mugh-sqlcon] hi need some help

Expand Messages
  • dilip kumar
    if i run that DTS package manulally it is working in fine and if i run through through xp_cmdshell getting following err DTSRun: Loading... DTSRun:
    Message 1 of 14 , Feb 1, 2006
    • 0 Attachment
      if i run that DTS package manulally it is working in fine
      and if i run through through xp_cmdshell getting following err

      DTSRun: Loading...
      DTSRun: Executing...
      DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
      DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
      DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
      DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
      Error string: Error Code: 0
      Error Source= Microsoft VBScript runtime error
      Error Description: ActiveX component can't create object: 'GetObject'

      Error on Line 5

      Error source: Microsoft Data Transformation Services (DTS) Package
      Help file: sqldts80.hlp
      Help context: 4500

      Error Detail Records:

      Error: -2147220482 (800403FE); Provider Error: 0 (0)
      Error string: Error Code: 0
      Error Source= Microsoft VBScript runtime error
      Error Description: ActiveX component can't create object: 'GetObject'

      Error on Line 5

      Error source: Microsoft Data Transformation Services (DTS) Package
      Help file: sqldts80.hlp
      Help context: 4500

      DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
      DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
      DTSRun OnStart: DTSStep_DTSSendMailTask_1
      DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480)
      Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
      Error source: Microsoft Data Transformation Services (DTS) Package
      Help file: sqldts80.hlp
      Help context: 9100

      Error Detail Records:

      Error: -2147220352 (80040480); Provider Error: 0 (0)
      Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
      Error source: Microsoft Data Transformation Services (DTS) Package
      Help file: sqldts80.hlp
      Help context: 9100

      DTSRun OnFinish: DTSStep_DTSSendMailTask_1
      DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
      DTSRun: Package execution complete.
      NULL


      kumanan archunan <dkumans_a2000@...> wrote:
      Hi Diliip,

      Even it allows space after parameter. Could you plz, send what error its giving.

      regards
      kumanan

      smart chip <knowledge_chip@...> wrote:
      Hi Dilip,

      If you must execute it from procedure. You should use Xp_cmdshell only.

      Why it is not working? what error it is giving?

      If it is not giving any error. Try to excute the command once in query analyzer. Becuase if there is any error in DTS packge Xp_cmdhell doesn't raise error. it only gets result set of failure or sucess.

      EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New package"

      Execute this command in query analyzer once and see the result set rows for any errors in Dts packge.

      Regards,
      Kalyan

      dilip kumar <dilipkumar_agnihotram@...> wrote:
      how to execute DTS package from stored procedure ..
      and i tried the follwing syntax

      EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New package"
      but it is not working .any other way to execute DTS package


      Thnaks
      dilip



      ---------------------------------
      Jiyo cricket on Yahoo! India cricket

      [Non-text portions of this message have been removed]



      SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
      http://www.mugh.net/sql

      Visit http://www.mugh.net/dnug to join .NET User Group.




      ---------------------------------
      YAHOO! GROUPS LINKS


      Visit your group "sqlcon" on the web.

      To unsubscribe from this group, send an email to:
      sqlcon-unsubscribe@yahoogroups.com

      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


      ---------------------------------






      ---------------------------------
      Do you Yahoo!?
      With a free 1 GB, there's more in store with Yahoo! Mail.

      [Non-text portions of this message have been removed]



      SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
      http://www.mugh.net/sql

      Visit http://www.mugh.net/dnug to join .NET User Group.




      SPONSORED LINKS
      C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

      ---------------------------------
      YAHOO! GROUPS LINKS


      Visit your group "sqlcon" on the web.

      To unsubscribe from this group, send an email to:
      sqlcon-unsubscribe@yahoogroups.com

      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


      ---------------------------------






      ---------------------------------

      What are the most popular cars? Find out at Yahoo! Autos

      [Non-text portions of this message have been removed]



      SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
      http://www.mugh.net/sql

      Visit http://www.mugh.net/dnug to join .NET User Group.




      ---------------------------------
      YAHOO! GROUPS LINKS


      Visit your group "sqlcon" on the web.

      To unsubscribe from this group, send an email to:
      sqlcon-unsubscribe@yahoogroups.com

      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


      ---------------------------------






      ---------------------------------
      Jiyo cricket on Yahoo! India cricket

      [Non-text portions of this message have been removed]
    • smart chip
      Hi Dilip, From this I understood that u are trying to use the mail task of DTS right?. If you want to use the mail task in DTS you should crate the dts package
      Message 2 of 14 , Feb 2, 2006
      • 0 Attachment
        Hi Dilip,

        From this I understood that u are trying to use the mail task of DTS right?.
        If you want to use the mail task in DTS you should crate the dts package with ownership of a domain account wich hav mapi Profile. pronbaby you have crated the package with local uaser account on the server.

        But why doon't you try out xp_sendmail extended procedure instead of dts Task?

        Regards,
        Kalyan



        dilip kumar <dilipkumar_agnihotram@...> wrote:
        if i run that DTS package manulally it is working in fine
        and if i run through through xp_cmdshell getting following err

        DTSRun: Loading...
        DTSRun: Executing...
        DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
        DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
        DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
        DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
        Error string: Error Code: 0
        Error Source= Microsoft VBScript runtime error
        Error Description: ActiveX component can't create object: 'GetObject'

        Error on Line 5

        Error source: Microsoft Data Transformation Services (DTS) Package
        Help file: sqldts80.hlp
        Help context: 4500

        Error Detail Records:

        Error: -2147220482 (800403FE); Provider Error: 0 (0)
        Error string: Error Code: 0
        Error Source= Microsoft VBScript runtime error
        Error Description: ActiveX component can't create object: 'GetObject'

        Error on Line 5

        Error source: Microsoft Data Transformation Services (DTS) Package
        Help file: sqldts80.hlp
        Help context: 4500

        DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
        DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
        DTSRun OnStart: DTSStep_DTSSendMailTask_1
        DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480)
        Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
        Error source: Microsoft Data Transformation Services (DTS) Package
        Help file: sqldts80.hlp
        Help context: 9100

        Error Detail Records:

        Error: -2147220352 (80040480); Provider Error: 0 (0)
        Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
        Error source: Microsoft Data Transformation Services (DTS) Package
        Help file: sqldts80.hlp
        Help context: 9100

        DTSRun OnFinish: DTSStep_DTSSendMailTask_1
        DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
        DTSRun: Package execution complete.
        NULL


        kumanan archunan <dkumans_a2000@...> wrote:
        Hi Diliip,

        Even it allows space after parameter. Could you plz, send what error its giving.

        regards
        kumanan

        smart chip <knowledge_chip@...> wrote:
        Hi Dilip,

        If you must execute it from procedure. You should use Xp_cmdshell only.

        Why it is not working? what error it is giving?

        If it is not giving any error. Try to excute the command once in query analyzer. Becuase if there is any error in DTS packge Xp_cmdhell doesn't raise error. it only gets result set of failure or sucess.

        EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New package"

        Execute this command in query analyzer once and see the result set rows for any errors in Dts packge.

        Regards,
        Kalyan

        dilip kumar <dilipkumar_agnihotram@...> wrote:
        how to execute DTS package from stored procedure ..
        and i tried the follwing syntax

        EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New package"
        but it is not working .any other way to execute DTS package


        Thnaks
        dilip



        ---------------------------------
        Jiyo cricket on Yahoo! India cricket

        [Non-text portions of this message have been removed]



        SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
        http://www.mugh.net/sql

        Visit http://www.mugh.net/dnug to join .NET User Group.




        ---------------------------------
        YAHOO! GROUPS LINKS


        Visit your group "sqlcon" on the web.

        To unsubscribe from this group, send an email to:
        sqlcon-unsubscribe@yahoogroups.com

        Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


        ---------------------------------






        ---------------------------------
        Do you Yahoo!?
        With a free 1 GB, there's more in store with Yahoo! Mail.

        [Non-text portions of this message have been removed]



        SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
        http://www.mugh.net/sql

        Visit http://www.mugh.net/dnug to join .NET User Group.




        SPONSORED LINKS
        C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

        ---------------------------------
        YAHOO! GROUPS LINKS


        Visit your group "sqlcon" on the web.

        To unsubscribe from this group, send an email to:
        sqlcon-unsubscribe@yahoogroups.com

        Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


        ---------------------------------






        ---------------------------------

        What are the most popular cars? Find out at Yahoo! Autos

        [Non-text portions of this message have been removed]



        SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
        http://www.mugh.net/sql

        Visit http://www.mugh.net/dnug to join .NET User Group.




        ---------------------------------
        YAHOO! GROUPS LINKS


        Visit your group "sqlcon" on the web.

        To unsubscribe from this group, send an email to:
        sqlcon-unsubscribe@yahoogroups.com

        Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


        ---------------------------------






        ---------------------------------
        Jiyo cricket on Yahoo! India cricket

        [Non-text portions of this message have been removed]



        SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
        http://www.mugh.net/sql

        Visit http://www.mugh.net/dnug to join .NET User Group.




        SPONSORED LINKS
        C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

        ---------------------------------
        YAHOO! GROUPS LINKS


        Visit your group "sqlcon" on the web.

        To unsubscribe from this group, send an email to:
        sqlcon-unsubscribe@yahoogroups.com

        Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


        ---------------------------------






        ---------------------------------
        Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars.

        [Non-text portions of this message have been removed]
      • smart chip
        When you run fromxp_cmshell it runs under the context of sql server service account. That might be also a problem. please think in that way also. dilip kumar
        Message 3 of 14 , Feb 2, 2006
        • 0 Attachment
          When you run fromxp_cmshell it runs under the context of sql server service account. That might be also a problem. please think in that way also.

          dilip kumar <dilipkumar_agnihotram@...> wrote: if i run that DTS package manulally it is working in fine
          and if i run through through xp_cmdshell getting following err

          DTSRun: Loading...
          DTSRun: Executing...
          DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
          DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
          DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
          DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
          Error string: Error Code: 0
          Error Source= Microsoft VBScript runtime error
          Error Description: ActiveX component can't create object: 'GetObject'

          Error on Line 5

          Error source: Microsoft Data Transformation Services (DTS) Package
          Help file: sqldts80.hlp
          Help context: 4500

          Error Detail Records:

          Error: -2147220482 (800403FE); Provider Error: 0 (0)
          Error string: Error Code: 0
          Error Source= Microsoft VBScript runtime error
          Error Description: ActiveX component can't create object: 'GetObject'

          Error on Line 5

          Error source: Microsoft Data Transformation Services (DTS) Package
          Help file: sqldts80.hlp
          Help context: 4500

          DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
          DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
          DTSRun OnStart: DTSStep_DTSSendMailTask_1
          DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480)
          Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
          Error source: Microsoft Data Transformation Services (DTS) Package
          Help file: sqldts80.hlp
          Help context: 9100

          Error Detail Records:

          Error: -2147220352 (80040480); Provider Error: 0 (0)
          Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
          Error source: Microsoft Data Transformation Services (DTS) Package
          Help file: sqldts80.hlp
          Help context: 9100

          DTSRun OnFinish: DTSStep_DTSSendMailTask_1
          DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
          DTSRun: Package execution complete.
          NULL


          kumanan archunan <dkumans_a2000@...> wrote:
          Hi Diliip,

          Even it allows space after parameter. Could you plz, send what error its giving.

          regards
          kumanan

          smart chip <knowledge_chip@...> wrote:
          Hi Dilip,

          If you must execute it from procedure. You should use Xp_cmdshell only.

          Why it is not working? what error it is giving?

          If it is not giving any error. Try to excute the command once in query analyzer. Becuase if there is any error in DTS packge Xp_cmdhell doesn't raise error. it only gets result set of failure or sucess.

          EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New package"

          Execute this command in query analyzer once and see the result set rows for any errors in Dts packge.

          Regards,
          Kalyan

          dilip kumar <dilipkumar_agnihotram@...> wrote:
          how to execute DTS package from stored procedure ..
          and i tried the follwing syntax

          EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New package"
          but it is not working .any other way to execute DTS package


          Thnaks
          dilip



          ---------------------------------
          Jiyo cricket on Yahoo! India cricket

          [Non-text portions of this message have been removed]



          SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
          http://www.mugh.net/sql

          Visit http://www.mugh.net/dnug to join .NET User Group.




          ---------------------------------
          YAHOO! GROUPS LINKS


          Visit your group "sqlcon" on the web.

          To unsubscribe from this group, send an email to:
          sqlcon-unsubscribe@yahoogroups.com

          Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


          ---------------------------------






          ---------------------------------
          Do you Yahoo!?
          With a free 1 GB, there's more in store with Yahoo! Mail.

          [Non-text portions of this message have been removed]



          SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
          http://www.mugh.net/sql

          Visit http://www.mugh.net/dnug to join .NET User Group.




          SPONSORED LINKS
          C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

          ---------------------------------
          YAHOO! GROUPS LINKS


          Visit your group "sqlcon" on the web.

          To unsubscribe from this group, send an email to:
          sqlcon-unsubscribe@yahoogroups.com

          Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


          ---------------------------------






          ---------------------------------

          What are the most popular cars? Find out at Yahoo! Autos

          [Non-text portions of this message have been removed]



          SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
          http://www.mugh.net/sql

          Visit http://www.mugh.net/dnug to join .NET User Group.




          ---------------------------------
          YAHOO! GROUPS LINKS


          Visit your group "sqlcon" on the web.

          To unsubscribe from this group, send an email to:
          sqlcon-unsubscribe@yahoogroups.com

          Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


          ---------------------------------






          ---------------------------------
          Jiyo cricket on Yahoo! India cricket

          [Non-text portions of this message have been removed]



          SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
          http://www.mugh.net/sql

          Visit http://www.mugh.net/dnug to join .NET User Group.




          SPONSORED LINKS
          C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

          ---------------------------------
          YAHOO! GROUPS LINKS


          Visit your group "sqlcon" on the web.

          To unsubscribe from this group, send an email to:
          sqlcon-unsubscribe@yahoogroups.com

          Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


          ---------------------------------






          ---------------------------------
          Bring words and photos together (easily) with
          PhotoMail - it's free and works with Yahoo! Mail.

          [Non-text portions of this message have been removed]
        • Santhosh
          Hi, I want to find the count of distinct of 3 columns. say select distinct empno,name,dept from emp. I want the count for this query or else even if you can
          Message 4 of 14 , Feb 2, 2006
          • 0 Attachment
            Hi,
            I want to find the count of distinct of 3 columns. say
            select distinct empno,name,dept from emp. I want the
            count for this query or else even if you can give me a
            query to find the duplicate records, where the
            combination of empno+name+dept should be duplicate.
            Thanks folks

            with smiles
            santhosh


            __________________________________________________
            Do You Yahoo!?
            Tired of spam? Yahoo! Mail has the best spam protection around
            http://mail.yahoo.com
          • kumanan archunan
            hi, The below query will give you resut that u expect. select distinct (count(*)) from (select distinct empon, empname, deptno from emp ) as e1 Moreover, you
            Message 5 of 14 , Feb 3, 2006
            • 0 Attachment
              hi,

              The below query will give you resut that u expect.

              select distinct (count(*)) from (select distinct empon, empname, deptno from emp ) as e1

              Moreover, you can use like this query where the volume of record is less due to performance consideration.

              regards
              kumanan


              Santhosh <san_spy@...> wrote:
              Hi,
              I want to find the count of distinct of 3 columns. say
              select distinct empno,name,dept from emp. I want the
              count for this query or else even if you can give me a
              query to find the duplicate records, where the
              combination of empno+name+dept should be duplicate.
              Thanks folks

              with smiles
              santhosh


              __________________________________________________
              Do You Yahoo!?
              Tired of spam? Yahoo! Mail has the best spam protection around
              http://mail.yahoo.com


              SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
              http://www.mugh.net/sql

              Visit http://www.mugh.net/dnug to join .NET User Group.




              SPONSORED LINKS
              C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

              ---------------------------------
              YAHOO! GROUPS LINKS


              Visit your group "sqlcon" on the web.

              To unsubscribe from this group, send an email to:
              sqlcon-unsubscribe@yahoogroups.com

              Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


              ---------------------------------





              ---------------------------------
              Yahoo! Mail - Helps protect you from nasty viruses.

              [Non-text portions of this message have been removed]
            • kumanan archunan
              Dear Dilip As i am understanding with below error is that some activex component instance will be created by using getobject is it right. If it is then why
              Message 6 of 14 , Feb 4, 2006
              • 0 Attachment
                Dear Dilip

                As i am understanding with below error is that some activex component instance will be created by using getobject is it right. If it is then why dont you try with CreateObject function instead of GetObject.

                Regards
                kumanan

                smart chip <knowledge_chip@...> wrote:
                When you run fromxp_cmshell it runs under the context of sql server service account. That might be also a problem. please think in that way also.

                dilip kumar <dilipkumar_agnihotram@...> wrote: if i run that DTS package manulally it is working in fine
                and if i run through through xp_cmdshell getting following err

                DTSRun: Loading...
                DTSRun: Executing...
                DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
                DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
                DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
                DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
                Error string: Error Code: 0
                Error Source= Microsoft VBScript runtime error
                Error Description: ActiveX component can't create object: 'GetObject'

                Error on Line 5

                Error source: Microsoft Data Transformation Services (DTS) Package
                Help file: sqldts80.hlp
                Help context: 4500

                Error Detail Records:

                Error: -2147220482 (800403FE); Provider Error: 0 (0)
                Error string: Error Code: 0
                Error Source= Microsoft VBScript runtime error
                Error Description: ActiveX component can't create object: 'GetObject'

                Error on Line 5

                Error source: Microsoft Data Transformation Services (DTS) Package
                Help file: sqldts80.hlp
                Help context: 4500

                DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
                DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
                DTSRun OnStart: DTSStep_DTSSendMailTask_1
                DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480)
                Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
                Error source: Microsoft Data Transformation Services (DTS) Package
                Help file: sqldts80.hlp
                Help context: 9100

                Error Detail Records:

                Error: -2147220352 (80040480); Provider Error: 0 (0)
                Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
                Error source: Microsoft Data Transformation Services (DTS) Package
                Help file: sqldts80.hlp
                Help context: 9100

                DTSRun OnFinish: DTSStep_DTSSendMailTask_1
                DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
                DTSRun: Package execution complete.
                NULL


                kumanan archunan <dkumans_a2000@...> wrote:
                Hi Diliip,

                Even it allows space after parameter. Could you plz, send what error its giving.

                regards
                kumanan

                smart chip <knowledge_chip@...> wrote:
                Hi Dilip,

                If you must execute it from procedure. You should use Xp_cmdshell only.

                Why it is not working? what error it is giving?

                If it is not giving any error. Try to excute the command once in query analyzer. Becuase if there is any error in DTS packge Xp_cmdhell doesn't raise error. it only gets result set of failure or sucess.

                EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New package"

                Execute this command in query analyzer once and see the result set rows for any errors in Dts packge.

                Regards,
                Kalyan

                dilip kumar <dilipkumar_agnihotram@...> wrote:
                how to execute DTS package from stored procedure ..
                and i tried the follwing syntax

                EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New package"
                but it is not working .any other way to execute DTS package


                Thnaks
                dilip



                ---------------------------------
                Jiyo cricket on Yahoo! India cricket

                [Non-text portions of this message have been removed]



                SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                http://www.mugh.net/sql

                Visit http://www.mugh.net/dnug to join .NET User Group.




                ---------------------------------
                YAHOO! GROUPS LINKS


                Visit your group "sqlcon" on the web.

                To unsubscribe from this group, send an email to:
                sqlcon-unsubscribe@yahoogroups.com

                Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                ---------------------------------






                ---------------------------------
                Do you Yahoo!?
                With a free 1 GB, there's more in store with Yahoo! Mail.

                [Non-text portions of this message have been removed]



                SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                http://www.mugh.net/sql

                Visit http://www.mugh.net/dnug to join .NET User Group.




                SPONSORED LINKS
                C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

                ---------------------------------
                YAHOO! GROUPS LINKS


                Visit your group "sqlcon" on the web.

                To unsubscribe from this group, send an email to:
                sqlcon-unsubscribe@yahoogroups.com

                Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                ---------------------------------






                ---------------------------------

                What are the most popular cars? Find out at Yahoo! Autos

                [Non-text portions of this message have been removed]



                SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                http://www.mugh.net/sql

                Visit http://www.mugh.net/dnug to join .NET User Group.




                ---------------------------------
                YAHOO! GROUPS LINKS


                Visit your group "sqlcon" on the web.

                To unsubscribe from this group, send an email to:
                sqlcon-unsubscribe@yahoogroups.com

                Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                ---------------------------------






                ---------------------------------
                Jiyo cricket on Yahoo! India cricket

                [Non-text portions of this message have been removed]



                SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                http://www.mugh.net/sql

                Visit http://www.mugh.net/dnug to join .NET User Group.




                SPONSORED LINKS
                C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

                ---------------------------------
                YAHOO! GROUPS LINKS


                Visit your group "sqlcon" on the web.

                To unsubscribe from this group, send an email to:
                sqlcon-unsubscribe@yahoogroups.com

                Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                ---------------------------------






                ---------------------------------
                Bring words and photos together (easily) with
                PhotoMail - it's free and works with Yahoo! Mail.

                [Non-text portions of this message have been removed]



                SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                http://www.mugh.net/sql

                Visit http://www.mugh.net/dnug to join .NET User Group.




                SPONSORED LINKS
                C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

                ---------------------------------
                YAHOO! GROUPS LINKS


                Visit your group "sqlcon" on the web.

                To unsubscribe from this group, send an email to:
                sqlcon-unsubscribe@yahoogroups.com

                Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                ---------------------------------





                ---------------------------------
                Yahoo! Mail - Helps protect you from nasty viruses.

                [Non-text portions of this message have been removed]
              • dilip kumar
                actually the script given by some other person and i m clubbing all into single package and try to run from query analyser kumanan archunan
                Message 7 of 14 , Feb 6, 2006
                • 0 Attachment
                  actually the script given by some other person and i m clubbing all into single package and try to run from query analyser


                  kumanan archunan <dkumans_a2000@...> wrote:
                  Dear Dilip

                  As i am understanding with below error is that some activex component instance will be created by using getobject is it right. If it is then why dont you try with CreateObject function instead of GetObject.

                  Regards
                  kumanan

                  smart chip <knowledge_chip@...> wrote:
                  When you run fromxp_cmshell it runs under the context of sql server service account. That might be also a problem. please think in that way also.

                  dilip kumar <dilipkumar_agnihotram@...> wrote: if i run that DTS package manulally it is working in fine
                  and if i run through through xp_cmdshell getting following err

                  DTSRun: Loading...
                  DTSRun: Executing...
                  DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
                  DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
                  DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
                  DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
                  Error string: Error Code: 0
                  Error Source= Microsoft VBScript runtime error
                  Error Description: ActiveX component can't create object: 'GetObject'

                  Error on Line 5

                  Error source: Microsoft Data Transformation Services (DTS) Package
                  Help file: sqldts80.hlp
                  Help context: 4500

                  Error Detail Records:

                  Error: -2147220482 (800403FE); Provider Error: 0 (0)
                  Error string: Error Code: 0
                  Error Source= Microsoft VBScript runtime error
                  Error Description: ActiveX component can't create object: 'GetObject'

                  Error on Line 5

                  Error source: Microsoft Data Transformation Services (DTS) Package
                  Help file: sqldts80.hlp
                  Help context: 4500

                  DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
                  DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
                  DTSRun OnStart: DTSStep_DTSSendMailTask_1
                  DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480)
                  Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
                  Error source: Microsoft Data Transformation Services (DTS) Package
                  Help file: sqldts80.hlp
                  Help context: 9100

                  Error Detail Records:

                  Error: -2147220352 (80040480); Provider Error: 0 (0)
                  Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
                  Error source: Microsoft Data Transformation Services (DTS) Package
                  Help file: sqldts80.hlp
                  Help context: 9100

                  DTSRun OnFinish: DTSStep_DTSSendMailTask_1
                  DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
                  DTSRun: Package execution complete.
                  NULL


                  kumanan archunan <dkumans_a2000@...> wrote:
                  Hi Diliip,

                  Even it allows space after parameter. Could you plz, send what error its giving.

                  regards
                  kumanan

                  smart chip <knowledge_chip@...> wrote:
                  Hi Dilip,

                  If you must execute it from procedure. You should use Xp_cmdshell only.

                  Why it is not working? what error it is giving?

                  If it is not giving any error. Try to excute the command once in query analyzer. Becuase if there is any error in DTS packge Xp_cmdhell doesn't raise error. it only gets result set of failure or sucess.

                  EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New package"

                  Execute this command in query analyzer once and see the result set rows for any errors in Dts packge.

                  Regards,
                  Kalyan

                  dilip kumar <dilipkumar_agnihotram@...> wrote:
                  how to execute DTS package from stored procedure ..
                  and i tried the follwing syntax

                  EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New package"
                  but it is not working .any other way to execute DTS package


                  Thnaks
                  dilip



                  ---------------------------------
                  Jiyo cricket on Yahoo! India cricket

                  [Non-text portions of this message have been removed]



                  SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                  http://www.mugh.net/sql

                  Visit http://www.mugh.net/dnug to join .NET User Group.




                  ---------------------------------
                  YAHOO! GROUPS LINKS


                  Visit your group "sqlcon" on the web.

                  To unsubscribe from this group, send an email to:
                  sqlcon-unsubscribe@yahoogroups.com

                  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                  ---------------------------------






                  ---------------------------------
                  Do you Yahoo!?
                  With a free 1 GB, there's more in store with Yahoo! Mail.

                  [Non-text portions of this message have been removed]



                  SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                  http://www.mugh.net/sql

                  Visit http://www.mugh.net/dnug to join .NET User Group.




                  SPONSORED LINKS
                  C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

                  ---------------------------------
                  YAHOO! GROUPS LINKS


                  Visit your group "sqlcon" on the web.

                  To unsubscribe from this group, send an email to:
                  sqlcon-unsubscribe@yahoogroups.com

                  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                  ---------------------------------






                  ---------------------------------

                  What are the most popular cars? Find out at Yahoo! Autos

                  [Non-text portions of this message have been removed]



                  SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                  http://www.mugh.net/sql

                  Visit http://www.mugh.net/dnug to join .NET User Group.




                  ---------------------------------
                  YAHOO! GROUPS LINKS


                  Visit your group "sqlcon" on the web.

                  To unsubscribe from this group, send an email to:
                  sqlcon-unsubscribe@yahoogroups.com

                  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                  ---------------------------------






                  ---------------------------------
                  Jiyo cricket on Yahoo! India cricket

                  [Non-text portions of this message have been removed]



                  SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                  http://www.mugh.net/sql

                  Visit http://www.mugh.net/dnug to join .NET User Group.




                  SPONSORED LINKS
                  C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

                  ---------------------------------
                  YAHOO! GROUPS LINKS


                  Visit your group "sqlcon" on the web.

                  To unsubscribe from this group, send an email to:
                  sqlcon-unsubscribe@yahoogroups.com

                  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                  ---------------------------------






                  ---------------------------------
                  Bring words and photos together (easily) with
                  PhotoMail - it's free and works with Yahoo! Mail.

                  [Non-text portions of this message have been removed]



                  SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                  http://www.mugh.net/sql

                  Visit http://www.mugh.net/dnug to join .NET User Group.




                  SPONSORED LINKS
                  C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

                  ---------------------------------
                  YAHOO! GROUPS LINKS


                  Visit your group "sqlcon" on the web.

                  To unsubscribe from this group, send an email to:
                  sqlcon-unsubscribe@yahoogroups.com

                  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                  ---------------------------------





                  ---------------------------------
                  Yahoo! Mail - Helps protect you from nasty viruses.

                  [Non-text portions of this message have been removed]



                  SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
                  http://www.mugh.net/sql

                  Visit http://www.mugh.net/dnug to join .NET User Group.




                  SPONSORED LINKS
                  C programming language Computer programming languages Java programming language The c programming language C programming language Concept of programming language

                  ---------------------------------
                  YAHOO! GROUPS LINKS


                  Visit your group "sqlcon" on the web.

                  To unsubscribe from this group, send an email to:
                  sqlcon-unsubscribe@yahoogroups.com

                  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


                  ---------------------------------





                  ---------------------------------
                  Jiyo cricket on Yahoo! India cricket

                  [Non-text portions of this message have been removed]
                • SARADADEVI
                  Hi All,   Is it possible to increase performance for below????     exec sp_executesql N SELECT T_DT_E FROM Testing WITH(NOLOCK) WHERE Moniter =
                  Message 8 of 14 , May 21, 2010
                  • 0 Attachment
                    Hi All,
                     
                    Is it possible to increase performance for below????

                     
                     
                    exec sp_executesql N'SELECT T_DT_E FROM Testing WITH(NOLOCK) WHERE Moniter = @Moniter',N'@Moniter nvarchar(32)',@Moniter='654hyrsdt6543strb74353f'



                     
                     
                     
                    CREATE TABLE [dbo].[Testing](

                    [Moniter] [char](32) NOT NULL,

                    [TPT_CD] [char](2) NULL,

                    [PL_NR] [char](3) NULL,

                    [C_ACH_DT] [datetime] NULL,

                    [C_DLT_I] [char](1) NULL,

                    [T_DT_E] [xml](CONTENT [dbo].[BossSchema]) NULL,

                    [T_UT_S] [datetime] NULL,

                    CONSTRAINT [IARSHII1] PRIMARY KEY CLUSTERED

                    (

                    [Moniter] ASC

                    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [SD413AUS02]

                    ) ON [SD413AUS02]



                     
                     
                    SQL Trace was used to capture the above command from HYRTG65.HHT
                     
                    Table has 7065171 rows. There is no Hardware issue.



                    Query is execeuted 6500 times/day.

                    Avg duration 1591ms

                    Avg CPU 2819ms

                    Avg reads 82685

                    Showplan indicates a clustered index scan on Testing (Primary Key)



                    Thanks and Regards,

                    Satheesh..D.V ,



                    [Non-text portions of this message have been removed]
                  Your message has been successfully submitted and would be delivered to recipients shortly.