tag:blogger.com,1999:blog-6343264636303861274.comments2023-06-14T06:33:16.585-07:00SQL Developer RamblingsDouglas Dayhttp://www.blogger.com/profile/13484855502495564606noreply@blogger.comBlogger35125tag:blogger.com,1999:blog-6343264636303861274.post-73086168082935759912021-06-16T06:14:23.022-07:002021-06-16T06:14:23.022-07:00Thank you so much for providing information about ...Thank you so much for providing information about SSIS and other such aspects of IT which helps in solving many complex IT problems.<br /><a href="https://zappysys.com/products/SSIS-powerpack/SSIS-upsert-destination" rel="nofollow">SSIS Upsert</a><br /><br />Chris Lesnarhttps://www.blogger.com/profile/00483876665824529326noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-6820920868645274112020-05-19T08:25:27.286-07:002020-05-19T08:25:27.286-07:00Hello! This is my first visit to your blog! We are...Hello! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us useful information to work on. You have done an outstanding job.<br /><a href="https://www.acte.in/c-c-plus-plus-training-institute-in-chennai" rel="nofollow"> C and C++ Training Institute in chennai </a> | <a href="https://www.acte.in/c-c-plus-plus-training-institute-in-annanagar" rel="nofollow"> C and C++ Training Institute in anna nagar</a> | <a href="https://www.acte.in/c-c-plus-plus-training-institute-in-omr" rel="nofollow"> C and C++ Training Institute in omr</a> | <a href="https://www.acte.in/c-c-plus-plus-training-institute-in-porur" rel="nofollow"> C and C++ Training Institute in porur</a> | <a href="https://www.acte.in/c-c-plus-plus-training-institute-in-tambaram" rel="nofollow">C and C++ Training Institute in tambaram</a> | <a href="https://www.acte.in/c-c-plus-plus-training-institute-in-velachery" rel="nofollow"> C and C++ Training Institute in velachery</a><br />subhahttps://www.blogger.com/profile/10947742613988650398noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-61440422658464095902019-04-04T04:46:20.352-07:002019-04-04T04:46:20.352-07:00I am not sure about whether anybody here is intere...I am not sure about whether anybody here is interested for a third-party product but I genuinely think you should look for <a href="https://zappysys.com/products/ssis-powerpack/ssis-upsert-destination/" rel="nofollow">SSIS Upsert</a> destination which is used to merge/synchronize data from source to target.James Zicrovhttps://www.blogger.com/profile/00094356083987556970noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-71958616824829778872019-02-20T03:59:17.276-08:002019-02-20T03:59:17.276-08:00Thanks for sharing a good article. This is very in...Thanks for sharing a good article. This is very interesting and I like this type of article only. I have always read important article like this.<br /><a href="https://www.fita.in/c-c-training-in-chennai/" rel="nofollow"> C C++ Training in Chennai </a><br /><a href="https://www.fita.in/c-c-training-in-chennai/" rel="nofollow"> C Training in Chennai </a><br /><a href="https://www.fita.in/core-java-training-in-chennai/" rel="nofollow"> core java training in chennai </a><br /><a href="https://www.fita.in/javascript-training-in-chennai/" rel="nofollow"> javascript training in chennai </a><br /><a href="https://www.fita.in/javascript-training-in-chennai/" rel="nofollow"> javascript course in chennai </a><br /><a href="https://www.fitaacademy.com/courses/core-java-training-in-chennai/" rel="nofollow"> core java training in chennai </a><br /><a href="https://www.fitaacademy.com/courses/core-java-training-in-chennai/" rel="nofollow"> core java training </a>sandeep saxenahttps://www.blogger.com/profile/13483555089278854417noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-47466112425578077222016-08-22T23:55:42.439-07:002016-08-22T23:55:42.439-07:00am also getting same error can you pls hekp us
[...am also getting same error can you pls hekp us <br /><br />[Script Component [23]] Error: Google.GData.Client.GDataRequestException: Execution of authentication request returned unexpected result: 404<br />at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)<br />at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()<br />at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)Saranghttps://www.blogger.com/profile/15710945465808460322noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-53800471674104368232015-12-17T11:26:07.233-08:002015-12-17T11:26:07.233-08:00I'm using the 2010 shell, and had to add the r...I'm using the 2010 shell, and had to add the reference in a different way in order to enable the 2.0 framework - and make the object types and methods described above available.<br />1. Right-click the project node and select "Add Service Reference..."<br />2. At the bottom of the dialog box, click "Advanced"<br />3. At the bottom of the second dialog, click "Add Web Reference".<br /><br />See http://msdn.microsoft.com/en-us/library/bb628649.aspxAnonymoushttps://www.blogger.com/profile/09530106603271985211noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-85469645053060920742015-10-07T13:58:53.238-07:002015-10-07T13:58:53.238-07:00[Script Component [23]] Error: Google.GData.Client...[Script Component [23]] Error: Google.GData.Client.GDataRequestException: Execution of authentication request returned unexpected result: 404<br /> at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)<br /> at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()<br /> at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-77692134311559825332015-10-07T13:43:07.182-07:002015-10-07T13:43:07.182-07:00Could someone please advise as the Data Flow Task ...Could someone please advise as the Data Flow Task shows status as Pre-Execute -50 percent complete.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-29426079703733248262015-10-07T13:38:44.264-07:002015-10-07T13:38:44.264-07:00Have tried this and process hans on Pre-Execute -5...Have tried this and process hans on Pre-Execute -50 percent completeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-10782208978265652742015-01-26T05:54:20.766-08:002015-01-26T05:54:20.766-08:00Hi, I have used this and it helped me alot, but I ...Hi, I have used this and it helped me alot, but I have come a cross problem. My script component is only reading 100 records. How do I change that? <br /><br />Thank youAnonymoushttps://www.blogger.com/profile/13964485339239552838noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-26232504300456940412015-01-25T17:01:48.052-08:002015-01-25T17:01:48.052-08:00Hi Guys,
Its working the following two settings n...Hi Guys,<br /><br />Its working the following two settings needs to be for SQL 2012/2014<br /><br />1. On the main menu, change the debug to ‘Release’<br />2. Go to Build Properties of the Solution and Turn Off the ‘Generate Serialization Assembly’<br /><br />Regards<br /><br />AyyanarAnonymoushttps://www.blogger.com/profile/11213250497487799865noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-53638865710069791822015-01-25T15:32:15.640-08:002015-01-25T15:32:15.640-08:00Hi, I am trying to work with SQL 2012 and getting ...Hi, I am trying to work with SQL 2012 and getting Binary code not found while just adding the web reference. Can you please help me ?<br /><br />Regards<br /><br />AyyanarAnonymoushttps://www.blogger.com/profile/11213250497487799865noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-79165646744213119072014-01-22T01:50:26.222-08:002014-01-22T01:50:26.222-08:00populate Pivot grid control with dynamic data<a href="http://www.kettic.com/winforms_ui/csharp_guide/pivotgrid_populate_data.shtml" rel="nofollow">populate Pivot grid control with dynamic data</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-65893449689546375682013-11-26T15:59:27.415-08:002013-11-26T15:59:27.415-08:00Just FYI, I did use an ADO.NET connector!Just FYI, I did use an ADO.NET connector!Ron Cashhttps://www.blogger.com/profile/09424456436162782385noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-35883245421461093502013-11-26T15:12:21.003-08:002013-11-26T15:12:21.003-08:00Error 1 'Sample' is not a member of 'S...Error 1 'Sample' is not a member of 'SC_3bb4f72cd9c540b399ee23e2bfe697d0.vbproj.Connections'. C:\Users\rc203b\AppData\Local\Temp\SSIS\7f2105d2aa4542bcb750393f26b10489\main.vb 69 26 sc_3bb4f72cd9c540b399ee23e2bfe697d0<br /><br />I'ver tried this in two environments!<br /><br />Thanks for this script by the way. I can really use this in my SSIS packges if I can get the connection working.Ron Cashhttps://www.blogger.com/profile/09424456436162782385noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-13843079341006165042013-11-02T00:14:23.094-07:002013-11-02T00:14:23.094-07:00Thank you very much for this post Douglas Day. I h...Thank you very much for this post Douglas Day. I have been struggling to achieve this task from one week.<br /><br />Keep posting such helpful posts.<br /><br />Thanks,<br />Rahul.Rahulnoreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-80448760336085472952013-05-17T00:02:59.203-07:002013-05-17T00:02:59.203-07:00Nice info and coding. I have learn more info from ...Nice info and coding. I have learn more info from your blog. thanks for sharing...<br /><br />Hire SSRS developershttp://www.optisolbusiness.com/index.php/ssrs-developmentnoreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-14267038399654142762013-05-07T07:33:48.958-07:002013-05-07T07:33:48.958-07:00Thanks for this - nicely succinct and useful artic...Thanks for this - nicely succinct and useful article.<br /><br />@Allan - for reference, the snippet you'd need to work with is around the objWorkSheetFeed object - Entries(0) will be the first tab, Entries(1) will be the second etc. Check the documentation link for details (specifically - "Working with worksheets")Anonymoushttps://www.blogger.com/profile/11326105871430260484noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-14955780535968666012013-03-03T09:00:39.851-08:002013-03-03T09:00:39.851-08:00Paula,
U might not have added correct web referenc...Paula,<br />U might not have added correct web reference,it worked on 2012 <br /><br />Many Thanks<br />Chandu<br />BIDeveloperhttps://www.blogger.com/profile/13371529883167270416noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-9742668162612368782013-03-03T08:58:12.119-08:002013-03-03T08:58:12.119-08:00This comment has been removed by the author.BIDeveloperhttps://www.blogger.com/profile/13371529883167270416noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-77836299564824482842013-02-28T15:36:29.608-08:002013-02-28T15:36:29.608-08:00Has anyone tried this in 2012, with .net 4.0 frame...Has anyone tried this in 2012, with .net 4.0 framework? I am getting errors that things like .credentials and .url don't exist. Any help is much appreciated.<br />Thanks,Anonymoushttps://www.blogger.com/profile/05355993023402568054noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-31078942737330852662012-10-12T02:12:43.320-07:002012-10-12T02:12:43.320-07:00Very helpful. I have an issue that when I run the ...Very helpful. I have an issue that when I run the script in SSIS it opens the Visual Studio Shell. Why does this happen?Kevin Badgerhttps://www.blogger.com/profile/00768887659919855818noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-47463437271010213432012-09-18T05:34:58.618-07:002012-09-18T05:34:58.618-07:00Genuinely it superb blog in my opinion so thanks f...Genuinely it superb blog in my opinion so thanks for sharing it, i will be thankful to this.file extension taxhttp://www.fileviewpro.com/en/file-extension-taxnoreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-19340023619171520062012-08-08T02:20:45.562-07:002012-08-08T02:20:45.562-07:00Super helpful but i need to be able to connect to ...Super helpful but i need to be able to connect to specific spreadsheet in the Google doc. How would i do that?Anonymoushttps://www.blogger.com/profile/00612599357456685218noreply@blogger.comtag:blogger.com,1999:blog-6343264636303861274.post-8090669533917454532012-07-25T03:58:33.727-07:002012-07-25T03:58:33.727-07:00thank you, for the brilliance in the simplicity.
Y...thank you, for the brilliance in the simplicity.<br />YulanAnonymousnoreply@blogger.com