.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Why my BDC is not importing new profiles from DB table?

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
I have 72000 profiles records in SSP profiles database. I connected this BDC with SQL table. SQL table has 81000 records. When I do full Import it is importing only 72000 records only, not complete 81000 records. How to get them into SSP?

View Complete Post

More Related Resource Links

importing table with Access "memo" field to SQL

I imported an access database using the DTS wizard, into SQL 2005. There is a field in one of the Access tables that is a memo field, filled with a bunch of text including linebreaks. After importing, the field is indicated as the nvarchar(MAX) datatype when I check in SQL Enterprise Manager. The text in that field is displayed without line breaks, both in EM and when viewed on a web page. I changed the datatype of that column to "text" and now can see line breaks when I hover over a value in that column while viewing the table data in Visual Studio 2010's Server Explorer.But when I display the data in a ListView, there are no linebreaks. When I view my TableAdapter in my dataset, there are no linebreaks either.I must be missing something here? Thanks. 

trouble getting dates right when importing Access table

I was given a bunch of data in Access and am putting it in SQL 2005 for an ASP.NET web app. Tryingto do a query to select only records where the current date is after the "postDate" field and on or before the "expireDate" field. WHERE (postDate <= CURRENT_TIMESTAMP) AND (expireDate >= CURRENT_TIMESTAMP) I'm getting no records returned even though there are some records that qualify. Tried using CURDATE() and NOW(), no difference. At this point I think it may be because the dates are not in the correct format. The columns were originally "Date/Time" format in Access and when I imported them into SQL using the DTSWizard, the datatype for those columns became "smalldatetime." Dates are in the format M/DD/YYYY HH:MM:SS. I'm guessing the query won't work because SQL is expecting YYYY-MM-DD. How do I fix this? Been spending a depressing amount of time running in circles with this.

I created a user profiles table, now what?


I'm using the ASP.NET Configuration tool to add User management to my application.  I didn't like how the aspnet_Profile table stored all user profile info as blobs of information though.  I prefer having each profile value as a separate column in a db table.  So, I went ahead and created a table with a few columns, including the UserId uniqueidentifier column that I want to link back to the aspnet_Users table.  I set up the relationship between the Users table and my profile table as a 1 to 0..1 relationship.

What I'm stuck on right now is how do I initially create the profile record so I can use it for editing it's values.  When a user registers to my application, I want a new record to be created in my Profile table with the UserId to be the same as it was created in the Users table.  I'm totally stumped though.  A new record in my custom profile table should populate with a UserId, so when I choose to update the profile, it has a reference to which profile record to update.  So, how can I get this record with UserId to be created when a user registers?

Importing table/ column details from one report to another

is it possible to import a value present in the  column/table of a report to another report. The is just to avoid the creation of datasets again in the second report.

importing multiple dbf files into same table



I have an old dbf program that provides me with a dbf ouptut on a daily basis. Each file is identical, but the file name is different by using the following naming convention: MMMDDYY.dbf, for example, OCT2710.dbf.

My OS is Windows Server 2008 R2 64 bit
My version of SQL is 2008 R2 64 bit
The DBF files appear to be DIII (I am able to use this type to import into an access database, one file at a time, and it creates a new file, not appending).

I have about 2 years worth of dbf files that I would like to import into a single sql table in order to be able to create some reports. What I'm looking for is a macro that will enable me to run it against a file folder and import all of the dbf files until it has imported them all. I want to do this as an append as each of the files have identical layout and so append should work fine. I have tried to do an import via 32 bit as well as 64 bit import wizard but can't seem to figure out how to do it. I have created a 32bit odbc to the folder but the sql import for both 32 bit and 64 bit won't recognize the odbc connection.

Has anyone got any ideas about how to resolve this? I did manage to find an old sql 2000 server that was able to do the import, but it was quite a manual operation.


SSIS importing from a global temp table to another database


I have a work flow as followed but haven't been had any success after the 1st step.

1. run a query to create a global temp table from ServerA.databaseX

2. pull the data from the global temp table to the ServerB.databaseY

I think the problem is that after the step1 excuted, the session closes and the global temp table gets deleted. So when the step 2 tries to access the global temp table it's no longer there.

I tried to pull the data using the direct query method (no temp table) but it took too long - more than 45 minutes. If i have to do the above steps manually, it wouldn't take more than 15 minutes.

I dont have access to create a local table in the destination server/database.

Is there a way to keep the session alive so i can pull data from the global temp table.

I appreciate any help you can provide.

Importing Email Body to Sql Server Table


Hi All,

I am not sure if this is even possible, but Is there any way to import the contents of the email that I get to a Sql Server table?
Not from outlook, but Lotus Notes to Sql Server.


Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Insert value using Table Value Functions

a real gem in Sql Server 2008. mostly people still using Stored procedure may be they shifted to SQL Server but they are not using TVF right now.

Using jQuery to Filter Table Rows

The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

RadioButton Groups, Table Rows And NamingContainers in asp.net

The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

RadioButton Groups, Table Rows And NamingContainers

(In which AJAX-enhanced CheckBoxes become more useful than RadioButtons but inheritance saves the day, and a simple RadioButton-derived control establishes the purpose of a control's naming container)

The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

Building a 3-Tier App with Silverlight 3, .NET RIA Services, and Azure Table Storage

Silverlight 3, .NET RIA Services, and Windows Azure Services Platform makes a 3-tier Cloud application easier to build: Silverlight 3 as presentation tier, .NET RIA services as the business logic and data access tier, and Windows Azure Table as the data storage tier. The sample application in this article demonstrates the architecture with a simple Survey application with all these technologies working together from Windows Azure.

Configuring User Profiles in SharePoint Server 2010

Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

Temporary tables in SQL Server vs. table variables

When writing T-SQL code, you often need a table in which to store data temporarily when it comes time to execute that code. You have four table options: normal tables, local temporary tables, global temporary tables and table variables. I'll discuss the differences between using temporary tables in SQL Server versus table variables.

Import XML File to SQL Table

Here is a brief example of importing an XML file into SQL Server table. This is accomplished by using the BULK option of OPENROWSET to load the file, and then utilizing the XQuery capabilities of SQL Server to parse the XML to normalized table format. This example requires SQL server 2005 or SQL Server 2008.

First, the following XML is saved to XML file C:\Products.xml.

Adding the table row below a particular row.


What is the best method in jQuery to add an additional row to a table as the row below a particular row?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend