SSIS & CRM
-
Friday, January 25, 2013 10:48 PM
SQL2012
I have installed the Kingsway component for CRM2011
I have a custom entity called fm_Arudd. What I am trying to do is get the nest serial number from the fm_serial field. Can anyone give me any pointers?
Dont ask me .. i dont know
All Replies
-
Saturday, January 26, 2013 11:15 AMModerator
Since this is a Third Party component, you could better ask the creators of it: http://www.kingswaysoft.com/services/implementation-supportWhat I am trying to do is get the nest serial number from the fm_serial field.
Do you mean the next serial number? With an aggregation transformation you can get the max, but that could be a bit slow.
But the data is stored in a SQL Server database, so you can just query one of the views in that database.
Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
- Edited by SSISJoostMicrosoft Community Contributor, Moderator Saturday, January 26, 2013 11:21 AM
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Friday, February 01, 2013 2:35 AM

