imani_technology (5/27/2010)

---

I have two variables: varNewPeriod and varCurrentPeriod. If varNewPeriod > varCurrentPeriod, I want to build a string and run it in a certain Execute Process Task within...

I'm sure that we can find something.

Can you give us an idea of what you're doing and why it has to be in script?

When you remote in to the server, do you use the same network login credentials as you use on your local PC?

Does it work if you run the batch file outside of SSIS while remoted in?

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?