May 20, 2009 at 6:28 am
I have deployed a SSIS package in File System method in a machine. My sql server is in another machine. I need call the package from stored proc using dtexec utility. For attribute /FILE i gave the network path but is not working....
C:\PROGRA~2\MICROS~2\90\DTS\Binn\dtexec /FILE "\\10.207.112.70\D:\QA\Packages_27April\Deployment_Folder\CopyParameters\CopyPackage.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /CONFIGFILE "\\10.207.112.70\D:\QA\Packages_27April\Deployment_Folder\CopyParameters\CopyPackage_Config.dtsConfig" /SET \Package.Variables[User::Source].Properties[Value];SDMAS /SET \Package.Variables[User::Destination].Properties[Value];LANDMARK /SET \Package.Variables[User::InputScreenParam].Properties[Value];"Shape Tolerances" /SET \Package.Variables[User::AreaId].Properties[Value];90 /SET \Package.Variables[User::Month].Properties[Value];2006-10-01
but is giving an error "Failed to load the package due to error 0x80070035. The network path was not found" Please help in executing the package.
May 20, 2009 at 6:49 am
At a guess, the network path in your statement is incorrect.
check that the following network paths and files exist.
"\\10.207.112.70\D:\QA\Packages_27April\Deployment_Folder\CopyParameters\CopyPackage.dtsx"
" "\\10.207.112.70\D:\QA\Packages_27April\Deployment_Folder\CopyParameters\CopyPackage_Config.dtsConfig"
May 20, 2009 at 9:12 am
Now i am getting error like "D:\QA\Packages_27April\Deployment_Folder\CopyParameters\CopyPackage_Config.dtsConfig" is not valid. Check the configuration file name.
where i gave the parameter for config file as
/CONFIGFILE "\\10.207.112.70\d$\QA\Packages_27April\Deployment_Folder\CopyParameters\CopyPackage_Config.dtsConfig"
May 20, 2009 at 9:16 am
does that file exist in that path? and can the pc you are using access it?
May 20, 2009 at 9:31 am
yes i am able to access. Following is the complete error i got. I think the dtsx file is accessible now.
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 20:34:44
Warning: 2009-05-20 20:36:34.21
Code: 0x80012012
Source: CopyPackage
Description: The configuration file name "D:\QA\Packages_27April\Deployment_F
older\CopyParameters\CopyPackage_Config.dtsConfig" is not valid. Check the confi
guration file name.
End Warning
Warning: 2009-05-20 20:36:34.21
Code: 0x80012059
Source: CopyPackage
Description: Failed to load at least one of the configuration entries for the
package. Check configurations entries and previous warnings to see descriptions
of which configuration failed.
End Warning
Warning: 2009-05-20 20:36:35.84
Code: 0x80012017
Source: CopyPackage
Description: The package path referenced an object that cannot be found: "\Pa
ckage.Variables[User::SDMAS Connection for Reverse Copy].Properties[Value]". Thi
s occurs when an attempt is made to resolve a package path to an object that can
not be found.
End Warning
Progress: 2009-05-20 20:36:35.90
Source: ldw_DashboardSettings to tblDashboardSettings
Validating: 0% complete
End Progress
Error: 2009-05-20 20:36:36.37
Code: 0xC0047062
Source: ldw_DashboardSettings to tblDashboardSettings Landmark Copy for ldw_t
blDashboardSettings & ldw_tblAreaColourDistribution [168]
Description: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC D
river Manager] Data source name not found and no default driver specified
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode r
etcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, Odb
cConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOption
s options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection own
ingObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String
assemblyQualifiedName, String connStr, Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(E
xception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.AcquireConnections(Ob
ject transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnectio
ns(IDTSManagedComponentWrapper90 wrapper, Object transaction)
End Error
Error: 2009-05-20 20:36:36.37
Code: 0xC0047017
Source: ldw_DashboardSettings to tblDashboardSettings DTS.Pipeline
Description: component "Landmark Copy for ldw_tblDashboardSettings & ldw_tblA
reaColourDistribution" (168) failed validation and returned error code 0x8013193
7.
End Error
Progress: 2009-05-20 20:36:36.37
Source: ldw_DashboardSettings to tblDashboardSettings
Validating: 33% complete
End Progress
Error: 2009-05-20 20:36:36.37
Code: 0xC004700C
Source: ldw_DashboardSettings to tblDashboardSettings DTS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2009-05-20 20:36:36.37
Code: 0xC0024107
Source: ldw_DashboardSettings to tblDashboardSettings
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 20:34:44
Finished: 20:36:36
Elapsed: 112.343 seconds
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply