March 28, 2007 at 8:18 am
I am having a strange problem when getting the DTS run through a batch job(created as a .cmd file) . If i run this .cmd file from command prompt it works fine but when setting it as a scheduled task thru windows scheduler its failing with the following message
DTSRun: Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not been called.
dstrun process failed.
Any idea why this is happening. Any help on this will be greatly appreciated.
TIA
March 28, 2007 at 11:42 am
are you sure that the user who runs the SQL Server and SQL Agent services has the same rights as the user who runs the .cmd file from the command line? Try running the .cmd file from the command line while logged in as the user who runs the SQL Server and SQL Agent services.
Carlos
March 29, 2007 at 8:13 am
To find out which user account runs the SQL Server and SQL Agent services, do the following on the server:
Open up the "Services" listing on the server (Not sure why type of operating system you are running SQL Server on but in general to locate the "Services" listing: Control Panel -> Administrative Tools -> Computer Manangement -> Services). Locate the entries for SQL Server and SQL Agent. Look at the "Properties" for each service to find out which account the service "logs in" as.
Norene Malaney
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply