Fix: Unable to create the type with the name 'SPCRED'

Problem:

I tried to export one of the SSIS packages from Integration Services catalog. I got the below error

 

"Unable to create the type with the name 'SPCRED'. (Microsoft.SqlServer.ManagedDTS)"

 

Solution:

When I explore this issue, found that the package extracts data from SharePoint list. but we don't have inbuilt component in SSIS to fetch the data from SharePoint. So We need to use third party connecter which is exists in CodePlex "SharePoint List Source and Destination"

 

 

after Install this connector, I can export the  SSIS packages from Integration Services catalog without any issues.

 

Also, you can see this connector added in SSIS connection Manger

 

Note:

• If it is not appeared in connection manager then you've to restart your Visual studio if it opened
• If not appeared in connection Manager after restart your VS, then the version you installed is not compatible with your VS, so choose the Proper version and install it.

E-Book Gallery for Microsoft Technologies

You can download existing and new content for ASP.NET, Office, SQL Server, Windows Azure, SharePoint Server and other Microsoft technologies in e-book formats. Reference, guide, and step-by-step information are all available. All the e-books are free

E-Books in English

ASP.NET	Deploying an ASP.NET Web Application to a Hosting Provider using Visual Studio Getting Started with ASP.NET 4.5 Web Forms (Beta) Intro to ASP.NET MVC 4 with Visual Studio (Beta)
Office	First Look: Microsoft Office 2010 Microsoft Office 365: Connect and Collaborate Virtually Anywhere, Anytime Security and Privacy for Microsoft Office 2010 Users
SharePoint	Configure Kerberos Authentication for SharePoint 2010 Products Get started with SharePoint Server 2010 Deployment guide for SharePoint Server 2010 Upgrading to SharePoint Server 2010 Profile synchronization guide for SharePoint Server 2010 Remote BLOB storage for Microsoft SharePoint Server 2010 Governance guide for Microsoft SharePoint Server 2010 Business continuity management for SharePoint Server 2010 Technical reference for Microsoft SharePoint Server 2010
SQL Server	Books Online: Transact-SQL Data Manipulation Language (DML) Reference Introducing Microsoft SQL Server 2008 R2 Introducing Microsoft SQL Server 2012 Master Data Services Capacity Guidelines Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide QuickStart: Learn DAX Basics in 30 Minutes SQL Server 2012 Tutorials: Analysis Services - Data Mining SQL Server 2012 Tutorials: Analysis Services - Multidimensional Modeling SQL Server 2012 Tutorials: Analysis Services - Tabular Modeling
Visual Studio	Moving to Microsoft Visual Studio 2010
Windows	Deploying Windows 7: Essential Guidance Programming Windows 8 Apps with HTML, CSS, and JavaScript (First Preview)
Windows Azure	Windows Azure Prescriptive Guidance Windows Azure Service Bus Reference
Windows Phone	Programming Windows Phone 7
Windows Server	Introducing Windows Server 2008 R2 Introducing Windows Server 2012 (Based on Beta) Understanding Microsoft Virtualization Solutions: From the Desktop to the Datacenter, Second Edition
Career	Own Your Future: Update Your Skills with Resources and Career Ideas from Microsoft

Happy Learning J

Current user account is not a member of the VS Developers group

Problem:
Today, when i tried to run my web application from Visual Studio IDE, it throws the error:

Visual Studio .NET cannot create or open the application because the current user account is not a member of the VS Developers group on the Web server computer.

Solution:
1. open a command window. At the command prompt, type: COMPMGMT.MSC
(Or)
Right Click on My Computer, Select Manage

2. Select Groups from "Local Users and Groups"
3. Double click on "VS Developers"

4. Click Add, Enter username, then click on "Check Names" to resolve your id

5. Click Ok to add the user to Group.


Now if you run your program, it will work.
:-)

C#: Find Century from Year

Today one of friend asked me, how to find century from the year thru C# code. The following code snippet helps:


int year = 2010;
int cent = year / 100;
year %= 100;


if (year > 0)
cent = cent + 1;


Console.WriteLine("{0}C",cent);

Output:
21C

Visual Studio Editions feature grid

Source: http://en.wikipedia.org/wiki/Microsoft_Visual_Studio

Note: Click on the Image to see Enlarged view

Unable to Access IIS components

Today, One of My friend, Trying to deploy Webservice in local Webserver, but Throws the following Error!

you must install the following IIS components:

IIS 6 Metabase and IIS 6 Configuration Compatibility
ASP.NET
Windows Authentication

For more information, press F1.

But He installed IIS in his PC, but still it says the same error.

Note : If you are not installed, then follow the steps given in my previous post, How to Install IIS in Vista & Windows 7

If you are using other Other Operating System, then follow the manual.

After Installed IIS, We tried many times to publish the Web service, but still we faced the same issue, finally we come to know, My friend doesn't have proper priviledge to deploy to IIS. If you want publish on IIS, you should have admin rights.

So We run Visual studio thru "Run as administrator", then we tried to deploy the Web service.

Wow ... It works Well!

Hope it Helps you, if face the same problem!

Windows Mobile Hands-On Labs

Dear friends,


If you want to learn about Windows Mobile application development, the “Windows Mobile Hands-On Labs” will help you.


Have a look at this link. http://msdn.microsoft.com/hi-in/windowsmobile/bb264328(en-us).aspx

Fatal Execution Engine Error (7A036050) (80131506) - Visual Studio Crash

This article is the continuous of my previous one, Visual Studio crash when adding items to the toolbox.
I provided four solutions are in this article, which I found thru Google search. Also I mentioned in the article, 4th solution is helped me, but it works me one time only, after clear Visual studio Cache. If I try to add the items to the toolbox, again Visual studio closed automatically.

Now I come up with other solution, it fixed my issue permanently.

Solution:
When I checked in the "Event Viewer" of my system, it logged the Error as

.NET Runtime version 2.0.50727.3607 - Fatal Execution Engine Error (7A036050) (80131506)

Microsoft released the Fix for this issue. You can download the fix from this the following link,

https://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=16827

Download the relevant fix depends on your VS application Architecture and install it. 

After install this fix, restart your system. Then run your Visual Studio. Now you can add the item many times to the toolbox.

Visual Studio crash when adding items to the toolbox

When I tried to adding items to toolbox thru Visual studio 2008 IDE, then my visual studio has closed automatically. 

I tried many times, but I faced the same issue. I searched in Google and I got many solutions, but nothing is helped me and many people replied that it helps others, I placed the solution here. It may help you
Solution1:
Reinstall add ins by Visual Studio commands
1. devenv /setup
2. devenv /resetuserdata
3. devenv /resetsettings CSharp


Solution 2:
devenv /safemode


Then use Choose Items on toolbox and run through each of the tabs. Once you accept any exceptions raised on loading controls, you can then open Visual
Studio normally and add items.


Solution 3:
If your system contains PowerCommands installed, then


This is taken from
http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/e2434065-9921-4861-b914-9cc9d6c55553/


Through Microsoft's help they came up with a work around which is a simple modification to the devenv.exe.config file.


This will exist in (64 bit systems) C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE 
Or (32 bit systems) C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE


Add this XML token to the dependentAseembly list. They had me add it after the office one, but im not sure if that matters.

<dependentAssembly>
<assemblyIdentity name="office" publicKeyToken="71e9bce111e9429c" culture="neutral"/>
<codeBase version="12.0.0.0" href="PrivateAssemblies\Office12\Office.dll"/>
</dependentAssembly>
<!-NEW STUFF-->
<dependentAssembly>
<assemblyIdentity name="Microsoft.PowerCommands" publicKeyToken="null" culture="neutral"/>
<codeBase version="1.1.0.0" href="C:\Program Files (x86)\PowerCommands\Microsoft.PowerCommands.dll"/>
</dependentAssembly>

Now you should be able to run PowerCommands with VS 2008 SP1 and XAML with no crashes. I guess there will be a fix when the next PowerCommands version comes out or on .net 4.0.


Solution 4:
1. Go to your %userprofile% Folder, (Start -> Run -> Type %userprofile% -> Enter)
2. Open Application Data\Microsoft\
3. Then Clear all the content from the following folder


VisualStudio
MSDN
VSA


Then open VS IDE,  try to add the items in the toolbox.
Solution 4 is helped me. Hope it helps you!

Visual Studio 2010 Professional Whitepaper

The Microsoft Visual Studio 2010 Professional development system is an integrated environment that simplifies creating, debugging, and deploying applications. Unleash your creativity and bring your vision to life with powerful design surfaces and innovative collaboration methods for developers and designers. Work within a personalized environment by targeting a growing number of platforms, including Microsoft SharePoint and cloud applications, and accelerate the coding process by using your existing skills. Integrated support for test-first development and new debugging tools let you find and fix bugs quickly and easily to ensure high quality solutions.


Download VisualStudio2010Professional_Whitepaper.xps

"Send To" Not Listing the Shortcut of Application After Install Setup Kit

Today we have created setup kit for windows based application. After installed the setup, it should extract the application to “Send To” Folder.

This is our requirement, everything is going well, application installed well and shortcut file of the application in created in “Send To” folder. But the problem is, when you select any file and click “Send To”, the list is not showing the application.

When I search the solution in the Google, I found the following solution.

1. We need to modify the Setup file (*.MSI), which is output of our setup project, before install it. To modify the file first Download Orca.Exe and install it.

Orca.exe is a database table editor for creating and editing Windows Installer packages and merge modules. The tool provides a graphical interface for validation, highlighting the particular entries where validation errors or warnings occur.

2. After installed, open the Orca application from installed location.

3. open your output file, *.MSI in Orca.Exe

4. Go to the “property” Table and select from left pane.

5. In the right pane, it will list the properties it contains

6. Right on the right pane, select “Add Row”

7. Add new property “DISABLEADVTSHORTCUTS” with value “1” as shown in the image.

8. Click Ok, and then Save it.

9. Now if you install this package, it will be listing on the “Send To” list

Note: Click on the image to see the maximize view

Hope it helps!

Asp.Net Mvc Design Pattern

Note: Please Wait Till Loading the Presentation File. It will Be Visible thru on Blog Site

No template information found - Visual Studio tools for Application (VSTA)

Problem:

Today I tried to create new project in “Visual Studio tools for Application” (VSTA IDE).

But it throws the following Error

"No template information found. See the application log in Event Viewer for more details. To open Event Viewer, click Start, click Control Panel, double-click Administrative Tools, and then double-click Event Viewer."

After close this error message, project template window displays empty as shown here

Solution:

1. Find the VSTA.EXE in your drive

2. open command prompt (CMD.EXE)

3. set the location VSTA.EXE in command prompt

4. run VSTA /setup

Note: before run this close your application then try.

/Setup Extracts the project templates for the host application and initializes the host-specific environment for the current user. This switch requires administrator privileges.

If not works,

First run VSTA /ResetSettings Then run VSTA /setup

After run this command, if you create new project, it will displays the following template window.

Hope it helps!

Object reference not set to an instance of an object - Visual Studio 2008 SP1

Problem:

I installed the Visual Studio 2008 SP1 on my system. After that I couldn’t create any project in Visual Studio 2008 IDE.

I’m getting the following Error:

“Object reference not set to an instance of an object”

I checked many sites, it suggests me to re-install or repair visual studio 2008.

But it doesn’t help me.

Accidentally it was discovered that this is a per-user problem. After some research I came to know that some of Visual Studio components have had some problems previously so they were skipped from loading.

Solution:

1. First find out the location of the file devenv.exe, in your system.

2. open Command prompt, set the default location to location of the file devenv.exe

3. Type devenv.exe /ResetSkipPkgs

4. Run it, after completed it will open VS IDE.

(Or)

1. Open “Visual Studio 2008 Command Prompt” from Visual Studio Tools thru Start menu.

2. Type devenv.exe /ResetSkipPkgs

It worked well and saved me lot. Hope It may help you too!

Microsoft Visual Studio International Feature Pack 2.0

The Visual Studio International Feature Pack 2.0 contains a set of controls as well as a set of class libraries designed to help .NET developers create world-ready applications.

The Visual Studio International Feature Pack 2.0 is an extension to Version 1.0 (version 1.0 is named "Microsoft Visual Studio International Pack 1.0 SR1") and contains a set of controls as well as a set of class libraries designed to help .NET developers create world-ready applications.

• Yomigana Framework contains a class library and controls.
• Chinese Text Alignment Class Library and TextBox Controls contains WinForm and WPF TextBox controls that support text alignment for Chinese and a class library which developers can use to draw strings using the Chinese style text alignment.
• Chinese Auto Complete Class Library and TextBox Controls contains WinForm and WPF TextBox controls that support IME aware autocompletion for Simplified and Traditional Chinese as well as a class library which developers can use to add the IME aware auto-completion feature to standard controls.
• Korean Auto Complete Class Library and ComboBox Controls contains WinForm and WPF ComboBox controls that support IME aware auto-completion for Korean as well as a class library, which developers can use to add the IME aware auto-completion feature to standard controls.
• Numeric Formatting Library: Additional support for Arabic numeric formatting was added in version 2.0. This class library can now format the numeric data in 5 languages.

Download Vsintlpack2.msi

Introduction to .NET - Video Presentation

This is very Informative video for .NET Beginners.

This video is Presented By,
Mike Ormond
Developer & Platform Group
Microsoft Limited

Presented On 14th April 2004

Hope it helps you!

What is DataSet?

DataSet is an ADO.NET object, it helps to store the data in memory for program use. It is a disconnected in-memory cache. We can do the all the database process with dataset like update, delete and adding new record. After finished all the operation with dataset, changes can be made back with database for updating.

Filter the EventLog Entries thru C# Code

To Read & Write Event Log thru C#, System.Diagnostics.EventLog class will help. When we read from Eventlog, the following code will helps

EventLog EvLog = new EventLog("Application", ".");
foreach (System.Diagnostics.EventLogEntry entry in EvLog.Entries)
{
.....
}

This code will read all the Entries from Event Log, here there is no option to filter the entries of Event log.To implement the filter on the Eventlog, we have to check the value one by one in the for each loop, as given below

foreach (System.Diagnostics.EventLogEntry entry in EvLog.Entries)
{
if (entry.TimeWritten > DateTime.Now.AddDays(-1))
{
.....
}
}

If the list of entries are more in the Event log, then this is not proper way. It will leads to performance issue.To avoid this, we can use WMI Query Language. this Query Language is same as SQL Query structure, we can filter the data in the same way of SQL.

Win32_NTLogEvent is a WMI class which is used to translate instances from the Windowsevent log.

Have a look at the following sample code, (written in C# and windows application)

string SomeDateTime = "20090817000000.000000+000";
string Query = String.Format("SELECT * FROM Win32_NTLogEvent WHERE Logfile = 'Application' AND TimeGenerated > '{0}'", SomeDateTime);

ManagementObjectSearcher mos = new ManagementObjectSearcher(Query);
object o;
foreach (ManagementObject mo in mos.Get())
{
foreach (PropertyData pd in mo.Properties)
{
o = mo[pd.Name];
if (o != null)
{
listBox1.Items.Add(String.Format("{0}: {1}", pd.Name,mo[pd.Name].ToString()));
}
}
listBox1.Items.Add("---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
}

In this sample code, we are using following Query

SELECT * FROM Win32_NTLogEvent WHERE Logfile = 'Application' AND TimeGenerated > 20090817000000.000000+000

This query will fetch the data from Application Log, where the log created on or after 17-Aug-2008This is code display the filtered output in listbox control as shown below

Read Event Log using C#

The Following sample code helps to Read Data from Event Log. This is a sample windows application written by using C#.

In the following sample code, I used 2 controls, Listbox and EventLog Controls.

Set the Log Property of Eventlog control to name of the log to read or write. I selected System Log to test this code

In the Form Load Event, I written the following code,

foreach (System.Diagnostics.EventLogEntry entry in eventLog1.Entries)
{
listBox1.Items.Add(entry.EntryType.ToString() + " - " + entry.TimeWritten + " - " + entry.Source + " - " + entry.UserName);
}

This code, read the Data from Log file and written display in to listbox control.

Now if run the code, it will display as shown in screen shot