Too much bull? 😛

Take a look at this: http://www.sqlis.com/post/The-Execute-SQL-Task.aspx

Not sure what you mean when you say you cannot rename the file.

When you copy the file, the file name in the destination should be the new name...

kdbarrett (9/8/2010)

---

Right, SQL Server 2008 R2, which runs VS 2008 with different options than "regular" VS 2008. So you can open SSIS projects, work on packages, etc., with VS...

Have you taken a look at the MaximimErrorCount for both the Container and the Package?

I don't know what MS has planned for that, but the way is works now, you install that...

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 variable where you should have used...

Alvin Ramard (9/8/2010)

---

Paul White NZ (9/8/2010)

---

I would speculate that the...

Jan Van der Eecken (9/8/2010)

---

LOL.

I was just thinking, if the BookID is 2GB as well, then taking an average of 2.5mm for the width of a single character on a...

Paul White NZ (9/8/2010)

---

I would speculate that the OP there...

GilaMonster (9/8/2010)

---

After a day full of stupidity, I'm just about...

Thanks for posting your solution. Others with a similar problem may be able to benefit from it.

The answer is yes.

Your SQL Script will return a recordset that will...

kdbarrett (9/8/2010)

---

Thank you both for your responses, much appreciated!

One question that arose in a meeting I just got out of was whether VS 2010 has support for SSIS. From...

FYI, the break in SSIS package compatibility happened with SQL 2008. SQL 2005 packages must be upgrade for 2008; 2008 packages are not backwards compatible with 2005. SQL...