DataSource Controls :: DTS - Choosing Mdf File As Destination
May 19, 2010
I've wasted two hours of sleep on a stupid problem. I have an excel 2003 file (xls) that I'd like to import into a table in Sql Server 2008 Express edition. I've done this before, but I can't remember how it's done really. Here's the problem: When I start DTS, I set the excel file as the "data source" and click Next. Now I'm supposed to name/point to the mdf file, but how do I do that? The only thing that appears in the "Server name" text field is the computer's nameSQLEXPRESS, but the mdf file is of course residing in the web site's folder. Also, what should I choose in the "Destination" drop down menu: SQL Server Native Client 10, Micorsoft OLE DB Provider for SqlServer, or what? Regardless of what I choose, I don't find my mdf file in the "Database" drop down menu below . What am I doing wrong? I imagine it's really easy!
View 6 Replies
Similar Messages:
Sep 3, 2010
[Code]....
Does anyone have any ideas on this? I have 20 parameters.
View 3 Replies
Jun 11, 2010
I have two folders in my asp.net web application in which I create new folders programmaticaly. The entire solution is under VSS source control. I was not able to manipulate these two folders programmably. For that, I gave {MACHINE}ASPNET user account full control over these two folders. Still, the "access denied to the path" error was coming. I saw that these entire folders were marked readonly. I tried to uncheck Readonly from explorer but not successfull, readonly check does not get removed. Also, if I copy files using method, the destinationn copied file becomes readonly. I have also tried File.SetAttributes (path,FileAttributes.Normal); but no success. How can I make the copied file not READONLY?
View 1 Replies
Jul 23, 2010
we have windows xp operating system, here we installed my website that will be stored in the location(c://programFiles/) if we run the sample after executing ouputfile(scan.pdf)image file will be stored in C://inetpubs/ftproot/(if file transfer type is FTP). if file transfer type is HTTP then the image file is transfered to the location:c://programFiles/website1/app-data. If we install the same website in windows 2007 64 bit os website will be stored at c://programfile x(86)/. if we run the sample through ftp it is running fine and file is stored at FTP folder. but if we run the same application through HTTP, file is not transferring to destination folder(c://programFiles x(86)/website1/app-data.)
View 2 Replies
Jun 13, 2010
I have an interesting challenge. My application uses a third party's services and one of the functions is to upload video files to Amazon S3. The current solution I've implemented uses a simple form with a POST action set to a URL on Amazon's system. The
issue I have is that because the form posts to Amazon, I have no way of doing any type validations before the user clicks to upload the file i.e. checking file type, file size, etc.
However, I really do NOT want to set up my logic so that the file is first uploaded to my server then to Amazon because these are huge files and we'll end up using costly bandwidth on both ends -- our server and Amazon S3.
P.S. To be perfectly honest, I'm not that pleased with the current solution where it's a simple HTML form with a simple post to Amazon. However, because Amazon is so picky about all the hidden fields in my asp.net page, I had to strip everything off the
page -- including form runat"server" because the minute I have this, I end up with a hidden field for ViewState -- even if I completely turn off ViewState. There's always something left as a hidden field and Amazon was generating an error because of this.
Ideally, I'd love to be able to do an HttpWebRequest in code behind so that I can have the functions of a web form back and do some pre-upload work but I'm not sure how to upload the file to a remote destination without putting the file on my server first.
View 3 Replies
Jan 1, 2013
I have a dropdownlist for categories.
DataTextField = "Name";
DataValueField = "ID";
drp.Items.Clear();
drp.Items.Add(new ListItem("--select category--", ""));
drp.AppendDataBoundItems = true;
ID is int and I've got this
drpsub.Items.Add(new ListItem("--select category--", ""));
I want to insert some information plus ID in databaseeverything is ok when user select category from dropdownlist (for example: India, Iran, China) but when the userchoose --select category-- she face an error because the value here is "" not an ID(int value)how can i don't let user choose --select subcategory-- ?
View 1 Replies
Dec 21, 2010
I am trying to export images from my SQL server to SSIS's Flat file destination but keep getting the same error: Error 0xc0208030: Data Flow Task: The data type for "input column "image_full" (105)" is DT_IMAGE, which is not supported. Use DT_TEXT or DT_NTEXT instead and convert the data from, or to, DT_IMAGE using the data conversion component. (SQL Server Import and Export Wizard) The data type is IMAGE in SQL DB. I would like to export the image and save the same in local folder. Is their any way to perform this task using SSIS flat file destination? What is the best and easiest way to do this? What format should I be exporting to?
View 1 Replies
Jan 24, 2011
I touched on this last year sometime, but I was frustrated at the time and might not have made much sense. I'd like to try again to see if I can get some constructive advice. I am having an issue in choosing a persistence engine. My first choice is FluentNHibernate / NHibernate. However, I am having severe difficulties with their criterion and projection mechanisms. Searching for examples is difficult and when I do find something, I really don't understand what I'm looking at. After a year of trying to bring this together, it still eludes me. I know I could just ask here for help with certain things, but you guys have more things to do than sit and teach me nhibernate criterion. My second choice is Entity Framework 4. I am leaving the CTP 5 off the list for now as there is a major bug in how self-referencing tables are handled at the moment. Now, I have two sub-choices here. The first involves using code first by turning off code generation in the designer and place my enities and edmx in separate libraries (.Domain and .Persistence.Mapping) but this involves a bit of extra work. Then again, for simplicities sake, I could just dump the edmx designer right in the domain library. But this means having the mapping info in the domain library. Not ideal, but it'd work. I still retain the ability to map collections, references and properties as protected or private, and add logic-checking accessors to the entities, as well as setting a protected and public constructor. The entities would still be strong, valid business entities. With these points in mind, what direction should I head?
View 11 Replies
Jun 4, 2010
I have a client requirement wherein client needs a web Application. My team has decided to build it with ASP.Net Using C# as front end. Now my problem here is, client has back end as MS Access and due which numbers of users that are allowed to connect simultaneously to application is restricted to 15-20 users at the most. But client have big number of users who will accessing the site simultaneously.
View 3 Replies
Apr 4, 2011
I am a final year computer science student from Mumbai University, India.The topic of our undergraduate project is SOA.Under this project we are supposed to build 3 service components and one example website that uses those components.I am quite good with Java and have no experience whatsoever with C# or .NET.I am having hard time deciding the language and platform for our project.Can you please suggest what platform I should go for?Please give me a brief comparison between Java/J2EE and C#.NET/ASP.NET in terms of complexity, ease of development, ease of deployment etc.Edit:The original reason why I put this question is:-
We have to do final year project in group of three. My both partners want to do this project in C# and asp.net and I want to do it in java. Since our project is more of server side, java holds some advantages like cross platform over C#Also this point:-What if we implement 2 parts in C#.net(which they will build) and 1 part in Java(which i will build) and then use them to build a sample website.What level(kind) of difficulty it will accompany?
View 6 Replies
Apr 1, 2010
I have a page on which I've thrown a LinqDataSource and a GridView. I've created a DataContext LINQ-to-SQL class called dcResidents.dbml. When I attempt to configure the LinqDataSource to utilize the dcResidents data context - it doesn't appear in the list of options...though under class view (tab in VS) it does appear.
I do have several other working datacontexts - why is this one not being recognized by VS?
View 3 Replies
Sep 13, 2010
How do I create a schema.ini file from a tab delimited file?
I have this so far:
[myFile.txt]
ColNameHeader=True
Format=TabDelimited
CharacterSet=ANSI
I think I need something like this after my last line from above:
Col1=first TEXT width 150
My text file has 7 columns, the first row is the header row. The data comes from a Micosoft SQL Server Database where the fields are of the following types:
int
nvarchar(MAX)
nvarchar(50)
View 1 Replies
Feb 28, 2011
I am returning records from the database and I need to compare those records against my checklist box to determine which ones should be checked.
Query is working properly and returning 3 records.
Vehicle ID = 40, Option ID = 1
VehicleID = 40, Option ID = 36
VehicleID = 40, Option ID = 37
[Code]....
This is not working, can anyone point me in the right direction???
View 7 Replies
Jul 13, 2012
I follow the following link for add dropdownlist in gridview.Adding Dynamic Rows in GridView with DropDownLists in ASP.Net..In this template field the drop down list contain 500 items how can i search the paticular item
View 1 Replies
Jan 20, 2010
I've read several other questions on this topic (here, here, and here), but have yet to see a great answer. I've developed my fair share of data access layers before and personally prefer to use instance classes instead of static classes. However, it is more of a personal preference (I like to test my business objects, and this approach makes mocking out the DAL easier). I have used static classes to access the database before, but I've always felt a little insecure in the appropriateness of such a design (especially in an ASP.NET environment).
Can anyone provide some good pros/cons with regards to these two approaches to developing data access classes with ADO.NET providers (no ORM), in an ASP.NET application in particular. Feel free to chime in if you have some more general static vs. instance class tips as well.
In particular, the issues I'm concerned about are:
Threading & concurrency
Scalability
Performance
Any other unknowns
View 4 Replies
Nov 11, 2010
I'm currently using VS 2008 and I am trying to make my web application to print only 1 specific data set from my SQL database.
For example, i got 3 rows of data sets, how can I choose only 1 data set to be printed?
string reportPath = Server.MapPath("CrystalReport2.rpt");
View 1 Replies
Sep 16, 2012
I have a stored procedure in SQl and i am calling through Entity framework through import functions. Stored procedure is returns columns from 2 different tables.. now what should be return type at Entity framwork end ?
View 1 Replies
Jun 24, 2010
I have a site on which members can select from a list of links (from a ListView in profiles.aspx) in order to view details of another site member (in profile_detail.aspx), using this code:
profiles.aspx and profiles.aspx.vb:
[Code]....
[Code]....
I would like to do the following tasks but need coaching:From a completely different page (in other words, not from profiles.aspx this time), the user clicks on a photo of a site member; the program picks up the UserID associated with the photo from a database table and saves it to a session variable; completely bypasses the profiles.aspx page; goes directly to profile_detail.aspx and displays the correct person.
My problem: I don't how to bypass clicking the link on profiles.aspx.In other words, I want to go directly to profile_detail.aspx and apply the UserID session variable in displaying the person who matches that UserID. You could say that I need to programmatically "click a link" found inprofiles.aspx.
View 7 Replies
Jan 17, 2010
I created following custom log in control and it redirects user to default.aspx after logging in.I'm not exactly sure where I can specify Destination Page Url.When I logg in, I would like to stay in same page instead of default.aspx. ---- code behind ------
Protected Sub login_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles login.Click
If Membership.Providers("custMembershipProvider").ValidateUser(Username.Text, Password.Text) Then
FormsAuthentication.RedirectFromLoginPage(Username.Text, Rememberme.Checked)
[code]...
View 1 Replies
Nov 4, 2010
I have a simple website and can publish it locally to my localhost as the default website.
However, when I try and publish to a different server, VS2008 keeps asking me for the servers id/password.
I have published successfully bwefore to this server from a Windows XP PC running VS2008.
Only difference is that I am now running my VS2008 on Windows 7.
View 1 Replies
Mar 3, 2011
i have a sql server database which has a table name tourheader.in this there are some fields named as follows--Id, name, city, description, tourcode. on the page i have two text box destination and keyword. I want to search the database according to the destination and keyword. in the tourheader the fields contain description and keyword are name and city.
i have make aquery---- string queryString = "SELECT Id , name " + "FROM TourHeader WHERE name like'%" + key + "%'AND city like'%" + key + "%' AND city like'%" + destin + "%'AND name like'%" + destin + "%'";
but it doesnot work properly.
View 10 Replies
Sep 9, 2010
I have a log in control that has this set in the aspx:
View 2 Replies
Sep 8, 2010
Looking at the asp.net v4 URL Routing it's easy to see how to access routing data from basically anywhere in the app.
Via: Page.RouteData.Values["blah"]
Unfortuantely the Route data always is blank by the time i hit the page on my v 3.5 implementation of routing. I was wondering if there was any way to either pass the route values to the final page so i can use them there - i really don't want additional logic in my handler file and i have loads of Routes and don't want many RouteHandlers.
View 3 Replies
May 10, 2010
I have been searching for some information on how to import my xml file into a series of tables using a mapping file (schema).
View 2 Replies
Mar 25, 2010
Is it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
View 1 Replies
