SQL Server date functions don't calculate FISCAL dates very well mainly because of the multiple ways you can assign the 5th week of the month. I understand that your...

if the data comes in using a consistent format such as 123-45-67890 2009-03-23 Then you could use a substring to split the date and ssn into separate columns using...

It sounds as if you are trying to report based upon a FISCAL Calendar which SQL does little support. In a true fiscal Calendar you break the year into...

I know this is probably to late but another option that would leverage SSIS would be to:

1) Data Source as for your excel

2) Lookup task that would load the columns...

Are you looking to have the value be the most recent value regardless of how the axis are defined? If so you may want to try the LastChild Aggregate...

If the empty file doesn't appear until the data file has been completely transferred and they are willing to change the name then that sounds like one of the easier...

You have to Remember SSIS is an ETL enviroment which is designed to allow you to transform data through a known process. SSIS is not a programming enviroment that allows...

You can enable package configurations that would set say a Status variable that would be used on a conditional workflow. To run or not run specific tasks. You...

Third possible option is to write your destination using a custom script task. Then you could build everything you are doing in your current script into your destination script...

Does the empty file have a specific filename that differs from the datafile? Like yyyymmddLoadctl.txt? if so you can check for the existance of that file and if...

Since SSIS moves data through the process in Buffer pages you can't set the output of a row to have a dynamic destination within the same buffer. All rows...

Prior to your aggregate task that you use to remove the duplicate records you have a multicast that would output to your agg task that removes the dupe and a...