Problem in count(*) in a job 1

[Diogo]

Hello.

I have one dts that goes to a Access database that goes a txt file to count the number of lines in the file.

When i run the dts, it just runs ok, but in the job it never runs.

Can some one help me?

Thanks any way, and sorry my English.

DR

 

[MaffewW]

DR, Is this what you are experiencing?

http://support.microsoft.com/default.aspx?kbid=269074

Matt

Brighton, UK

 

[Diogo]

Thanks.

Yes, but i have some ohter objects in that job (odbc) and it just runs ok.

Only the file txt that is in ths access, gives me problems.

DR

 

[MaffewW]

ok, pls confirm if I am understanding you correctly. you are using SQL DTS to connect to an Access database and it is doing a line count of a table in the access db and then exporting the line count to a .txt file

Matt

Brighton, UK

 

[Diogo]

No.

I'm using a SQL DTS to connect an Access database and it connect to a text file(connected as table), and then i'm exporting a count of the table(that is connected to a txt file) to a table of sql server.

What i want is esport the count of lines in a txt file to a table in sql.

DR

 

[Diogo]

Thanks.

No.
I have one SQL DTS to connect to an Access database, that have one table(connect to a txt file), to give me the number of lines in the txt file, and inserting in a sql table.

DR

 

[MaffewW]

ok, I think I see now what the DTS is doing. You have a .txt as a linked table in access. you are connecting through the virtual access table from sql dts and exporting a query of the line count to SQL server.

Is it working manually but not when you schedule it as a job? If so check that the SQL Server Agent service startup account has permission to read the .txt file from the drive on which it is stored. again, sorry if I'm still not understanding fully where the problem is

Matt

Brighton, UK

 

[Diogo]

It's just right that.

Thanks.

DR