How to load data through list object (in.net)(Through list object the data is populating dynamically) using ssis....?
Can any one help me....ASAP...?
View Complete Post
I would like to identifying the source & destination tables of the data flow or the transformation task.
I need to create a custom component which i can put into existing packages which can do some validation.
Please suggest ways i can accomplish this.
<cname>United Arab Emirates Dirhams</cname>
public void Main()
String URLString = "http://www.xe.com/dfs/datafeed2.cgi?beeline";
XmlDocument doc = new XmlDocument();
XmlTextReader reader = new XmlTextReader(URLString);
XmlNodeList currencynodes = doc.SelectNodes("currency");
foreach(XmlNode currency in currencynodes)
XmlNode csymbol = currency.SelectSingleNode("csymbol&quo
i wanted to retrieve things from the data base and perform mathmatical operations on it then post it to the user, so i was told to use the bullited list and bind it to the object dataSource
how to perform such thing??
Hello Every One,
I have a scenario in which i am executing a Stored Procedure which returned a result set.
I want to create a Excel file [name_date_time] dynamically, and fill result set data into Excel file. And then finally sent Excel file to Specific user[Email ID].
Point is that the excel file should have unique name so i want to give name as name_date_time.
So every time when package run new file is created with unique name.
Can any one suggest me who to create Excel file and fill result set data into Excel file.
And then finally send that Excel file ?
I am Beginner to SSIS, but this question is all about Data warehousing.
When I load the data to dimensions Do I need to have constraints off(referential integrity).
Is there any best practices before & After loading data into DW on SSIS ?
The data needs to be logged. Any duplicate data from previous day will not be updated. -- How to achieve this using SSIS
Using a data flow task I am trying to load data from a table in sybase server to sql server. There are approx 10000 rows in the sybase table, however for some reason which I
am not able to find out, at random certain no of rows are getting inserted. e.g. in one run 800 rows then 200 rows etc.
Can somebody please guide me on this?
I have a BDC xml file which specifies a finder and a specific finder method. These both work fine.
What I want to do is configure the application so that when connected to a list column the object picker uses my finder method rather than the specific finder method which it defaults to. Is this possible?
For further explination if you look at the following image
If I want to find the department using the objet picker I have to type the full identifier.
If I click the browse (address book icon) to popup the browse window I can then use my finder method. I want the initial object picker to use my find method and if there multiple matches be able to pick one using the popup you get when the message "No exact
match was found." is displayed.
Hope this makes some sense!
I am trying to persist data in a dynamically populated ListBox in a
user control. Here are the details
I have a user control which contains a a listBox and button. On
Page_Load of user control I am populating the ListBox control with some
values. On Click of button, I am trying to fetch the values which I have
selected in ListBox. Though this seems very simple
and straight forward I am unable to fetch values.
My Page_Load Function
void Page_Load(object sender, EventArgs e)
My Click Function
Protected Void Button1_Click(object sender, EventArgs e)
string strValue = listBox.SelectedValue
I have placed brake point at Page_Load and on click function, I am
seeing that the moment the breakpoin
I am using fluent NHibernate with WebForms and I am trying to build a page where I allow a user to post a status update on their profile page and I a using a .asmx WebService to post the data to the database and then returnig a StatusUpdate instance to the page to be used by jQuery. I have a couple problems.
1) First off when I return a string from the WebService(i was testing) the textbox where the user enters their status doesnt empty the contents. And since the page doesnt refresh even if I manally clear out the textbox and put in something else, it still posts the previous status to the database again. How do I fix this?
2) Secondly, when I return the StatusUpdate Object from the Webservice I cant the results to display anything. Like I sad, Im using jQuery to make an AJX call to the WebService.
Here is my code:
User Profile Page:
Status: <asp:Label ID="status" runat="server"></asp:Label><span style="font-size:.7em;"><asp:Label ID="statustime" runat="server"></asp:Label></span><br />
<textarea id="statusBox" rows="3" cols="40"></textarea><br />
<input type="button" value="Update Status" onclick="SetStatus(); return false;
MSDN Magazine July 2004
ADO.NET provides many techniques for improving the performance of data-intensive applications and for making them easier to build. The DataSet, the hallmark of the ADO.NET object model, serves as a miniature, disconnected facsimile of a data source. While using the DataSet improves performance by reducing expensive trips to the database server, it also introduces the possibility of multiple users attempting to change the same data simultaneously, thereby generating data concurrency exceptions. This article examines the common causes behind data concurrency exceptions and presents techniques for overcoming them.
MSDN Magazine April 2003
One major inconvenience of using SQL stored procedures from code is having to match type information. You have to write long wrapper functions around the procedures just to expose the data types. In the .NET Framework, however, the reflection services of the System.Reflection namespace allow you to query rich metadata that describe data types. This article explains how to use reflection in .NET to end your stored procedure nightmares. The author creates four custom classes, including one that generates a SQLCommand object based on the metadata of a method. Using this library, you'll be on your way to automating the generation of stored procedures.
MSDN Magazine August 2002