Brandie Tarvin (10/6/2010)

---

Stefan Krzywicki (10/6/2010)

---

Brandie Tarvin (10/6/2010)

---

Really? I haven't had any problems with it. What's...

Luke L (10/6/2010)

---

Stefan Krzywicki (10/6/2010)

---

jcrawf02 (10/6/2010)

---

I think that's because nobody ever considered that this was...

Brandie Tarvin (10/6/2010)

---

Really? I haven't had any problems with it. What's your issue?

EDIT: Sorry. Thought...

Speed, making sure...

jcrawf02 (10/6/2010)

---

I think that's because nobody ever considered that this was a possibility. Why are...

Grant Fritchey (10/6/2010)

---

That sentence is WAY too long:

Wow, loading data into Access is a Royal...

Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

Steve Jones - SSC Editor (10/6/2010)

---

Stefan Krzywicki (10/6/2010)

---

Where...

Alvin Ramard (10/6/2010)

---

Look to the left of any...

Where does one see the total posts on...

Brandie Tarvin (10/5/2010)

---

Stefan Krzywicki (10/4/2010)

---

Then I put a File System Task on the page and clicked it to select it. I created a variable with the scope of File System...

Alvin Ramard (10/4/2010)

---

GilaMonster (10/4/2010)

---

Craig Farrell (10/4/2010)

---

Alvin Ramard (10/4/2010)

---

GilaMonster (10/4/2010)

---

I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after...

Alvin Ramard (10/4/2010)

---

Glad you got that fix.

You can use the expression in the FileSystem Task, but if you set IsSourceVariable = TRUE and then assign the result of the expression...

Alvin Ramard (10/4/2010)

---

Stefan Krzywicki (10/4/2010)

---

Alvin Ramard (9/8/2010)

---

It looks like it's trying to find a variable with the name "\\Server\MyPath\Inbound\MyFile_20100901.zip"

Did you happen to use the expression for the value of the...

Brandie Tarvin (9/9/2010)

---

More experimenting. When I create new variables and set the variables using Evaluate as Expression and putting the expressions there, then set the FST to those variables, the...