----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: pavanha Message 1 in Discussion Hi guys, I had a query on DTS. This is for a intranet based application. User will input the file path of a text file in a text box in a web application. Then he clicks on the button "Import", which calls a stored procedure, which in turn runs a Sql Server DTS. DTS imports data from this text file into the sql server table. Problem here is that, the DTS fails to access the text file if user inputs network share path like "\\160.20.30.234\ImportShare\Inputfile1.txt". This happens only when the DTS is called via stored procedure. If the same DTS is run from DTS Designer, it runs properly. It works if a path like "C:\ImportShare\Inputfile1.txt" is inputted. But this requires that the file to reside on the sql server C drive. Can you please guide me how to make this DTS work when called via stored procedure with network share path as input. Regards H A Pavan QUALITY Without Compromise - The Only Mantra For SUCCESS ----------------------------------------------------------- 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]
