Yup, everything ran fine. Saw the box turn Green. 🙂 But the filename remains the same "Output_.xls." Do I need to do anything else in the...

Hey Phil,

Do I need to change anything in that script? I'm pretty sure I followed everything. I created a string variable called SourceFile that contains the location/filename of...

SSIS (7/15/2009)

---

OK, so I was able to successfully copy the Excel file from one location to another, but I don't know how to include the date/month in the filename after...

OK, so I was able to successfully copy the Excel file from one location to another, but I don't know how to include the date/month in the filename after it's...

Sure, it's easy once you put it that way... 😉 Sorry for the late reply, I've been on vacation. hehe

I'll give it a try and let you know! ...

Cool, thanks! This one looks less complicated than Datepart. Thanks again for your help!

I just need to run a query that will pull data from the past month. So basically:

SELECT * FROM Output

WHERE Date BETWEEN '01/01/2009' AND '01/30/2009'

But wanting to automate it,...