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

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,i
nterdata,(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,i
nterdata,inter,,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 &#
91;IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuv
able et
nom de pilote non spécifié _
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) _
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) _
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbCon
nection
owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... The
package execution fa... The step failed.,00:00:02,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,i
nterdata,(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,i
nterdata,inter,,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 &#
91;IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuv
able et
nom de pilote non spécifié _
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) _
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) _
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbCon
nection
owningConnection<c/> DbConnectionPoolGroup poolGroup) _ 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?
ThanksHi
"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,i
nterdata,(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,i
nterdata,inter,,Execute
d
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Erro
r:
> 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 intro
uvable et
> nom de pilote non spécifié _
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCod
e
> retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) _
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOption
s
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) _
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... T
he
> package execution fa... The step failed.,00:00:02,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,i
nterdata,(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,i
nterdata,inter,,Execute
d
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Erro
r:
> 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 intro
uvable et
> nom de pilote non spécifié _
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCod
e
> retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) _
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOption
s
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) _
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... T
he
> 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

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,inter,,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é Ã
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) Ã
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) Ã
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã 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,inter,,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é Ã
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) Ã
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) Ã
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã 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?
ThanksHi
"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,inter,,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é Ã
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
> retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) Ã
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) Ã
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã 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,inter,,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é Ã
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
> retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) Ã
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) Ã
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã 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