Dtsrun Error 17

SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums Import/Export (DTS) and Replication (2000) DTS PACKAGE PROBLEM - SIMPLE AND CONFUSING Reply to Topic Printer Friendly Author Topic ashley.sql Constraint Violating Yak Guru USA 299 Posts Posted-05/16/2007: 11:24:39 I have a DTS package with A connection a source file and a Data Driven Query Task. When I run the package I get this error:connection 'Microsoft OLE DB Provider for SQL Server' for task 'Data Driven Query Task ' does not support joining distributed transactions or failed when attempting to join. Unable to Enlist in Transaction. New Transaction cannot enlist in specified transaction coordinator.Weird thing is when I make copies of all the 3 and paste in the same DTS package one package Fails and One Runs. But If I delete any original connection or task both the packages fail. I don't know why this error started coming. There might be an easy fix to it coz when there are 2 copies one runs successfully.Anyone faced the same thing. Ashley Rhodes dpearcy Starting Member 1 Posts Posted-05/16/2007: 11:35:29 I'm having an error msg with a DTS package.The error is 8004043B. From what I've read, it looks like some type of conflict in memory. I'm very green in the SQL world and need some inputs on this error. Your help is appreciated.Details on Error:DTSRun: Loading...DTSRun: Executing...DTSRun OnStart: DTSStep_DTSActiveScriptTask_1DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B) Error string: The task reported failure on execution. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100Error Detail Record

Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server does not exist when running DTS... SQL Server does not exist when running DTS packages Rate Topic Display Mode Topic Options Author Message Adam BeanAdam Bean Posted Wednesday, January 13, 2010 6:55 AM Ten Centuries Group: General Forum Members Last Login: Tuesday, March 29, 2016 10:11 AM Points: 1,213, Visits: 2,160 Hey all,I'm able to successfully run DTS packages locally and remotely on this specific 2008 environment, but when using agent, I'm getting the same error on every single DTS package:DTSRun: Loading...Error: -2147467259 (80004005); Provider Error: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83671 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0A bit at a loss here. My job looks like this:DTSRUN /S "SERVER\INSTANCE" /N "PackageName" /EThe account which is running the job is sa, which uses my service account, which has sysadmin rights to the instance. I just verified yet again that I can run the DTS as is outside of Agent both http://www.sqlservercentral.com/Forums/Topic846850-391-1.aspx remotely and locally without error. Logs just fine to sysdtspackage/steplog. I can also connect to the server via RDP as the service account and run the DTS packages via SSMS without problem.To add to the mystery, I took the DTSRUN command and ran it from a command prompt and the same error appeared. I also tried running cmd as administrator to make sure that wasn't my problem. I then tried using sqlcmd to simply query the instance, and that worked just fine.If it matters/helps, I'm running SQL2008 x64 SP1 on Windows 2008 R2 x64.Thoughts?Thanks ---SQLSlayerMaking SQL do what we want it to do. Post #846850 Adam BeanAdam Bean Posted Wednesday, January 13, 2010 7:46 AM Ten Centuries Group: General Forum Members Last Login: Tuesday, March 29, 2016 10:11 AM Points: 1,213, Visits: 2,160 Well, I found resolution ...Somehow, I have no idea why/how, but from scripting these jobs out via SSMS from a 2000 server, I obtained an extra hidden ascii character in the command. Once I retyped the full DTSRUN command by hand, they worked in both a command prompt and in the agent.Crazy, but I think I'm good to go. ---SQLSlayerMaking SQL do what we want it to do. Post #846899 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot

the guide to create a maintenance plan. That doesn't work so good either. It runs Optimizations, but not integrity http://www.bigresource.com/MS_SQL-Problems-with-DTS-package-Access-denied-O3jNEO42.html checks or backups (probably because integrity checks failed). The following from the log file: Executed as user: HT-DOMAININTRAB-SQL. ...: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147024891 (80070005) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail dtsrun error Records: Error: -2147024891 (80070005); Provider Error: 0 (0) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147024891 (80070005); Provider Error: 0 (0) Error string: Cannot open a log file of specified name. Access is denied. Error source: Micr... Process Exit Code 1. The step failed. Log-file endeth here..... My "data-sources"/Connections dtsrun error 17 is set up to use sql-server authentication where I enter superuser name+password, not windows authentication. If I browse around using SQL-EM: Under Security - Logins HT-DOMAINintrab-sql: Tab General: Grant Access Tab Server Roles: System Administrators Tab Database Access: checkmark at Mbestil, user=dbo; database roles for mbestil = public + db_owner I also have som problems identifying where the package fails. I have given the individual "steps"/"transformations" some pretty good names, but in the log-file it still shows the "old" names. The DTS package empties a table, then fills it by copying data from another table in another database on another server. Anyone with some useful tips ? /jim View 5 Replies Similar Messages: Execute Package Task: Error 0x80070005 While Preparing To Load The Package. Access Is Denied. Access Denied Running SSIS Package As A Job Remote Execution Of Package Via Dtexec And Access Denied Access Is Denied Occurs After Package Successfully Completes. Execute Package Task Fail With Access Denied Calling Child Package Out Of Process Fails With Access Denied. ExecuteOutOfProcess Calling A Transactional Child Package Causes Access Is Denied. Error Access Is Denied.. Occurs After Packag