Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ehague

  1. ehague

    are there any issues when upgrading from 7.0 to 2000

    has anyone run into any issues when upgrading from sql 7.0 to 2000? is there a good place I can read info on this topic. liz
  2. ehague

    global variables passing to an EXECUTE PACKAGE TASK in DTS

    I have a parent DTS package that is executing a child dts package. I am having difficulties trying to pass a variable from the parent to the child. The child package does not seem to be accepting it. I think I am doing it wrong. I have a global variable in my parent called...
  3. ehague

    DTS row count logged into table

    I want to be able to write how many rows were transferred in my DTS package to a table or log. How can i do this? iz
  4. ehague

    DTS performance and ActiveX Component

    Wow! you are full of great suggestions. I am using the truncate table option. It is the transfer of data that is taking so long. by the way, i am transfering from a flatfile to an as400. why would i want to set the table lock option? all my transformations right now are through vbscript. i...
  5. ehague

    DTS performance and ActiveX Component

    I have a DTS package where I am deleting data in a table and then transferring about 80,000 rows over to the empty table. I wound up writing most of it in VBScript with the ActiveX component. The proccess seems to be taking longer than I would like. Would dragging over the connection icons and...
  6. ehague

    dts and email

    I am setting up an email to run when a package succeeds. This package accepts global variables. The destination of the email changes depending on what variables get pushed into the dts package. Can I get the destination of the email to change in the DTS Mail Task when the variable changes? Do...
  7. ehague

    dts and mapi login failure

    I have several dts packages that run just fine through a third party scheduler. I then put a mail task on them to tell me if the package succeeded or failed. Every time the scheduler gets to the mail task it fails and logs a mapi login failure error. When I execute the dts package on my local...
  8. ehague

    DTS and Variable Help Needed

    I am working on a project that is transfering data beween an AS400 and a flat file using SQL 2000 DTS. The company wants me to set up variables so that the servername and database name can be changed within the DTS package. This way they can use one DTS package for several different servers...
See more

Part and Inventory Search

Back
Top