Thats where expressions will come in handy, you can build up the filename as required.

Something like this:

"FileName" + (DT_STR, 4, 1252) YEAR(GETDATE()) + (DT_STR, 2, 1252) MONTH( GETDATE())...

The ForEach Loop container has a property called MaximumErrorCount, it's default value is 1, increase the value of this property, it should work.

Here is the discription of the property from...

Use a ForEach loop container to loop through all the files in the specified folder, place a File System Task inside the ForEach container and use the Rename file operation....

The Merge Join control will generate the joins necessary to link these tables. Using a Merge Join control is similar to writing inner joins.

Check Merge Join in BOL for an...

Thanks Andrew, much appreciated! 🙂

Yeah my idea to was to add a leading zero, that would sort it perfect!

I aggree with WRACK... 'Inside Microsoft® SQL Server™ 2005: T-SQL Querying' was a good read! Good examples too!

Extracting customer data from the Adventure Works database is an idea...

Hey, no worries, SSC Journeyman sounds like some superhero 😀

Are you using a ForEach control task?

With this question do you mean that you want to be able to select a start and end date and then pass these parameters to a SP that will return...

Hi

Your expression syntax is not right. When you need double quotes in your expression add a backslash before the double quote. Check the expression below as an example:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Development\\Documentation\\File1.xls;Extended Properties=\"Excel...

Sounds like you need to write a query that groups by user and selects MAX date and also joins to a cost table. Which table are the costs coming from?...

Yip, if you create an INSTEAD OF INSERT TRIGGER on your table it will pick up each instance where an insert statements is being executed on your table. I am...

So from what I understand you dont have control over the insert statements... Have you thought of writing a trigger on that table to intercept the SQL statement?

There is a RANK function that works very similar to the ROW_NUMBER() function which would work better for your situation. check BOL for the RANK function. You would use the...