Error with a DTS

Question

Post reply

Error with a DTS

msna

SSC Enthusiast

Points: 143
More actions
October 17, 2001 at 7:07 am

#105039

Hi !
Here are the log of an DTS execution :
"DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copier les données de Résultats vers \\Wmp-pczno\sap_transfer\WMDBSAP.txt Étape DTSRun OnError: Copier les données de Résultats vers \\Wmp-pczno\sap_transfer\WMDBSAP.txt Étape, Error = -2147217887 (80040E21) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copier les données de Résultats vers \\Wmp-pczno\sap_transfer\WMDBSAP.txt Étape DTSRun: Package execution complete. Code de sortie du processus 1. L'étape a échoué."
Could someone help me ?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Paul Ibison SSCertifiable Points: 5303 More actions · Answer 1

I've had this error with excel files when the source or destination file was already open.

Paul Ibison PhD, MCSD

email: Paul.Ibison@btinternet.com

Paul Ibison
Paul.Ibison@replicationanswers.com

msna SSC Enthusiast Points: 143 More actions · Answer 2

Thank's for replying !

I think that the user of sql server is not authorized to write in the folder where the text file stands.

I put the text file on a NT server with the rights to read and write and it works !

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

Whenever you have an "access denied" be sure you check security.

Thanks for the followup.

Steve Jones

steve@dkranch.net

Daniel Minnaar Newbie Points: 1 More actions · Answer 4

I understand your point to case-sensitive columns, as I've often come across data that is compared and defined by it's case.

I'm a .NET programmer that does all the back-end tier coding. Most of the web-based services and applications I work with use SQL Server. Time and time again I come across a scenario where I deal with case sensitive data, and from past experiences I have learnt to deal with the difference in the upper-layer tier. I'd rather have the data I'm working with be non case-sensitive, then convert/compare/view it as it needs to be in the application itself.

I realise that everyone has different scenarios, but I find (as a coder), that working with data once it's been pulled from the database is safer to manipulate and easier to organise.