BobSun's Q&A profile

• SQL Server How to schedule to run Integration Packages using SQL Agent/Job?

  Hi Folks, I deploying a couple of integration packages which needs to be run sequentially. Currently, I quite puzzled how come i cannot run them as a SQL Agent job. It always fail with "Executed as user: Servername\Administrator. The package execution failed. " But if I had put import these integration packages into the SQL Server 2005 Integration Services FileSystem, it does run but i need promptly as there is a dialog requesting whether to execute the packages. Is there a way to automate the running of these packages through SQL agent. Pls help need to get it up and running asap. Thanks first. garynkill23 wrote: As regards to your first message, I am not sure which account i was using Windows Authenticati ...Show All

• Visual C++ Error message PSAPI.DLL

  I am getting a error pop up saying Get Process Image file name w. could not be located in the dynamic link library psapi.dll What should I do to fix this. April You probably have two versions of PSAPI.DLL, one of which came installed with some other software. I would check out that weblink I gave you and see if that leads you to the solution. ...Show All

• SQL Server EncryptByKey Function always returning null

  When I use EncryptByKey function to encrypt text using AES 128 bit key, I get always null result. this is how I do the encryption: ALTER PROCEDURE [dbo].[ProcMyProc](@ClearText nvarchar(50)) AS BEGIN OPEN SYMMETRIC KEY MyKey DECRYPTION BY PASSWORD= 'MY_Password_128'; Declare @Temp varbinary(8000); Set @Temp =EncryptByKey(Key_GUID('MyKey'),@ClearText); close symmetric key MyKey; select @Temp as temp; END The result I get for this procedure is null. Is there something wrong with this code I found the cause of the problem. I was misspelling the name of the key when passing it to the Key_GUID() function. but shouldn't this give an error saying there's no key with this name instead of just returning null ...Show All

• Visual Studio 2008 (Pre-release) Smart & Lazy Scrollable List ;-)

  Hello, I'm using a gridview/listview in order to display a grid of data to the user. However the potential # of rows can be very very large. So: 1. I don't want to get the entire list. 2. If I can, I would like to avoid (first, prev, next, last) paging scheme. So I was thinking maybe I could break the list into pages and employ lazy loading. In other words, have a slot of pages (lets say 5 pages), and as the user scrolls, I move the slot of pages and proactively gather rows from the db, keeping a few steps ahead of the user. I realize that the user may scroll faster than the lazy-loader or may just jump to the end of the list (I'm not sure how to solve those problems yet: one step at a time I guess). I got 2 of questio ...Show All

• Visual Studio Team System error 1402 installing virtual server 2005 R2

  I have not found a Virtual Server forums.so I write here my question Istalling virtual server 2005 R2 on a Windows XP OS, I'am getting the error "Error 1402 could not open HKEY_LOCAL_MACHINE \Software\Classes\Msxml2.DomDocument.4.0\CLSID Verify that you have sufficient access to that key, or contact your support personnel". My UserId has admin rights so I don't think that access rights are the problem. Logged under the local admin account and tried again. Same error. I tried on un Lap top with windows Xp and all is OK. Why I need help please aurelio I don't believe Virtual Server has a forum, but they do have a news ...Show All

• Visual Studio Team System Process Template change

  I want to remove a few workitems I do not use in my process template. For example.  I have no reason to create a "risk" workitem.  I know that if you alter this xml.  And remove the entries for the workitemtype that you don't want created it will work fine for any new project created using this template.  (see xml below). However I don't want to create a new project, we only use one project.   Is there a way I can remove the ability to create certain workitem, ie "risk" in an existing project    It should no longer appear when you right click on workitems and choose "Add work item" from ProcessTemplate.xml <task id="WITs" name="WorkItemType definitions" plugin="Microsoft.Pro ...Show All

• SQL Server Analysis Services Perfomance Issues (when open a cube definition)

  Hi we are dealing whit a perfomance issue in Analysis Server 2005 working with olap cubes. This cubes are part of a solution with a view (91 tables) and every time we try to access some meta data of the cube in the Visual Studio 2005 (i.e.: Calculations, KPIs, etc) it takes a lot of time to read the metadata of the cube. The cubes are not so big, but every time we try to get the cube metadata we have problems.In Example; it takes more than 3 minutes to get the structure of the cube in the browse section; but after this we can easily drop fields to the sections of the cube designer and watch the cube data and calculations. We have the same problem in Excel 2007 when we try to connect to the Analysis Services database and read som ...Show All

• .NET Development Unregistered custom channel still being used!

  I created a custom client formatter sink to pass some information. I can create it as follows: BinaryClientFormatterSinkProvider binarySink = new BinaryClientFormatterSinkProvider(); ClientSecuritySinkProvider secureSink = new ClientSecuritySinkProvider(username, password); secureSink.Next = binarySink; _tcpChannel = new TcpClientChannel("tcp", secureSink); ChannelServices.RegisterChannel(_tcpChannel); Activator.GetObject(...) This works the first time. However, if I call: ChannelServices.UnregisterChannel(_tcpChannel) and repeat the procedure with a different username and password, it still uses the first channel I registered (even though it has been unregistered!) I verified that the new channel is being crea ...Show All

• Visual C++ error LNK2019: unresolved external symbol

  Hello. Please see below the link errors. I think syntax is probably not problem. Do you know what problem is I will wait for your help. Thank you. Environment : Windows XP Prof. SP2 Visual Studio 2005 Intel Core2 Duo A few Warnings… … Generating Code... Compiling resources... Linking... AutoDetect.obj : error LNK2019: unresolved external symbol "public: __thiscall CAboutDlg::CAboutDlg(void)" ( 0CAboutDlg@@QAE@XZ) referenced in function "protected: void __thiscall CAutoDetect::OnSysCommand(unsigned int,long)" ( OnSysCommand@CAutoDetect@@IAEXIJ@Z) AutoDetect.obj : error LNK2019: unresolved external symbol "int __cdecl AddDrive(int,int,char)" ( AddDrive@@YAHHHD@Z) refere ...Show All

• Visual Basic DataGridView -> DataGrid

  Hi, Anyone know how to convert datagridview into datagrid Or put datagridview data into datagrid thanks in advance Dick Donny wrote: Is this what you are looking for dim dg as datagrid, dgv as datagridview ........ dg.datasource = dgv Richard dg.datasource = dgv.datasource ...Show All

• Visual Studio Express Editions Easiest way to keep track of some numbers and check them

  Hello, I want to save the numbers from 2 text boxes somewhere, they dont need to be opened by anyone but the program needs to be able to read them to make sure there are no duplicates... so for e.g a list of phone numbers when the user clicks save it scans through the list and either saves the number or pops a message box up saying that number allready exists.. Hope someone can help, thanks! sure. This is untested code so bare with me: //create a dataset: Dim theDataSet as new DataSet() //create a table in the dataset: theDataSet.Tables.Add(new DataTable("TableName"))   //Add a column to the table: theDataSet.Tables("TableName").Columns.Add("MyColumnN ...Show All

• Visual Studio Class not registered - DTSConnection

  I have created a number of reports on my local machine which work well. These have been incorporated into our web site. When the reports are run on our development machines they can be seen. When we made the site available on our web server then the error “Class not registered – DTSConnection” is given. I have not been able to solve this problem. Can any one help Server Error in '/' Application. Reinstalling the CrystalSetUp.msi and the .Net 2.0 update fixed the problem for us. Margus Lapp ...Show All

• Visual C# Operator '+' cannot be applied to operands of type 'T' and 'T'

  One day, the Microsoft C# team will stop treat us as kids, and this code will become possible:   public static ABIDataVoidNull<T> op_Addition_NV_NV<T>(ABIDataVoidNull<T> inValueL, ABIDataVoidNull<T> inValueR)        {            if (inValueL.IsVoid)            {                return (ABIDataVoidNull<T>)inValueR;            }            else if (inValueR.IsVoid) ...Show All

• Visual C# Build .net 1.1 solution

  I am trying to build a .net 1.1 solution using the command line only and not VS IDE. I have build box with only the .net 1.1 framework installed. How can I build from the command line Is there an equivalent of the VS .net 2003 command prompt that will recognize the "devenv" command when I try to use it. My Reason for building on a box without VS installed is to follow best practices so that the applicaion has no dependencies on VS IDE, as the production server will not have VS IDE. Is this possible with NAnt for a project that has multiple libraries in different locations. Does NAnt have an include command or do I have to build the libraries first I.E. build the dependancies then build the solution; rather than just addi ...Show All

• Visual Studio Express Editions copy dataset

  hey everyone, this is not very new question, sorry about that, but i dont know how to manage to do this. i want to a copy dataset with the tables and stuff, and here's the example code they give: Private Sub CopyDataSet(ByVal myDataSet As DataSet ) ' Create an object variable for the copy. Dim copyDataSet As DataSet copyDataSet = myDataSet.Copy() ' Insert code to work with the copy. End Sub what else should i do with the code to get this work, because that dataset.copy() does'nt add new dataset itself, right the row "insert code to work with the copy" is the problem i guess. what short of code will i need then could'nt find any samples, and dont know how to do it myself. any help for this is appreciated. thanks ...Show All