I am attempting to use a lookup transformation in my data transformation package and all of the other lookup transformations went well but one component returns the matching rows only when I enable the partial cache mode. If I use the full cache mode, all data is routed to the error path. I am using SQL 2005 SSIS. Any help appreciated..
Hey guys, Im trying to do some data mining and analyze data based on locations.
For this site, http://www.dianping.com/shop/1898365
I am trying to figure out whats the latitude and longitude by crawling. But I cant seem to figure out where this information is stored. Can someone give me some pointers
I am getting some data in the form ExtensionData in Client side. However, it is coming properly in the server side(means the class properties as expected) But how to get the data from the Extension object is not known to me. I am new to WCF and is using C#
Hewlp needed.
Hi,
I want to export my data from grid view to the excel. Unfortunately i came to know that there is no excel software on server side. Is there any way that i can still export data in excel format without having excel software on server side.
Thanks.
i want to write the output of a qshell command to local data area so that it could be globally used by programs.is there some way to write from stdout file to local data area .I want it to be done through CL..its urgent thanks
I'm in the process of creating an SSIS package on a server (server1) that looks at the data in a sql db on another site (server2) and copies relevant rows across.
The SQL statement required is:
SELECT *
FROM server2.ordersTable
WHERE
OrderID Not In (SELECT OrderID FROM server1.ordersTable
This selects data from server1 which isn't in the table on server2 (based on order id)
I then need to insert the result into a table on server1
How would I approach this? What components do I need etc...?
Tabs plugin I use loads the data from another page. Data loaded is in xml format so I need to style that data loaded. How can I do it? ny suggestion highly appreciated.
Data loaded needs to be used in the following:
<img src="[ImageURL]" alt="" class="MultimediaImageURL" style="float:left; margin:0 10px 0 0;" />
<div class="MultimediaInfo" style="float:left; width:200px;">
<span class="MultimediaCategory" style="float:left; color:#CCC; font-size:10px; width:100%;">[CategoryName]</span>
<span class="MultimediaTitle" style="float:left; color:#D90306; font-weight:bold; width:100%;">[Title]</span>
tabs plugin
$("div.row-title").tabs("div.panes", {effect: 'ajax'}, function(i) {
// get the pane to be opened
var pane = this.getPanes().eq(i);
// load it with a page specified in the tab's href attribute
pane.html('<img src="http://www.refinethetaste.com/FLPM/cp/images/loading.gif" alt="Loading..." />')
.load(this.getTabs().eq(i).attr("href"));
});
xml
<rows>
-
<row id="1">
<MultimediaTitle>Hagi Goals</MultimediaTitle>
<ImageURL>/FLPM/media/images/5Y2K4T5V_sm.jpg</ImageURL>
-
<Videos>
-
<VideoID id="1">
<VideoURL>/FLPM/media/videos/0H7T9C0F.flv</VideoURL>
</VideoID>
-
<VideoID id="2">
<VideoURL>/FLPM/media/videos/9L6X9G9J.flv</VideoURL>
</VideoID>
</Videos>
</row>
</rows>
Hi,
I want to use plist files to hold large data such as image data and other texts. Is this feasible or is it that plist are for holding small string such as needed for settings etc. Will there be any memory issues.
--
Regards,
U'suf
Is there a way to concatenate the row and column names from an existing data.frame into a new data frame. For example, I have column names of (A, B, C) and row names of (1, 2, 3) and I would like to combine these into a 3x3 matrix [A1, B1, C1; A2, B2, C2; A2, B2, C2]. Thanks for your help
I've got a simple login system using PHP sessions, but just recently it seems that if you visit pages not in a certain directory (/login/) you will always be flagged as not logged in, even when you are. It seems that my session data is being lost when I change directories (say, to /login/user/).
I don't think I've touched the code myself since the problem appeared, is there something my web host could have done to my PHP installation that would delete the session data, and is there a workaround?
What are the best practices for reading and writing binary data in Ruby?
In the code sample below I needed to send a binary file using over HTTP (as POST data):
f = File.new("resp.der", "r") # binary file
begin
while true
out.syswrite(f.sysread(1)) # out is an output stream (type IO)
end
rescue EOFError => err
puts "Sent response."
end
While this code seems to do a good job, it probably isn't very idiomatic. How can I improve it?
Hi everyone,
I am trying to find good resources on best practices to data replication across memcache servers. What I want to accomplish is that if one of my servers in my pool goes down, the next server in line already has the info set.
I have found "repcached" but since I run a WIN32 test environment, I have been unable to install it.
So what's our alternatives on how to replicate data between servers?
Thanks,
Suppose that I have a data frame with a column whose name is stored in a variable. Accessing this column using the variable is easy using bracket notation:
df <- data.frame(A = rep(1, 10), B = rep(2, 10))
column.name <- 'B'
df[,column.name]
But it is not obvious how to access an arbitrary column using a call to with(). The naive approach
with(df, column.name)
effectively evaluates column.name in the caller's environment. How can I delay evaluation sufficiently that with() will provide the same results that brackets give?
What data type should I use for data that can be very short, eg. html link (think twitter), or very long eg. html blog post (think wordpress).
I am thinking if I use varchar(4000), it maybe too short for a html formated blog entry? but if I use text, it will take up more space and is less efficient?
i was wondoring which thing is better from below two...
first one-
retrive data by creating webservice
second one-
create database connection from code behind call storeprocedure and retive data
can anyone one explain how it differs.
We need to deploy application(developed by Java) WAR file in client place which make use of MySql 5.0. But we would like to restrict the user from modifying any data in the database. Is there any way to protect data. The client can make use of the application but they should not be able to change any value in database. How to do that?
when user submit the form need to export form data to text file.exporting username ,password and email from form data to text file for forgot password.
please help us.
Thanks & Regard
pmms
I want to create tables that contain geometry data types (Mysql spatial extension). which steps are needed to map these with Doctrine 1.2?
Any idea how is the codes of yaml mapping and corresponding modal class for custom data mapping with Doctrine 1.2?
Thanks.
I have a WPF application that loads data from a data source.
Until some data is loaded there is nothing to display.
My question is do I:
Create both V and VM before any data is available; set the data in the VM once available
Create only V at the start; wait until data available then create the VM injecting the data
Create both V and VM only once data available
i have a menu, it contains multiple items, each menu item will retrieve data from the database.
i want to do it without the page refresh, i want like an area that will change when the user clicks on the menu link.
How should i send data to the php script and how should i get it from there and preview it on the page.
if you can send me any information, references or examples that will be great
Thanks in advance.
I'm wondering if I'm going to store some data into the session is it going to be there while the user is authenticated (using formsauth) or might happen that the data will suddenly go null
I have initially two data grids,a button and a list..
If i select one item in grid one and second in grid 2 and after clicking the button the details should be displayed on the list depending upon the selection.presently iam not dealing with the data base.
iam doing it stand alone.
If one has a number of databases (due to separate application front-ends) that provide a complete picture - for example a CRM, accounting, and product database - what methods are available to centralize/abstract this data for easy reporting?
Essentially, I'm wondering if there is a way to automatically pull data from multiple databases into a central repository that is continuously updated from the three databases and which can be used for reporting?
I'm also open to alternative best practice suggestions?