-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: BalajiKrishnan
Message 9 in Discussion
Hi ALL The DTS PACKAGE WAS EXECUTING SUCESSFULLY...BUT THE PROBLEM IS READ BELOW
CAREFULLY I created a DTS Package..which select the data from a table and store it
in a txt file... I am executing this DTS from ASP Code......... The problem i face
is since it is a huge table..... I am not getting any data in the text file.... Now
i changed the Query in the DTS Package.... "Select top 2 * from sector" Now when i
execute the DTS from asp code it is working fine and the data is stored in txt
file..... The problem is i need to set the time out property to execute the package.
this is my asp code..... <% StrDTSPacName="DTSSectors" Set Objcmd =
Server.CreateObject("ADODB.Command") Set Objcn =
Server.CreateObject("ADODB.Connection") Dim oPkg Set oPkg = server.CreateObject
("DTS.Package") oPkg.LoadFromSQLServer "SERVER", "meridianlocal", "meridian", , , , ,
StrDTSPacName oPkg.Execute %> Is there any way to set the connection time property
when creating DTS Package.. Let me know asap... this is very urgent Thanks
Balaji
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
