Tag | SSIS Posts

I was doing a data conversion that involved importing data from a flat-file source into SQL Server. I fired up SSIS and created the Data Flow tasks that would move the data into the SQL Server tables. The problem was, the longer fields (i.e. a “Notes” column) were all being truncated no matter what data type I made the destination field. So I created a Data Conversion task to sit between the Flat-File data source and the SQL Server Destination. After I had tried every conceivable destination data ...

Today /n software announced new versions of three more toolkits today: SharePoint Extensions V3 BizTalk Adapters V3 SSIS Tasks V3 I have been involved in building these products, so if you have any questions feel free to let me know. Technorati Tags: BizTalk, SharePoint, SSIS ...

Location: At Lamar Advertising Wednesday, December 3, 2008 5:45 PM - 8:00 PM Sponsored By: Strategic Staffing Solutions Presenter: William Assaf BIO William Assaf has more than three years working as a dedicated SQL administrator and architect. Before that he also worked as a .net developer and SQL reporting developer. William has SQL 2000 and 2005 certifications, is a Development Consultant for Sparkhound and is involved in multiple projects in various roles, from SQL optimization to data conversion ...

This post is mainly for those people that were at my presentation at this years SQL Down Under Code Camp. I said that I would post the slides and the sample project (there are links at the end of this post) and here they are. a Powerpoint 2007 version of the presentation [link 2] a Powerpoint 97-2003 version of the presentation [link 2] and the sample project I was using for all the demos [link 2] Note: Some of the demos are using the trash destination and the data generation data source from www.sqlis.com ...