Thanks! Now I know monitoring the queries.

But how to know I logging the slow queries (Examlpe the time of query bigger then 5 seconds)?

Then change this line:

Where proj.DATAAREAID = 'ajb' AND shed.DATAAREAID = 'ajb'

on this:

Where proj.DATAAREAID = 'ajb' OR shed.DATAAREAID = 'ajb'

Please check this query:

Select 'All' AS 'EmplID', 'All' AS 'Name', 0 AS 'SortOrder'

Union ALL

Select DISTINCT pe.EMPLID, pe.Name, 1...

Thanks! It is great! 🙂

I'm going to read the forum now.

I'm sorry.

Then I come more seldom.

Please check this query:

SELECT name, physical_name, type_desc, size as used_space,

CASE max_size WHEN -1 THEN 'N/A' ELSE CAST(max_size - size AS NVARCHAR) END as free_space,

CASE max_size WHEN -1 THEN 'No...

Thanks your replay!

I sloved this problem. I rename the name of dbf file 'MBTMP' with xp_cmdshell and I run this command:

SELECT * FROM LS_DBF...MBTMP. This query always successfull. Than I...

Hopp, i was wrong. SQL Server 2005 use Microsoft Jet 4.0 provider.

I looking for Microsoft Jet 4.0 provider on SQL Server 2008 x64 (or Windows Server 2008 x64) on the...

Yes, I did.

Deleted.

Thanks your replay!

The name of dbf files always change (tavszall + YYYY-MM-DD + .dbf; Example: tavszall2011-12-11.dbf).

If I understand you, then I cannot use simple datafollow task this exercise.

Thanks your answer!

Thanks your replay!

I want to load all DBF file from a directory (and import a table of SQL server database every Monday).

Is it possible with SSIS?

Those pictures are here.

Hello!

Thanks your replay!

Those pictures are here:

1.)

2.)

3.)

4.)

5.)

6.)

7.)

8.)

9.)

10.)

11.)

12.)

13.)

14.)

15.)

16.)

17.)

18.)

Hello!

Thanks your replay.

Please see this link: http://salliven.site11.com/dbf_load/