My Techie Blog

  Home  |   Contact  |   Syndication    |   Login
  105 Posts | 5 Stories | 404 Comments | 0 Trackbacks

News

Archives

Post Categories

ADO.NET

Ajax

API/WebServices

ASP.NET Resources

BizTalk Server

Blogs I read

Free Books

How to

iOT

JavaScript

JQuery

JSLink - SharePoint

JSON

LINQ

Misc

Mobile BI

MS Business Inteliigence

Reporting Services

Responsive/MVC ASP.NET

SEO

Sharepoint Resources/Tools

SharePoint 2010 Branding

SharePoint 2010 Videos

SharePoint 2013

SilverLight

SPServices

SQL Server

Sql Server 2012

SSIS

Web Optimization Tools

Web Performace Tools

Windows 8

Windows Azure

Windows Azure

Windows Phone

WorkFlows

WSS V3

xml

SSIS

Sql Server Integration Services
I have been wanting to add this to my list.
Its a must if you work with SSIS

See Devins blog here

Hope this helps


I was trying to export data from a txt/csv file to sql server table. After setting up the package and executed it .It worked if the sql server destination is on the same server were i ran the package from. But when i tried to export the data to a different server i get the error:- [SQL Server Destination [2625]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: ......

Some useful SSIS stuff:-

Enjoy