Hi,

Create one variable ( Rcount int )and ado.net db connection. Drag the execute sql task and set the connection type as ADo.net and choose the the above created connection and...

Hi,

Can you check whether the account is having required permission to execute the job?

The user (running sql agent service) should have the proper permission.

DTEXEC /FILE "C:\PackageName.dtsx" /MAXCONCURRENT " -1 "...

I will give more details.

Two tables.

1. table1 ( rid varchar(20),rname varchar(20))

2. table2 (rid varchar(20),raddress varchar(20))

The records are

table1: '123','rname1'

table2: '123 ','USA'

SQL box:

select * from table1 a inner join table2 b...

I got the "Unspecified Error" when trying to configure a lookup transformation.If I use same package in different server.Its working fine.

Can any one tell me the fix for this problem?