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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.