stewartc-708166 (5/26/2010)

---

In SSIS, data flow task, there is an XML data source that you could use for this.

To update the XML file (or create a new file) you could use...

Bravo - you beat me to it 🙂

sachinrshetty (5/26/2010)

---

Hi,

Phil Parkin, da-zero, skcadavre

Your query works fine but since Time column has datetime value if i use '=' operator it fetches only rows having...

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...