Prepare for your Next Interview
This is a discussion on DTS package - run time error within the SQL Server forums, part of the Databases category; Hi, I am using MS SQL Server2000. I need to transer the data from text file to a table. I have a query to perform this operation which works fine ...
|
|||
|
Hi,
I am using MS SQL Server2000. I need to transer the data from text file to a table. I have a query to perform this operation which works fine on query analyser. I have put it in the execute sql task in DTS. When I run the package, it is throwing error - "Permission denied VB script runtime error." Also,if run the same in query analyser, it is working fine. Could u please help me out why it is throwing error only in DTS? |
| Sponsored Links |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Getting Error DPR-ERR-2058 The Dispatcher cannot service the request at this time | jay123 | Data Warehousing | 1 | 08-05-2008 11:31 AM |
| DTS Package Creation | Siva_Tech | SQL | 2 | 09-18-2007 02:32 AM |
| I am getting Type Mismatch error at run time | Geek_Guest | SilkTest | 1 | 09-05-2007 05:10 AM |
| Completed My Diploma as Full time and BE Degree as Part time | Geek_Guest | Career Advice | 0 | 05-21-2007 05:02 PM |
| Execution time-out error | Lokesh M | PHP | 2 | 11-03-2006 02:23 AM |