NET PR's Q&A profile

• SQL Server Transformation from 10 views oracle to sql server

  I have to come up with a SSIS package to tranform data from oracle database to our sql server database. This oracle db is managed by a third party , I have been given 10 views from oracle so I can extarct information I need. How should I design my SSIS package Do I have to have 10 different data flows or there is an eaier way to run my 10 select statements from these views Is there any article that can give me some ideas on how to design SSIS packages to extract information from oracle Thanks a lot Rafael Salas wrote: Anytime you change the structure of the query the package will break; there is no way to make the package refresh the metadata inside of the dataflow dynamically. If you ...Show All

• Visual Basic Print graphics that are on the form into PDF

  I have placed many objects into the form ,like circle, square, images, etc etc directly on the forms background. Now i want to know how to take printout of them directly into printer or PDF in particular When I say, 'how', I mean how are you coding it Specifically, you are doing all your drawing in the paint event, aren't you ...Show All

• Smart Device Development CListCtrl and italic fonts

  I have a simple dialog that contains a CListCtrl of type "small icon" and I want to display the strings with an italic font. I use small icon because I don't want the window to be scrolled horizontally, and "small icon" takes care of that (the window is scrolled vertically). The problem is that when I set te font as italic, when the items are displayed in the list, a small part of the string is clipped out from the right side. The font is displayed correctly as italic, but that small part is missing when the list is displayed. For example, if I want to display something like "Test (1)", the only half of ')' is displayed. Is there any fix for this When you are adding a ...Show All

• Visual C# convert double[] to byte??

  is this possible i need to convert an array of double to byte so that i can put it in a database.. thank you! Hi , As Zamial said, the max value of byte is 255 , so how is it possible to put a double array into a single byte value. A double array can be conveted to byte array but not to a byte value. U have told that u r going to store this byte value in MS-Access. Is it Byte or Memo type if it is memo type, i guess u can pass byte[]. or else u can format all the array values into a string having a delimeter as seperator and save it in database as text type. Hope my thought may help you. Could u please let me know ur opinion after reading these things cheers, Ch.T.Gopi ...Show All

• SQL Server Calling Reporting Services from SSIS

  Hi I have created a packages which pull and push the data to SAP server. I want to create a report every day and send that report to the manager. For the same i want to call reporting services in my SSIS package. I know i can write a SQL script and export the report in excel but i want to use Reporting services. Have any one call reporting services from ssis. I am using what you had posted: //Sample call SaveFile (Dts.Variables("varSSRS_URL").Value.ToString() + " %2fYOUR_SSRS_FOLDER%2fYOUR_REPORT_NAME&rs:Command=Render&rs:Format=EXCEL", outpath + "FILENAME.xls") //Note that you can replace "EXCEL" by "CSV" or "PDF" or any other suppo ...Show All

• SQL Server Groups: keep together -> can't find it

  Hello there. I've got a little problem. I'm deploying reports in RS. I also have to rebuild old CrystalReports-Rreports in RS. 90 % of them are using a "keep together" function. I've read a lot in forums that there must be similar function in RS. I also found descriptions where this property should be, but there isn't. For report-developing I used (RS2000 with VB.NET2003) and (RS2005 with VB.NET2005). Neither of them have this property for table/report. Do I have to install a ServicePack Any other ideas Thanks, Tobi I am having the same problem basically because SSRS does not have a "Keep Together" functionality. I am trying to devise a way to simulate this as it is in Crystal. BJ ...Show All

• Visual Basic Print Coordinates Problem

  I am a VB.Net programmer and I have dealt with numerous errors and coding issues but this problem has got me officialy stumped! I am currently writing a program that involves some printing functions. As you know, the default margins for a 8.5 x 11 page is 100 pixels from the edge of the paper. When you click Print Preview the text looks exactly like it should but when you click Print the entire text is offset to the right by at least 50 pixels. Keep in mind that the print and print preview is generated by the same code. While writing this program, I encountered this problem in the early stages and offset the margins to the left by about 50 pixels. It made the print preview look ugly but the paper looked satisfactory. I am now having to fac ...Show All

• Visual Basic Errors and Warnings

  I am using VB .Net in Visual Studio 2005. Why do warnings, and sometimes errors, come and go without any action on my part, apart from opening and closing modules and rebuilding the solution I am very much a beginer with VB .Net adn this is very confusing. How do I make sure I have taken care of all warnings, if they come and go at will Thanks You say without any action on your part. This is rather a vague statement but what can happen is that some errors may disappear as a result of simply correcting the situation. Example Dim x as integer can result in a unused local variable warning. Simply using it and doing a second line x =1 would result in this warning disappearing. ...Show All

• SQL Server Concurrent queries in SQL Server 2005 Express

  If applicable, what's the limit on concurrent queries supported by SQL Server 2005 Express Also, if there's a limit, does next connection after the max errors out or merely queues up Thanks, Phillip hi Pjhillip, PhillipM wrote: If applicable, what's the limit on concurrent queries supported by SQL Server 2005 Express Also, if there's a limit, does next connection after the max errors out or merely queues up Thanks, Phillip as in MSDE 2000 (and full blown SQL Server's editions), there's a "tecnical" limit of 32767 connections... and this can not be workarounded.. MSDE has another "limit", a built in Governer, but it does not prevent futher conne ...Show All

• Smart Device Development Type of file problem

  hi all, this might a simple question for u all, but i m not getting any way to find the solution. Actually i want to make it out whether the file is video file, audio file or simple image file. I dnt how i can get the type of the files. plz help needed. thanx in advance hye_heena wrote: hi all, this might a simple question for u all, but i m not getting any way to find the solution. Actually i want to make it out whether the file is video file, audio file or simple image file. I dnt how i can get the type of the files. plz help needed. thanx in advance you need to be a little more specific about your context ... do you already have a FileInfo object if so, get the ...Show All

• .NET Development SqlMembershipProvider, use from WindowsForms with not trusted connectionstring?

  Hello, i use the Login controls supported by ASP.Net 2.0. But i have some problems... :) I have an application with two GUI-s: - winforms (the core, maintenance, etc.) - asp.net 2.0 (basic public functions) So, i had to solve the problem: create/manage users form winforms - it's not a big deal: [problemsolver article ]. But! What is when i have users with a not trusted connection ! So, the connection stirng might be look like this: string conStrFromConfig = @"server=srv1\sql2005;Database=MyDB;trusted_connection=no;"; When the application starts, ask for the user name and password. When clicks Login: conStrFromConfig += "user id=user1;password=xxx;" Then everything is ok, connection can be estabilished with the db server ...Show All

• Visual FoxPro Import Command problem

  I downloaded some data from Yahoo and saved it in .scv MS Excel format. It is a MS Excel Comma Separated Values File . Now I want to use an IMPORT command to import the data in VFP. I run into a problem with it. The command I use is as follows: IMPORT FROM "D:\VFP_Projects\DATA\D_data\table1.csv" DATABASE "D:\VFP_Projects\DATA\D_Data\d_HistData.dbc" NAME tempTable TYPE XLS It seems the problem is related to the fact that this file extension (.scv) is not specified in the IMPORT command description. If I use TYPE XLS I get an error " Microsoft Excel file format is invalid ." If I put in TYPE SCV instead I get an error that there is a "syntax error." If I drop the TYPE clause altogether I get: &q ...Show All

• Visual Studio 2008 (Pre-release) UDDI Sample Questions

  1) Does the uddi sample work with only basicHttpBinding only Or can you use wsHttpBinding also 2) I noticed that UDDI related code is not coming from .net framework but appeared to have been generated with some internal schema or published uddi wsdl. Does this mean this code will look like this until WS-Discovery support is in place Thanks. I should have stated that this is installed with the Windows SDK which is now at the Release Candidate stage and can be downloaded from here: http://www.microsoft.com/downloads/details.aspx familyid=117ecfd3-98ad-4d67-87d2-e95a8407fa86 ...Show All

• SQL Server Changing the DataSource at Runtime

  I have to create a script for changing the datasource at runtime. Here is my screnario, While development I am using Data source name called "DevDatasource1" and when I am deploying it to other evnironment the datasource name will change let us say "QADatasource". I have to create a script for changing the datasource(i.e. DevDatasource1 to QADatasource). How I can achieve I this using the setItemdatasource hi simles thanks for your reply. Here is my problem. While deploying my reports on the other server we don't want to create the datasource. Already in the deployment server datasources are created. what we have to do his while deploying the reports we have to map the e ...Show All

• .NET Development Setting DefaultValueAttribute for an object-type property

  I'm not sure how to set the DefaultValueAttribute for a property of an object type, for example, setting the DefaultValueAttribute for a Font type property so that it is a default font. I've tried a few methods such as: <DefaultValue( New Font( "Arial" , 16, FontStyle.Bold))> _ Public Property HeaderFont() As Font Get Return _headerFont End Get Set ( ByVal value As Font) _headerFont = value End Set End Property However, whatever I put in <DefaultValue(...)> I always get the error message: "Constant expression is required". What does this error message mean and how can I do what I intend Many thanks. Consider using the DefaultValueAtt ...Show All