how to load limited records?

[#1]

Hi,

Can I know after I connected to the server as below, How can say to retrieve only 2014's data  

OLEDB CONNECT32 TO [Provider=XXX.1;User ID=XXX;Data Source=XXX] (XPassword is abc123);

[tresesco]

Try like:

SQL Select

          Field1, Field2

From <> Where YearField=2014;

[ashfaq_haseeb]

Hi,

Try something like this.

Load

F1,

F2,

DATEField

sql select * from Table

where Year(DATEField) = 2014;

Rehards

ASHFAQ

[#4 · Accepted solution]

This should be done in the SQL Query, When you load data

select*from (database)  where (date field) between  '2014/01/01' and  '2014'12/31'

example

select*from  sys.scheme.customers where created_date  between  '2014/01/01' and  '2014'12/31'

customers table has customer crated_date field recording customer dates.

Hope this will help you.

Cheers

Chamila