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 |
|
Bugsy
Starting Member
9 Posts |
 Posted - 2006-09-21 : 21:48:05
|
| Can't get any luck with line below, anyone knows how to do this ?EXEC master..xp_cmdshell 'dtsrun /SSNYMFNRSQLDEV01 /E /N DTSCCRMfeedTransfer' |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-21 : 23:30:07
|
| What error codes are you getting back? |
 |
|
|
Bugsy
Starting Member
9 Posts |
Posted - 2006-09-22 : 07:21:30
|
| something about 'access denied' |
|
|
|
Bugsy
Starting Member
9 Posts |
Posted - 2006-09-22 : 09:04:40
|
| this is the error message ---DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_5 DTSRun OnError: DTSStep_DTSDataPumpTask_5, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_5 DTSRun OnStart: DTSStep_DTSDataPumpTask_6 DTSRun OnError: DTSStep_DTSDataPumpTask_6, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_6 DTSRun OnStart: DTSStep_DTSDataPumpTask_7 DTSRun OnError: DTSStep_DTSDataPumpTask_7, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_7 DTSRun OnError: DTSStep_DTSDataPumpTask_4, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_4 DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_3 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun: Package execution complete. NULL |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-22 : 13:07:17
|
| Looks like it's a permission problem on the file.It's probably the sql server service that needs permission.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Bugsy
Starting Member
9 Posts |
Posted - 2006-09-22 : 13:10:10
|
| any ideas on how to fix it ? :-/ |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-22 : 13:39:37
|
| Try giving the sql server service account permission on the file.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Bugsy
Starting Member
9 Posts |
Posted - 2006-09-22 : 14:35:46
|
| >>Try giving the sql server service account permission on the file.i am not sure what you mean.The login which i use ?it is Admin forSystemServerSetupProcessBulk Insertnot for SecurityRiskDatabase |
|
|
|
|
|
|
running DTS from stored procedure