Can Use SSIS To Parse Data From Application Before Store In Db
Mar 29, 2011
Exploring the feasibility of something here... We have a UI page in the mvc3 web-application that the admin will use to upload a 'csv' file. Is it possible to have an SSIS package that will be called by the application..that will validate/transform all these data and store into db if its all valid or throw back error details to application if there are invalid data?
Just trying to leverage the capabilities of SSIS to do the parsing of file and transformation of data. If this is not possible, is there a better way?
update: yes, need to execute ssis on the fly.. and give back a message on the UI page. telling the'uploader' if his upload failed or not based on message that SSIS would give back to the application.
View 4 Replies
Similar Messages:
Jun 23, 2010
i am having a problem in executing the SSIS package through an asp.net application. i'm using c#. every time i run the package through web, i think the package is not disposed properly so until and unless i stop the application the package won't execute...i am not able to dispose or unload the package. i'm geeting errors like
'WebDev.WebServer.EXE' (Managed): Loaded 'C:WINDOWSassemblyGAC_32CustomMarshalers2.0.0.0__b03f5f7f11d50a3aCustomMarshalers.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. The result of the expression ""EXEC " + @[User::vRowData]" on property "SqlStatementSource" cannot be written to the property.
The expression was evaluated, but cannot be set on the property. : Package Execution results: {0}
here is my code
Application app = new Application(); //Package package = app.LoadPackage("D:ChipRewards_WorkingFolderChipRewardsCodebaseHeathPlanCommonTrunkSSIS PackageETL_WorkFlowETL_WorkFlowDataImport.dtsx", null); //package.ImportConfigurationFile("D:ChipRewards_WorkingFolderChipRewardsCodebaseHeathPlanCommonTrunkSSIS
PackageETL_WorkFlowETL_WorkFlowETLConfig.dtsConfig");
[Code]....
View 1 Replies
Oct 20, 2010
I want to ask the following:
Does anyone have an example of some code which executes an SSIS package from a ASP.NET web app using VB.NET?
I have built a web application and want to be able to execute the SSIS package when the user clicks a button on the web page.
So far I have:
[code]....
I need to know how to set this up so it runs remotely. I have searched MSDN (useless), [URL] and sqlservercentral.
View 3 Replies
Oct 13, 2010
I occasionally get errors in my aspx files which are caused by problems with the designer file. When this happens I delete the designer file, right click on the aspx file and select "Convert to Web Application".
Usually regenerating the designer file works perfectly, however sometimes I get an error which simply says "Could not parse the file pathToFile.aspx". When this happens there are no useful errors displayed in the error panel which would indicate what the problem is. I got this error a little while ago, did some searching and found a blog which explains how to get round this problem. It suggests closing the file, cleaning the project, rebuilding then tring again. VS should now give you a more useful error message which pinpoints the problem. This has worked for me in the past, but doesn't work all the time.Has anyone found a better way of identifying the problem in the aspx file when the "Could not parse file" error is displayed?
View 1 Replies
Jan 25, 2010
I have got a SSIS Package running every 2 hours. It collects data from different DBs and updates the DB of my ASP.Net Application. Everything goes smooth, but the asp.net application is still using the old data, it has the data somehow cached. If I just open save the web.config, it empties the cache and uses the updated new data. How can I make sure, that the app empties the cache after SSIS Package finished successfully?
View 1 Replies
Aug 7, 2010
How do I store a variable or object application wide in ASP.net MVC. In regular ASP, you had the Application object, and in ASP.net too apparently.
View 1 Replies
Mar 2, 2011
How to write and deploy SSIS data transfer packages. ?
View 2 Replies
May 2, 2010
i have an html (save in a string variable if needed) and i want to use the content of one of the html's tables (the html page has 4 tables an i want only one of them) . i read a lot of similar post but i didn't find anything helpful. on how to parse the html and get the content of one of the tables so i can use this data later?
View 5 Replies
Oct 13, 2010
I have a ListBox on my page. I'm making an AJAX call to a C# function, and I need to pass the values of the selected items. Here's what I have:
$('#btnSubmit').click(function() {
$.ajax({
type: "POST",
url: 'Default.aspx/GetSelectedValues',
data: '{selectedValues: ' + $('#lbItems').serialize() + '}',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: OnSuccess
});
});
<select id="lbItems" multiple="multiple">
<option value="1">One</option>
<option value="2">Two</option>
<option value="3">Three</option>
<option value="4">Four</option>
<option value="5">Five</option>
</select>
[System.Web.Services.WebMethod]
public static string GetSelectedValues(string selectedValues)
{
//
}
The data being passed to the C# function looks like:
lbItems=1&lbItems=3&lbItems=5
Is there any built-in C# function that can deserialize that easily, to convert the values into an array of some sort? Or maybe there's a better way to pass the data from jQuery?
View 3 Replies
Jul 29, 2010
I'm creating a web application using asp.net & WCF as 3 tier architecture, which is mostly looks like a social website. Users can register with the system and they can upload their profile images, documents, video clips etc. So, what i want to know is what is the best way to store those files? In the wcf side or web application side ?
Also I want to know that, if i choose web application side to store those files as set of folders, how it makes those folders shared and allow access to another different project (such as a desktop client need to upload files into that shared folder) ?
View 2 Replies
May 7, 2015
How to parse [URL].....
I am referring below link of urs : How to read JSON string into DataTable and Class object using C# .Net
my code to get data into string :
Dim data As String = New System.Net.WebClient().DownloadString("[URL]")
now i want it to get into data table , so that i can bind it with grid later on.
JSON String
{"
record":
[{"id":"0",
"Date":"11/14/2014",
"Time":"12:00AM",
"programme":"Stops Here",
"synopsis":"A show that brings you the big interviews",
[Code]......
View 1 Replies
Feb 10, 2010
how could i store a Asp.net Application variable by javascript.
View 2 Replies
Oct 14, 2010
I am working on a railway web application and I have following layers:
[Code]....
I pass Domain Entity Objects from Repository to Service layer and thinking of passing View Models from Service to Presentation layer. Website would require a login and after successful login I have to present a search screen with basic search (as default option) and option for advance search. Once user fills the
search criteria I have to gather data from DB & Web Services and present the results to user. User would select a particular Rail option and would move on to other additional options page BUT they should be allowed to change their previously selected Rail option by going back to Rail search results. I have to
always hold and present user's initial search criteria (basic and advance search options selected by user on the search wizard) on every screen and need these criteria in Service and Repository layers.
What is the best way to hold these search criteria and pass them from page to page within presentation layer and across layers? Should I create a View Model class for Search Options? Or a Domain Entity Object (I don't think so)? and best way to pass it across layers and from page to page with in presentation layer.
View 1 Replies
Mar 11, 2011
My question relates to the performance implications of reading application configuration data from an XML file.I am building an application that lists information from a database and needs to know how to display the lists, depending on the types of data returned.This is difficult to explain, but basically I would like to have an XML config file that lists the types and describes how to display them. This will allow me to change the display methods without re-compiling the application.
My question is really around performance. Given that my application will need to use this data many times during each page load...Should I be reading directly from the XML file and parse it each time I need it?
Or should I cache the XML object and parse it each time I need it?Or should I parse the XML once, generate some sort of object and cache that object?My guess is option 3, but I'm basically fishing for best practice around this.
View 1 Replies
Sep 14, 2010
We are designing a .net web application that has an external and internal site.
Both sites need to encrypt data only the internal site needs to decrypt data.
We are wondering what are the best practices for:
Which encryption method to choose?
Where to store the encryption / decryption key?
View 2 Replies
Oct 20, 2010
I am working on a Railway Portal and would require maintaining a shopping cart of components user has selected, there could be multiple components of different type in the cart. I don't see a value in storing the cart in database, would like to store the final order in DB. Where can I store/hold (temporary) the cart data per user session in MVC? All MVC samples I saw online save the cart data in DB - not sure why.
MVC presentation layer will be communicating with external web services for pricing and availability of these components, so I can't store only the product IDs to do a lookup for actual product descriptions/prices during the shopping process... I have to store everything in the cart (Product IDs, Descriptions, Prices etc) some place in memory. My application will be running in WEB FARM environment and cannot use in-process session storage.
Options come to my mind are:
SESSION STATE in SQL SERVER Using some kind of Distributed Caching Mechanism to store Session data such as "Windows Server AppFabric"
View 4 Replies
Nov 14, 2010
how to parse excel files data in ASP.NET WebForms using C# or ASP.NET MVC using C#?
View 8 Replies
Oct 2, 2010
My target web site is: [URL]
focus this on that page: "XU100 64.882,72 -1.36 %" it is on top..
The exact target is 64.882,72 this value!...
What is the best way for this value?
My platform: asp.net , c#
View 1 Replies
Oct 5, 2010
Documentation for using a checkbox with a gridview has the following statement:Because a check box can display only a selected or an unselected state, a CheckBoxField object can be bound only to a field with a Boolean data type or a string that can be parsed byParse.No example has yet been found to explain how using Parse to control the value of theis done. Interestingly enough I can find a fine example for the unlikely scenario of embedding a bulleted list in a grid cell.
View 4 Replies
Sep 18, 2010
I have until now always stored my lists definitions for labels and values for dropdownboxes in my own defined Xml files. These lists labels I then match with a language file (.resx) ..... so far so good but now I am starting a new project. Should I continue with my old habbits or is there a better way of storing label constants for my dropdown boxes throughout my application?
I would be happy skipping my read and write rutines for my onw structure if there is a better dedicated one for the purpose.
View 2 Replies
Feb 3, 2010
General Flow is : Receipt, Dispatch, Issue.Receipt & Dispatch are normal.Item Received, Qty...etc entered through UI database updated.Item Dispatched, Qty...etc entered through UI database updated.Further Issue is subdivided into 3 types :1. Qty entered through UI DB Updated.2.Rates are defined for items & after entering the Qty through UI Amount is calculated.3.Scales are defined for Items & based upon those scales & the strengths of Consumers formula for these items is calculated.
[code]...
View 2 Replies
May 21, 2010
I have VS 2008 and 3.5 framework.I want to set up my application that I can store my content to database.I have lots of controls that from labels to images, datagrids, telerik controls, etc to keep in mind.I use SQL server 2005.
View 1 Replies
Feb 8, 2010
What is the recommended or usual way an ASP.net web application(in C# language) can store/access values that are needed accross the various pages in a website. For example a basic company website might need the company's name and other related information available to multiple pages. Where do I declare these variables/values and how do I access them. Coming from c++ application programming I would usually store such data in a Singleton class object.
View 5 Replies
Mar 6, 2011
I need to keep access settings to different web pages inside of my asp.net application. These setting are logins and passwords for those pages. Is it safe enough to keep them in web.config in section?
View 1 Replies
Mar 7, 2011
I have some global settings in my application that is going to be handled by the administrator and I store them in the database.
Settings like: board on/off, max items/page on different UserControls, language, hide/show modules.
What technique should I follow to read the values in the database and display the page or the application according to it .. Of course I could do it the easy way and fetch the required settings for each page in the Page_Load event handler but I think that will be a lot of database connection!
View 1 Replies