ProDev Solution Inc.
Smart way to the future
SQL Server 2208 Wizard cannot import text columns longer then 255 using Excel source
05 days
At time you try to import data from excel to SQL Server Database but the text column is very large you got the truncate column error:
Messages
Error 0xc020901c: Data Flow Task: There was an error with output column “English String” (18) on output “Excel Source Output” (9). The column status returned was: “Text was truncated or one or more characters had no match in the target code page.”.
(SQL Server Import and Export Wizard)
Error 0xc020902a: Data Flow Task: The “output column “English String” (18)” failed because truncation occurred, and the truncation row disposition on “output column “English String” (18)” specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task: The PrimeOutput method on component “Source – Sheet1$” (1) returned error code 0xC020902A. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
(SQL Server Import and Export Wizard)
But this is a solution for this problem, only you need is edit your register in windows and change TypeGuessRows the key to 0 in this path:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0.
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\3.5
News ProDev Marketing Services
0108 days
Graphic Design, Advertising…
We offer a wide range of Professional Design Solutions. Anything from Logos, Books or Magazine illustrations to breathtaking Photography and beautifully designed Websites.
The ProDev team has a combined experience of over 15 years in the industries of Graphic and Web Design. It doesn’t matter whether you are an individual, a small business or a large corporation, our great designs will definitely make the difference you are looking for.
Exchange 2010: How to Grant Send on Behalf Permissions for a Distribution Group
0317 days
When creating a distribution list or group for security reasons Microsoft Exchange 2010does not give permission to any member of the emails sent.
To enable this a group member to send emails, use the Exchange PowerShellcommand Set-DistributionGroup this.
Set-DistributionGroup “ProDev Team” -GrantSendOnBehalfTo John.Fernandez
ProDev Team means the group name.
John.Fernandez means the user you grant permission to send email trough this group.
How you can unlock you IPHONE?
1382 days
First of all, with the new version 4.3.2 IOS can unlock the Iphone 4 but only in tethered boot only, then untethered jailbreak is in works, and will be out soon.
However, not all this lost to the new baseband of Iphone 4, with the Gevey simcard you can keep your iphone unlocked and use it with any company.
After having explained this, now to the action. There are several tools to unlock Iphone, Redn0ws, sn0wbreeze 2.6 is a custom IPSW Creator for IOS 4.2.7/4.3.2.
Depending on the situation or the baseband that has your iphone so will be the version of the program that you use to do the unblocking. The explanation thate will be with the Snowbrezze is very easy and simple.
First, You need to download the version of the Snowbrezze according to the model of Iphone that you have and the version of IOS you want to mount it or that you already have your Iphone.
Second: After having downloaded these two files, we will continue to open up the snowbrezze with administrator privileges; and follow the following steps:
Third: When finish the creates the file sn0wbreeze_iPhone 3 g-4.3.2. ipsw on desktop. Open itunes and by pressing shift gives you click the restore button, then restore the iphone with this custom firmware.
Fourth: After having restored the iphone with the custom firmware, now your iphone this jailbreak but not unlocked; to unlock it open Cydia and install Ultrasn0w application, if the application does not appear in Cydia in the part of Manage/Source Add this repo: http://repo666.ultrasn0w.com/
Good up here a short explanation of how to unlock your Iphone, hope to be useful.
How to show multiple attachments in the same row on Sharepoint 2010?
0402 days
by Yoaldis Pena
in Sharepoint
First in Sharepoint Server or Foundation we have to create a custom list and check the box that this list accepts attachments.
Then with the help of Sharepoint Designer 2010, our sharepoint site open and edit in the part of the code where we add the following line:
< SharePoint:AttachmentsField runat = “server” FieldName = “attachments” ControlMode = “Display” Visible = “true” ItemId=”{$thisNode/@ID}” / >
You want to clean your mac and you don’t know like?
0520 days
by Yoaldis Pena
in Mac
This is a free application (OnyX) primarily to maintain our Mac clean and with good work performance, can make you scheduled maintenance, also checks the status of your hard disk, runs some system tasks, and cleans up all temporary files of internet, etc.
http://www.macupdate.com/app/mac/11582/onyx
I hope that you enjoy, do not forget that it is totally free, and has the same category as the CleanMyMac is payment.
Do you know how to remove a virus or program that runs when you start the computer?
1521 days
Well, commonly when we are on the internet without giving us accounts downloaded files or programs that our view tend to be good, but the reality is that they are worms or Trojans, that in one way or another can affect the operation of our computer; one very common for example is often called AntivirusPro runs every time we open the machine telling us that we are infected with viruses and have many viruses that is one example of many, others will block internet explorer, can’t it work.
Here leave you a solution:
1 Presionanos the Windows key + R
2. Then we write there Msconfig
3 We give click on the Startup tab
4. In this tab this the key to everything, here have a bit of careful but nothing alarming, so don’t worry. We have 4 columns (Startup Item, Manufacturer, Command, Location). Hence we have to look in the Startup Item name of the virus, Trojan or worm that column by it generally comes with a strange name for example 9ftrmthgho something like this, from have located our goal then wrote what is in the Location column and then remove the checkbox, we give click on the OK button and restart.
5. When the computer restarted then we are going to the Location where we this virus, Trojan or worm and delete it.
We do this with all viruses, Trojans or worms that start with the system and are affecting the performance of our computer.
I hope them to enjoy.
New version the Microsoft Office Mac 2011 coming soon.
0577 days
The new version of Office 2011 for Mac is coming out this month. This comprehensive and primarily for the use of emails with Entourage change the Outlook also a good integration with Microsft Exchange.
It also comes with some added applications such as Remote Desktop, as well as a better version of Microsoft Messenger for Mac
Hope you enjoy.
Your computer this slow?
8579 days
They can be many reasons why this slow your computer. First check that you have a good antivirus installed. Then press the Ctrl key + R and that open a text box and you put this command, msconfig, and on the tab that says Startup unmarks programs that are starting in the system are not known or you see the name this way dubious.
On the other hand, do you a defragmentation of your hard disk, Incio, accessories, System Tools and then click Disk Defragmention.
And finally do a Full Scan with your antivirus, check that you have a good antivirus, aqui dejo les a list of the top paid and free.
Paid: Kaspersky Internet Security 2011, Norton Internet Security 2011, McAfee 2011
Free: Microsoft Seciruty Essentials (currently I am using this one, this good they recommend and it’s free), AVG.
Enjoy this post, thanks