tag:blogger.com,1999:blog-2303058199815958946.post2946466090429201302..comments2024-03-14T12:53:26.821+01:00Comments on Microsoft SQL Server Integration Services: Create a Row IdJoost van Rossumhttp://www.blogger.com/profile/01125981589974671317noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-2303058199815958946.post-33957631971685523902020-11-05T23:38:28.316+01:002020-11-05T23:38:28.316+01:00Thank you very much. It really helped!!Thank you very much. It really helped!!Surendra Parimihttps://www.blogger.com/profile/06076519243204390220noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-2869157121753125112014-02-19T10:59:51.423+01:002014-02-19T10:59:51.423+01:00Thanks a lot. It works.... I was looking for this ...Thanks a lot. It works.... I was looking for this such a long time.... Thanks you so much.... :)Ramesh Ramasamyhttps://www.blogger.com/profile/05210484979999420075noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-72276229514058802472013-05-28T10:08:46.404+02:002013-05-28T10:08:46.404+02:00Thanks a lot....Thanks a lot....Niralinoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-24619043889787031452012-10-16T20:50:50.078+02:002012-10-16T20:50:50.078+02:00Did you mean autoident instead of autoindent?Did you mean autoident instead of autoindent?JazzHarmonicathttps://www.blogger.com/profile/03328803695676763209noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-28773021754177231822012-01-03T08:36:41.391+01:002012-01-03T08:36:41.391+01:00@Anonymous: there are already third party componen...@Anonymous: there are already <a href="http://www.sqlis.com/post/Row-Number-Transformation.aspx" rel="nofollow">third party components</a> for those who don't want to use C# or VB.netJoost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-82845872528580371292012-01-03T05:16:49.004+01:002012-01-03T05:16:49.004+01:00Seems like a lot of work for a surrogate key. I h...Seems like a lot of work for a surrogate key. I hope they address this in SQL server 2012 with a sequence generator transformation. You shouldn't have to be a c# or vb coder to do a simple task like this.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-41382690150127510672011-10-11T20:41:15.851+02:002011-10-11T20:41:15.851+02:00@Anonymous: make sure that the SSIS variable and t...@Anonymous: make sure that the SSIS variable and the Script Component variable have the right data types. They should be integers. If int32 doesn't fit the number of records then you could use int64.<br />If this isn't the solution, then please <a href="http://microsoft-ssis.blogspot.com/p/contact-me.html" rel="nofollow">contact me</a> and give me the exact error message.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-68676294885480675222011-10-11T18:37:58.531+02:002011-10-11T18:37:58.531+02:00i have no idea, why i run your scrip in my ssis, t...i have no idea, why i run your scrip in my ssis, there is exception Arithmetic operation resulted in an overflow, i have no idea why, could you help me to fix upAnonymousnoreply@blogger.com