This is a pretty helpful concept. Thanks
Now, something like this for SSIS would be pretty neat as well. 😉

Hi Sergiy, thanks for the script. Please keep us posted on...

I had the same problem and tried all mentioned methods but all failed. At the end, I realised that the source column size was exceeding the size of the item...

drew.allen (5/9/2016)

---

The 445 and 454 fiscal years only have 364 days. You have only given data for one fiscal year, so it's not clear how you are handling that...

Ahh, I should have made the font for the script link bigger in the...

I should have given a sample data, sorry!

445 vs 454 = Represents how many weeks there are in 1st, 2nd, and 3rd month of each quarter.

i.e.

445 would indicate that in...

Sergiy (5/5/2016)

---

Create a calendar table having a record for each day you company has been or will be filing tax reports.

Not sure if it's good or bad, but there are...

drew.allen (5/5/2016)

Unless your fiscal period starts on different days than the corresponding calendar period, the calculations are identical. You don't mention when your fiscal year starts, but July 1...

I got around it by using the following

C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe /f "\\<path>\test.dtsx"

executed w/o any errors

my bad, using unc with share & security permissions

...sion 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:33:25 AM Error:...

I've just created a test folder on the C drive and gave everyone full permissions however I still get the same error

I believe SSIS 2012 "Fixes" this issue with remembering the last working version of the remapping when a source or destination changes. I'll test and update back incase others are...