| Author |
 Topic Search  Topic Options
|
socialanimal 
Newbie
Joined: 14 October 2007
Location: Leeds, UK
Status: Offline
Points: 39
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 05 November 2007 at 3:02pm |
Ok thats even stranger, if all permissions and everything are set to how they should be  Can you run a trace in the SQL profiler and see exactly what it says in there ? ...
|
 |
socialanimal
Newbie
Joined: 14 October 2007
Location: Leeds, UK
Status: Offline
Points: 39
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 November 2007 at 3:05pm |
|
Found this:
http://www.asp101.com/articles/carvin/dts/default.asp
Got some interesting points about what accounts are used when executing DTS from web page.
|
|
Gary
Senior Member
Joined: 20 March 2002
Location: United Kingdom
Status: Offline
Points: 326
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 November 2007 at 3:05pm |
I'll give that a go and report back.
In the meantime, I enabled error logging and this is what I got:
Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft JET Database Engine
Step Error Description:Failure creating file.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:5003436
Step Execution Started: 05/11/2007 15:02:54
Step Execution Completed: 05/11/2007 15:02:54
Total Step Execution Time: 0.08 seconds
Progress count in Step: 0
|
|
socialanimal
Newbie
Joined: 14 October 2007
Location: Leeds, UK
Status: Offline
Points: 39
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 November 2007 at 3:10pm |
 Gary wrote:
I'll give that a go and report back.
In the meantime, I enabled error logging and this is what I got:
Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft JET Database Engine
Step Error Description:Failure creating file.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:5003436
Step Execution Started: 05/11/2007 15:02:54
Step Execution Completed: 05/11/2007 15:02:54
Total Step Execution Time: 0.08 seconds
Progress count in Step: 0
|
Do i take it that task_1 is the excel file being used as a data source ? If its trying to create a file using the IIS account, this could be to blame.
|
|
Gary
Senior Member
Joined: 20 March 2002
Location: United Kingdom
Status: Offline
Points: 326
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 November 2007 at 3:15pm |
Yes, task_1 is where I try to import data from the Excel file.
"If its trying to create a file using the IIS account" - I am not creating a file inthe DTS. All I am tryingto do is read from a file (Excel) and imprt the data from the file into a SQL table.
|
|
socialanimal
Newbie
Joined: 14 October 2007
Location: Leeds, UK
Status: Offline
Points: 39
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 November 2007 at 3:21pm |
|
Hmmm ....
The createfile() error in the description is covered in the MSKB http://support.microsoft.com/kb/q175671/. This may help ?
|
|
Gary
Senior Member
Joined: 20 March 2002
Location: United Kingdom
Status: Offline
Points: 326
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 November 2007 at 4:27pm |
Interesting MSKB article there....
I have tried running SQL Setup (from the CD) but cannot see anything to do with "Change Network Support".
For something that you'd expect to be pretty much straight forward, this is turning into a nightmare 
|
|
socialanimal
Newbie
Joined: 14 October 2007
Location: Leeds, UK
Status: Offline
Points: 39
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 November 2007 at 4:29pm |
Yeah can imagine !
I'm trying to consider what it could possibly be, other than it being an issue with the incorrect user login being used (ie the IIS account rather than your own).
Could you post the code your using (obviously minus the authentication details) 
|
|
