Geeks Talk

Prepare for your Next Interview




DTS package - run time error

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 ...


Go Back   Geeks Talk > Databases > SQL Server

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 02-15-2008
Junior Member
 
Join Date: May 2007
Location: India
Posts: 12
Thanks: 2
Thanked 2 Times in 2 Posts
vishnukumar is on a distinguished road
Exclamation DTS package - run time error

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?
Reply With Quote
Sponsored Links
Reply

  Geeks Talk > Databases > SQL Server


Thread Tools
Display Modes


Similar Threads

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


All times are GMT -4. The time now is 06:34 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved