Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-16 : 08:48:58
|
| sanjay writes "i'm using dts in sql 7 to export the contents of a table to a text file (mytext.txt). this will be scheduled toi run each night and thus i need a date stamp put onto the end of the text file e.g. mytext_22122002.txt. have written some active x code that does this and when run manually (execute package), everything is ok. problem lies when i schedule the package to runa as a job. the job fails with message "Error Source= Microsoft VBScript runtime error Error Description: ActiveX component can't create object: 'CreateObject' Error on Line 6 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147220482 (800403FE);"strange how it runs ok manually but complains about 'CreateObject' which is used as part of the Scripting.FileSystemObject when scheduled.Please help." |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-08-18 : 19:25:49
|
| Hi sanjayHaving had similar problems myself, I'm betting that it's running with different (lower) priveleges when scheduled, so when you run it manually it's allowed to create a FileScripting Object but can't when scheduled. I think it also runs locally when you run it manually.HTH--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
export sql table to file.