I've downloaded this and installed it but i seems to fail to get this item into my data flow items list. i've read the readme.txt but i think the part where they explain the build is poorly explained.
For example - Place gacutil.exe (packaged with Visual Studio) on the system path. --> wtf
Anyone can help me get this component in my visual studio working
Thanks
You need to right-click in the toolbox, click on 'choose items...' and then click the 'ssis data flow items' tab and select your new component.
I tried that but the problem is that its not in the list, i've did the install of the msi file and now i'm stuck i"ve looked in the data flow items but its not there 
Okay, I've made it a little farther trying to get this to work for you, but I'm stuck too. I agree, the 'building the component' section is written poorly.
I interpreted '- Place gacutil.exe (packaged with Visual Studio) on the system path.' as copying the gacutil.exe file to the same directory you saved the calendar transform. So I copied it from 'C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin' to the calendar transform directory. Next I opened the opened the visual c# project in BIDS and then followed the rest of the instructions under 'building the component'. After building the project, I never saw the message "Assembly successfully added to the cache" that the documentation says I should have seen. Is this because the gacutil.exe was copied to the wrong directory Anyways, after looking at directory 'C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents' I can see the CalendarTransform.dll is now there, but when I try to add the component to the toolbox it is still nowhere to be found.
Maybe this will get you on the right track. I'll keep trying, but maybe someone else has some advice on getting this to work.
Try adjusting the regcomponent batch to include a full path enclosed in quotes...
"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\"gacutil.exe /u %1
"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\"gacutil.exe /i %1.dll
copy %1.dll "c:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents"
and on the post-build event command line ..\..\regcomponent unpackdecimal
(replace unpackdecimal with the appropriate package name)
NOTE: I also went through quite a bit of headscratching trying to get the microsoft downloads to work following their readme's.
Also, see the following thread on GACing Components...
http://forums.microsoft.com/msdn/showpost.aspx postid=66049&siteid=1
BIDS - Business Intelligence Development Studio. This is a plugin for the visual studio and allows you to create the SQL Integration Services, Reporting Services, and Analysis Services packages. If you were clicking on your "toolbox" trying to register the componenet you are already using bids.
None of this is that terribly difficult. It's just that the microsoft readme for the downloadable custom transforms wasn't written well. I would suggest you give it another try, it's really not that complicated.
I opened the opened the visual c# project in BIDS --> how do you open it, there is no solution file
What would really help me is a decent manual step by step how to get this reference working. If anyone could create it (preferably with screenshots
) i'm sure it would help out alot of people.
Instructions for installing the microsoft custom components:
1. download and install the msi
2. open the csproj file
3. either:
open the regcomponent.cmd file and change to:
"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\"gacutil /u %1
"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\"gacutil /i %1.dll
copy %1.dll "c:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents"
OR
Register the gacutility.exe in the system path.
The system path is a list of folders, separated by a semicolon, that identifies the folders that the system should search when looking for files that are called from the Run dialog box, command line, or other processes. Normal program installation changes this path to include the program's installation path. To change the system path, perform these steps:
4. right-click on the calendar transform project, choose properties.
5. click on the signing tab
6. choose <new> under choose a strong name key file
7. Name: CalendarTransform.snk {keep password checked and fill in and verify a password}
8. Click on the Build menu and choose Build solution (it will ask you to save a solution, do so)
At this point you should see something about the component being registered with the GAC Utility.
9. Open an SSIS project, right click on your toolbox, choose "choose items"
10. Click on the "SSIS Data Flow Items" Tab
11. Check the Calendar Transform item
At this point you should see the Calendar Transform available if you are on the data flow tab of an SSIS package.
Eric Wisdahl --> thanks mate good manual. But the reason why it wasn't working for me was because i have visual studio (but BI only) seems you have to install the entire visual studio enviroment with c#, c++, ... before you can actually use it.
thanks for the helps mates