December 9, 2009 at 1:39 pm
I am trying to run DTEXEC from a command entry screen as follows (this is the simple try...once this is running I'll add more parms and see if I can get further)
DTEXEC /SER ROESIS800Q /DT "MSDB\MML_IE\DEV\FMK\PROD COPY_3_MA_TABLES" /CONNECTION "DESTINATION; '\' DATA SOURCE=RONFDN003Q\FDNPRD04;
This ends up giving me the following error:
Error: 2009-12-09 14:35:32.65
Code: 0xC0202009
Source: PROD Copy_3_MA_tables Connection manager "DESTINATION"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for ODBC Drivers" Hresult: 0x80004005 Description:
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
End Error
What am I doing wrong?
December 9, 2009 at 2:20 pm
kolb.branden (12/9/2009)
I am trying to run DTEXEC from a command entry screen as follows (this is the simple try...once this is running I'll add more parms and see if I can get further)DTEXEC /SER ROESIS800Q /DT "MSDB\MML_IE\DEV\FMK\PROD COPY_3_MA_TABLES" /CONNECTION "DESTINATION; '\' DATA SOURCE=RONFDN003Q\FDNPRD04;
This ends up giving me the following error:
Error: 2009-12-09 14:35:32.65
Code: 0xC0202009
Source: PROD Copy_3_MA_tables Connection manager "DESTINATION"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for ODBC Drivers" Hresult: 0x80004005 Description:
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
End Error
What am I doing wrong?
Did you try and specify the port number for the named instance?
i.e. DATA SOURCE=RONFDN003Q\FDNPRD04,1433;
You'll want to replace 1433 with the TCP port for this instance...you can pull this information from configuration manager or from registry; i.e.
select @@servername
go
declare @port varchar(5)
exec xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Microsoft\Microsoft SQL Server\FDNPRD04\MSSQLServer\SuperSocketNetLib\Tcp',
@value_name='TcpPort',
@value=@port output
print @port
go
Tommy
Follow @sqlscribeViewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply