This is the way to calculate 'yesterday' in an Access query:

DateAdd("d",-1,Date())

Surely this is a T-SQL question, not SSIS?

Emma-239540 (5/24/2010)

---

i got the evaluation expression as below in the Collection editor

RIGHT( @[User::lacarefilename] ,7 ) !="HFF.csv"

The package is not supposed to process because in that folder i only have...

Glad it worked.

Sorry - I did not read...

Could you just divide it by 100?

Which...

What is the data type, in Access, of the TIME column?

You can DEFINITELY use a WHERE clause in Access.

Try building the query in Access - might speed things up for you. When it's working, just grab the SQL and then...

da-zero (5/21/2010)

---

Phil Parkin (5/21/2010)

---

da-zero (5/21/2010)

---

Yeah, I'm very fortunate to have never worked with Access before, so I didn't realize the getdate() function doesn't exist in Access. Apparently Now() is the...

There should be no space before 'TIME' in your query.

da-zero (5/21/2010)

---

Yeah, I'm very fortunate to have never worked with Access before, so I didn't realize the getdate() function doesn't exist in Access. Apparently Now() is the equivalent (Google is...

getdate() is not a valid function in Access.

Try using Date() instead.

By the way, Select * is bad practice. It is better if you select all the fields explicitly by name....

Do this at source, if possible, by using a query instead of a table as your data source. Does that answer your question, or were you wondering how to write...

When I import dates held as strings, I usually put them in universal format (YYYY-MM-DD HH etc etc) via a derived column and then map them to the target field....