DTS runs manually, fails as scheduled job

I've mined countless threads all over the Net where people are having my problem, but none of the solutions I've seen seem to apply.

When I run a DTS package from Enterprise Manager, everything works great. When I schedule the same package as a job, it fails immediately and reports this error:

Executed as user: SERVER-NAME\SYSTEM. DTSRun: Loading... Error: -2147221005 (800401F3); Provider Error: 0 (0) Error string: Invalid class string Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 713. Process Exit Code 1. The step failed.

My hunch is the SERVER-NAME\SYSTEM.DTSRun account doesn't have sufficient privileges, but I can't find how/where to fix that.

Help, please.

Thanks,

Doug

Checkout the following links

http://www.sqlmag.com/articles/index.cfm?articleid=46723& - Security in SSIS
http://support.microsoft.com/?kbid=918760 - An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step

Thanks,
Loonysan

|||

"Invalid class string" is not strictly a SQL Server error in DTS. Essentially it means in cannot find the CLSID for a required object when reading the package. This error can also occur when loading a package that contains a CustomTask which has not been registered on the current machine. (http://www.databasejournal.com/features/mssql/article.php/1461391)

PRB: "Invalid class string" error message when opening DTS package
(http://support.microsoft.com/?scid=kb%3Ben-us%3B288910&x=15&y=16)

The top two hits I got from Google, both say pretty much the same thing. Something is missing from your server, which causes the "Invalid class string", or "I cannot find your task".

FYI, general DTS info on jobs-

INF: How to Run a DTS Package as a Scheduled Job
(http://support.microsoft.com/kb/269074/en-us)

DTS run from .NET

My dts package has to pick up a file which is in a mapped drive of the
sql server... (system1)...
when I run it from code the execution ends up in an error... but if I
have the drive mapped (drive where I have the source file) onto the
web server (system2) the execution goes through fine.. I donot want to
have the drive mapped onto the web server.. how can I do this..Try and use the UNC path.

Joel Scavone|||I did use a full netwok path and even did add identity impersonate in
the web.config... but does not help..

The package runs fine when I register the sql server my machine and run
the package..

Sigh! Don't know what wrong

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

DTS problem

Hi

I am trying to invoke a dts from asp.net and was informed that I need to create a name key pair file and runtime callable wrapper...which consiste sof changing the command line...but I cannot fine the files. I am using web matrix...which I think is the problem.

Has anyone found the same problems...I am looking for the Bin directory in web matrix and tlbimp.exe.

Any help would really be appreciated.

ThanksIt sounds to me like you are trying to do things the complicated way.

Are you wanting to create a new dts with your asp.Net or just execute an existing dts package?

There are plently of stored procedures you can call via standard ADO to excute existing pacakges, if that's what you want to do.|||Hi

Thanks for your reply...I am just trying to invoke a dts from an asp.net web page...I have searched the internet but cannot find any information on how to do this in vb.

Do you know of any good sites?

Thanks|||But it is an existing DTS package right?|||yeah it is

Thanks|||Well the way I normally run a dts package from asp (and it will work from asp.Net as well) is to create a job to execute the package and then (whenever I want to run it) I make an ADO call to the database using sp_start_job.

Now I know there is another stored proc or something that other people use to run the specific dts (and thus you don't need a job) but I can't remember what it was.

If you want to run things from the command line, why not use dtsrun to execute your package?|||Hi

Thanks for the reply...I have found asp code to run the dts...do you know what asp.net uses instead of the 'set'

Thanks|||just in clude a reference to the component in question, then you should be able to just declare the varible the same way you would any other variable.

set in asp is only used for objects, in theory everything in asp.Net is an object so you don't need to diffientate

so if you are using c# something like... (note it's only like this)

using Data.OLEDB;

will set you reference then.

connection myConn = blah blah blah;

will create your connection object.

HTHsqlsql

DTS Package Issues with Access

Hello,

I kick off a DTS package with ASP.NET. I'm getting an error stating:

The Microsoft Jet database engine cannot open the file <path>. It is already opened exclusively by another user, or you need permission to view its data.

The DTS package is pushing data from Excel to Access, and then Access to SQL. When running the process, I run it directly and it works fine. I haven't tested it through scheduling yet. All of the information on the web says security permissions, but I impersonate the ASP.NET page to use another account, which has full access to the access database and dbo to SQL Server.

Any ideas?

Brianmake sure the files are closed. If the excel file is open it will not work|||Hey,

It was. And I make sure that the data pump tasks closed the connection on completion, through the Workflow Properties screen.

Brian

DTS in ASP.NET

Hi all,

I want to execute a DTS Package in a ASP.VB.NET(ASP.NET using VB language) application. Please, it's ASP.VB.NET(ASP.NET using VB language)

NOT VB.NET ou CS.NET

If it's possible i would like some code samples.

I'll be thankful if someone help me

Regards

Renatacheckthis article out.

DTS in ASP NET

How can execute a DTS from asp net. I'm using com reference Microsoft DSTPackage Objects and the LoadFromSQLServer method but nothing happend, no error, no message, nothing.
Someone know how can i execute a DTS from asp net?

THANKKSSS!!!Try this url it is run by a SQL Server MVP. Hope this helps.

http://www.sqldts.com

Kind regards,
Gift Peddie|||THANKSSS!!!! IT'S HELP ME!!!!!