Deployement of integration services project

I am getting the following error when I test a Job in SQL Server 2005 :
Date,Source,Severity,Step ID,Server,Job Name,Step
Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,interdata,( Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
nom de pilote non spécifié X
System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) X
System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) X
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
package execution fa... The step failed.,00:00:02,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,interdata,( Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
nom de pilote non spécifié X
System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) X
System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) X
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
package execution fa... The step failed.,00:00:05,0,0,,,,0
Why am I getting this, and how do I resolve it?
Thanks
Hi
"malek_che" wrote:

> I am getting the following error when I test a Job in SQL Server 2005 :
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
> Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,interdata,( Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
> 05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
> 2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
> nom de pilote non spécifié X
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
> retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) X
> System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) X
> System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
> package execution fa... The step failed.,00:00:02,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,interdata,( Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
> 2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
> nom de pilote non spécifié X
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
> retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) X
> System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) X
> System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
> package execution fa... The step failed.,00:00:05,0,0,,,,0
> Why am I getting this, and how do I resolve it?
>
> Thanks
It seems that the datasources have not been set up correctly, you could open
the installed package in BI studio and check the connections.
John