Search Results

Search found 129 results on 6 pages for 'soo'.

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Page 3/6 | < Previous Page | 1 2 3 4 5 6  | Next Page >

  • SSIS - user variable used in derived column transform is not available - in some cases

    - by soo
    Unfortunately I don't have a repro for my issue, but I thought I would try to describe it in case it sounds familiar to someone... I am using SSIS 2005, SP2. My package has a package-scope user variable - let's call it user_var first step in the control flow is an Execute SQL task which runs a stored procedure. All that SP does is insert a record in a SQL table (with an identity column) and then go back and get the max ID value. The Execute SQL task saves this output into user_var the control flow then has a Data Flow Task - it goes and gets some source data, has a derived column which sets a column called run_id to user_var - and saves the data to a SQL destination In most cases (this template is used for many packages, running every day) this all works great. All of the destination records created get set with a correct run_id. However, in some cases, there is a set of the destination data that does not get run_id equal to user_var, but instead gets a value of 0 (0 is the default value for user_var). I have 2 instances where this has happened, but I can't make it happen. In both cases, it was just less that 10,000 records that have run_id = 0. Since SSIS writes data out in 10,000 record blocks, this really makes me think that, for the first set of data written out, user_var was not yet set. Then, after that first block, for the rest of the data, run_id is set to a correct value. But control passed on to my data flow from the Execute SQL task - it would have seemed reasonable to me that it wouldn't go on until the SP has completed and user_var is set. Maybe it just runs the SP, but doesn't wait for it to complete? In both cases where this has happened there seemed to be a few packages hitting the table to get a new user_var at about the same time. And in both cases lots of data was written (40 million rows, 60 million rows) - my thinking is that that means the writes were happening for a while. Sorry to be both long-winded AND vague. A winning combination! Does this sound familiar to anyone? Thanks.

    Read the article

  • Rerunning DoWork on Background Worker Based on Result?

    - by Soo
    Let's say I have a backgroundWorker1_DoWork that finds a value in a database and returns it in e.Result. Let's say I also have a backgroundWorker1_RunWorkerCompleted that reads the result. What I want to be able to do is based on e.Result, I can re-run backgroundWorker1_DoWork, and this I am not sure how to do. I'd really appreciate any help.

    Read the article

  • Adding A New Row Using SQL Server Management Studio

    - by Soo
    I'm learning how to use SQL Server Management Studio and can't figure out how to insert a new row into a table. Table Structure: ID, Field1, Field2 Query: INSERT INTO Table (Field1,Field2) VALUES(1,2) Error: Major Error 0x80040E14, Minor Error 25503 I'm probably missing something very noobie like. Any help would be appreciated.

    Read the article

  • Referencing An Object From ThisWorkbook

    - by Soo
    I need to populate several comboboxes in an Excel sheet upon loading it. I have the Workbook_Open() event set up on my ThisWorkbook code sheet in my VBA Editor. Now that the code isn't in my Sheet1 code sheet in my VBA Editor, the following code doesn't work: ComboBox.AddItem "hulkSMAASH!" How can I reference this combobox from my ThisWorkbook code sheet in my VBA Editor?

    Read the article

  • Adding Items To A Combo Box Without Code?

    - by Soo
    I want some default values in my combo boxes but can't seem to figure out how to do this without writing a module that populates the combo boxes. How can I manually fill in the combo boxes so I don't have to use code to do something so simple. Thanks

    Read the article

  • Proper Form Application Design

    - by Soo
    I'm creating a WinForm application in C# and one of its functions is displaying text in text boxes. I'm coding the logic for querying a database in a separate class and am unable to access the text box element in the class I'm creating (I'm getting a "name" does not exist in the current context error). Do I put all of my form logic into my Form1.cs file?

    Read the article

  • C# Creating A Program That Runs In The Background?

    - by Soo
    How can I create a program that runs in the background, and can be accessed via the Windows' "Notification Area" (Where the date and time are in the lower right hand corner)? In other words, I want to be able to create a program that runs and can toggle between having a display window and not having a display window.

    Read the article

  • WinForm And Looping

    - by Soo
    I have a WinForm set up and a process that loops until a button is pressed on the form. When I try to run my code, the form does not even display. I suspect this is because the code gets stuck in the loop and doesn't get far enough to display the WinForm. How can I get the form to display and the loop to run after that point?

    Read the article

  • Database Design Question

    - by Soo
    Ok SO, I have a user table and want to define groups of users together. The best solution I have for this is to create three database tables as follows: UserTable user_id user_name UserGroupLink group_id member_id GroupInfo group_id group_name This method keeps the member and group information separate. This is just my way of thinking. Is there a better way to do this? Also, what is a good naming convention for tables that link two other tables?

    Read the article

  • When To Use this.method()?

    - by Soo
    Hi SO, and happy Friday I have a question regarding the use of this.method();. My code seems to work without using the this., but I include it because it seems like the right thing to do. When should .this be used, and because it's presence doesn't always make a difference, what's the best practice for .this?

    Read the article

  • ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

    - by Imran
    Can someone please help as i've spent all day trying to fix this. I installed the latest XAMPP and now i can't connect to mysql from terminal.I checked my .profile file and the PATH seems ok. Does anyone know whats happened and what's the solution? PATH=$PATH:/Applications/XAMPP/xamppfiles/bin export PATH THIS IS A PROGRAMMING QUESTION AS I'M A PHP DEVELOPER TRYING TO DO MY JOB! Thankyou soo much in advance;-)

    Read the article

  • Wireless not working on ubuntu 12.04

    - by Yosef
    I just install ubuntu 12.04 but wirelless not works(windows 7 wirelless works). I open my windows 7 and see under Network Adapters: Edimax 802.11n Wireless Adapter Realtek PCIe GBE Family Controller Which drivers i should download to install them on ubuntu 12.04 to make wireless work? And how i install this drivers on ubuntu after i copy them to usb. (I can have only wireless connection not wire - soo i nhave to dowload the drivers with windows then copy them to ubuntu) Thanks

    Read the article

  • Sensitive data deletion (remote)

    - by José Antonio Silva
    Hi, I'm just finished my Amazon EC2 migration and I want to delete all the files (databases, source code) from the old servers. The problem is that the servers are in California and my business is in Chile, soo I only have ssh access to that servers. I'm planning to sell the servers and I'm wondering if there is a way to perform a low levele deletion remotely of the specific files and folders. Thanks in advance! José Antonio

    Read the article

  • Booting from virtual machine VMWAre

    - by vikp
    Hi, I have a VMWare virtual machine (windows xp). I have just started it up through the VMWare player and it's extremely slow on my laptop (expected). Is it possible to boot from that image like in mac bootcamp so that it's not virtualised and soo slow? Thank you

    Read the article

  • Tool to edit the online pages

    - by doug
    hi there When i read something I need to underscore what i like, or what i think is important, and to take notices about that read, near on that current paragraph. Soo, does anyone know a firefox addon or something else(other browser, any other application) which can provide me such a functionality? ps: I've tried some research tools as zotero, but it is not what I'm looking for.

    Read the article

  • (Ubuntu 10.04 - Windows vista premium on HP pavilion desktop) I reistall my windows, but now i cant

    - by meyosef
    Hi, I had Windows vista premium on HP pavilion desktop. I split disk for ubuntu and make also swap disk part and then i install ubuntu 10.04. To the enterence of my computer after installation i have menu that i can to choose between windows or ubuntu. Today I reistall my windows, but choose menu disapear. I dont see in windows the rdisk part that I give to Ubuntu, soo its mean ubuntu still exist but i cant enter to him. Please help me, Thanks

    Read the article

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

< Previous Page | 1 2 3 4 5 6  | Next Page >