November 7, 2011 at 11:54 pm
hello all.
i use this syntax for execute ssis package:
EXEC xp_cmdshell 'dtexec /f "C:\DbfExport.dtsx"'
and sql server 2008 64bit runs on win server 2008.this script get error:
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.2531.0 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started: 09:55:27 ق.ظ
Error: 2010-11-08 09:55:28.04
Code: 0xC0016016
Source:
Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that
the correct key is available.
End Error
Progress: 2010-11-08 09:55:28.67
Source: Data Flow Task 1
Validating: 0% complete
End Progress
Progress: 2010-11-08 09:55:28.96
Source: Data Flow Task 1
Validating: 33% complete
End Progress
Error: 2010-11-08 09:55:29.01
Code: 0xC0209303
Source: DbfExport Connection manager "DestinationConnectionOLEDB"
Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider VFPOLEDB.1 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
End Error
Error: 2010-11-08 09:55:29.02
Code: 0xC020801C
Source: Data Flow Task 1 Destination - dskwor00 [97]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0209303. There may be error messages posted before thi
s with more information on why the AcquireConnection method call failed.
End Error
Error: 2010-11-08 09:55:29.02
Code: 0xC0047017
Source: Data Flow Task 1 SSIS.Pipeline
Description: component "Destination - dskwor00" (97) failed validation and returned error code 0xC020801C.
End Error
Progress: 2010-11-08 09:55:29.02
Source: Data Flow Task 1
Validating: 66% complete
End Progress
Error: 2010-11-08 09:55:29.02
Code: 0xC004700C
Source: Data Flow Task 1 SSIS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2010-11-08 09:55:29.02
Code: 0xC0024107
Source: Data Flow Task 1
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 09:55:27 ق.ظ
Finished: 09:55:29 ق.ظ
Elapsed: 1.84 seconds
NULL
please help me that solve this error.thanks
November 8, 2011 at 3:15 am
As far as I am aware the Visual Fox Pro Ole provider (VFPOLEDB) is not 64-bit compatible, you will need to run this package in 32-bit mode.
November 8, 2011 at 4:39 am
I see.but how to run this package in 32 bit mode in script?
November 8, 2011 at 4:49 am
use the /X86 flag to run in 32-bit mode
this is only for the agent, not too sure how you do it from the command line. I assume you will need to use the 32-bit executable.
November 8, 2011 at 4:55 am
thanks for your reply.please write script for me.i donot know where is use /X86?
November 8, 2011 at 5:03 am
Are you going to use the agent to run this job? if so you can simply click on the run in 32bit mode flag.
If you are going to use the command line, I recomend using the agent , but you may have a reason for running in this mode.. then you will need to use the 32-bit executable that 'should' be in your program files(X86) folder.
November 8, 2011 at 5:11 am
i run this ssis with job and execute succesfully.and i use :
exec xp_cmdshell '"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec.exe" /f C:\DbfExport.dtsx'
but get error :
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.1600.22 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started: 03:39:09 ?.?
Error: 2010-11-08 15:39:10.29
Code: 0xC0016016
Source:
Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that
the correct key is available.
End Error
Progress: 2010-11-08 15:39:11.12
Source: Data Flow Task 1
Validating: 0% complete
End Progress
Progress: 2010-11-08 15:39:11.30
Source: Data Flow Task 1
Validating: 33% complete
End Progress
Warning: 2010-11-08 15:39:11.31
Code: 0x80202066
Source: Data Flow Task 1 Destination - dskwor00 [97]
Description: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page
values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
End Warning
November 8, 2011 at 5:24 am
The account that you are running this under, does not have the correct permisions. If you running this from SQL server then you will need to have the account you are using to have the correct permissions for the SSIS pacakge.
Is there any reason you do not want to use an agent job?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply