SSIS insert bulk of data into remote table with trigger

hmmm, nice we have SSIS it makes life easier but it usually comes with non-understood problems like

“SQL Server Destination” (2185) failed with error code 0xC0202071 it means when you insert data into table in remote SQL Server don’t use SQL Server Destination component however use OLE DB Destination component, thank you SQL Server Central

Anyway I used OLE DB Destination component and everything went well but I found the trigger which updates something doesn’t fire simply because I do bulk insert and I should tell the BIDS please fire it.

So, right click on OLE DB Destination component then Show Advanced Editor… Component properties FastLoadOptions write FIRE_TRIGGERS

Thank you Piotr Rodak

Loading a Data Warehouse in SSIS

Session #20: Loading a Data Warehouse in SSIS

Event: 24 Hours of PASS

Presenter: Brian Knight

Download

Delivering Good Performance Consistently with SSIS

Session #1:

Event: 24 hours of PASS

Presenters:

Session #4: Delivering Good Performance Consistently with SSIS

Event: 24 Hours of PASS

Presenter: John Welch

Download

Text Mining

Session #7: Text Mining

Event: 24 Hours of PASS

Presenter: Dejan Sarka

Download

All about Microsoft SQL Server 2008 R2

Download SQL Server 2008 R2: http://www.microsoft.com/downloads/details.aspx?familyid=E19689BD-38DD-46C4-8645-F58CA4D61D1F&displaylang=en

What’s new in SQL Server Integration Services: No new features they just fixed some bugs: http://blogs.msdn.com/mattm/archive/2009/08/14/no-new-features-in-for-integration-services-in-sql-server-2008-r2.aspx

What’s new in SQL Server Analysis Services: I didn’t find any information about that!! if you know please drop a link.

What’s new in SQL Server Reporting Services: http://blogs.msdn.com/sqlrsteamblog/archive/2009/08/11/sql-server-2008-r2-august-ctp-what-s-new-in-reporting-services.aspx

Microsoft Gemini: http://www.microsoft.com/officebusiness/office2010/Default.aspx?vid=Gemini or https://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=21090 to know about Microsoft Gemini

A small stand-alone MSI for Report Builder 3.0, August CTP, is now available for download here: http://go.microsoft.com/fwlink/?LinkID=160384

Download packages for SQL Server 2008 R2 August CTP are available here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=e19689bd-38dd-46c4-8645-f58ca4d61d1f

Source: http://blogs.msdn.com/sqlrsteamblog/archive/2009/08/14/report-builder-3-0-august-ctp.aspx

Integrating SSIS with C# to deliver very scalable Data-Driven Solution

نوضح في هذه المقاله استخدام ال SSIS  لبناء C# application to get very scalable data-driven solution  و كيفيه ارتباط ال C#  بالـ SSIS

ما هم ال SSIS  ؟؟ كيفيه الحصول عليه ؟؟ وماهي مميزاته؟؟ وفيما يستخدم اكثر؟؟

اولا SSIS  تعني SQL Server Integration Services  وهى احدى منتجات ميكروسوفت ويأتي مع جميع نسخ ال SQL Server  ما عدا ال Express  كان يسمى فيما سبق DTS  لكن SSIS  يعتبر منتج جديد وليس تحديثا من ال DTS

هي اداه قامت ميكروسوفت بتطويره و اخراجه للسوق عام 2007 وتهدف الى نقل البيانات من اكثر من Data Repository  الى Data Repository  اخر مثلا نقل البيانات من ملف نصي، ملف Excel  او قاعاده بيانات SQL or Access  الى جدول في قاعده بيانات في ال SQL Server  دون الحاجه لوجود SQL Server  ولا يجب مصدر البيانات او وصول البيانات SQL Server بأختصار يكمن استخدمها لنقل البيانات من ملف نصي الى قاعده بيانات Oracle تعتبر ال SSIS  اداه ETL (Extract, Transform, and Load)  اي انها تقوم بأخد البيانات من المصادر تحسين البيانات بشكل وتنظيمه وبعد هذا نقلها الى نقطه الوصول.

SSIS Community Tasks and Components

If you have strange SSIS task, and you believe you need 3rd party tool could help you to achieve it faster, integrated with BIDS, and open source which you can support its community I found on CodePlex SSIS Community Tasks and Components http://ssisctc.codeplex.com/

This is a community project for developing additional tasks and components for SSIS, and identifying other CodePlex projects that do the same. 34 Connection Managers, Tasks, and Components exist on CodePlex – find them here.

Attunity Oracle-CDC for SSIS

I’ve received this email from PASS Community

Dear SQL Professional,

Why move all the data when you can just move the changes?
What’s the point purchasing expensive ETL software when you already have SQL Server?

Learn about Attunity Oracle-CDC for SSIS, a complete and affordable solution for integrating continually changing Oracle data using wizards built into SQL Server Integration Services, leveraging best-of-breed CDC technology that identifies, captures, and delivers only the changes made to your Oracle data.

Leverage your SQL Server skills and software to reduce cost and accelerate Oracle data replication, synchronization, and real-time integration and enable operational reporting, business intelligence and data warehousing projects.

Join a free webinar and demonstration to learn about:

• Log-based CDC technology for Oracle
• Using SSIS for real-time and efficient Oracle data integration
• A simple and affordable solution you can implement in days

Date: Wednesday, June 3, 2009
Time: 2:00pm – 3:00pm EDT

Click to Register

Click to Download