If your SSIS server will require access to  Oracle DB you can find interest in this blog. You must still request access and provide valid credentials to access the information on the Oracle warehouse. This section only instructs how to install and configure the Oracle driver for connectivity. Preparing for the Installation Download the Oracle client to your server’s local C:\ drive, use the table below to determine which installations or additional downloads you must perform. For x64...

This is a live post from the session of Henk van der Valk at Tech Ed Israel 2010 . This session has great tips and tricks for you in SSIS and is in English (just in case you're reading this blog and don't understand Hebrew :)) Checking for problems when test loading data: Select * from sys.dm_os_wait_stats Number 1 wait: pageiolatch_up Solution: add more spindles So - just add more hardware? Number 2 pagelatch_up Solution: add more database files Configure 1 to 4 files per filegroup to get...

T-SQL Israeli CardID Checker / ת.ז. ישראלית Once in a while I come across code that I didn’t fins in the internet … mainly because it’s for local use ;) This is one of these times :) This code is the T-SQL version of the algorithm  that checks the given Israeli CardID , and adds a leading Zero , if need one ( like in my personal case ) , and calculates the “Check Number” ( SIFRAT BIKORET ) , if it’s missing. I needed this for an SSIS Package that loaded monthly information needed for my SharePoint...

This is continued live blogging from the Donald Farmer seminar from the SQL & BI convention in Tel Aviv of Data Integration in Large Organizations. SSIS 2008 improvements over SSIS 2005 C# scripting can reference all .net assemblies VSA replaced by VSTA Pipeline Scale Up Tuning SSIS through looking at the buffers on the Data Flow. In SSIS 2005 you would add buffers and break up flows SSIS Tip: Tools > Options > BI Designers > IS Designers: Control Flow Data Connect Data Flow Data Connect...

This is live blogging from the Donald Farmer seminar from the SQL & BI convention in Tel Aviv. I would really like to thank Hamada who lent me his netstick so I can blog - Thanks Hamada! Business Intelligence is about people not about IT. Your data is always connected to real world and in direct connection to it. It's important to know your business for you to design a good Decision Support system. BI has always been in the middle of the spectrum - tactical decisions. CEO and operational...

Yesterday I presented at the Israeli BI User Group at Microsoft Headquarters in Raanana. I gave a presentation on the Data Profiling Task in SSIS and how to dynamically configure it and use it to be a part of your ETL workflow logic. I hope the crowd enjoyed it and that I was able to add value to at least some of the attendants. Meir Dudai from “ Valinor ” also gave a presentation about SQL Azure and the Cloud Computing concepts. Cloud computing is definitely one of the coolest buzzwords at the moment...

שלום לכולם, אני רוצה לנצל את ההזדמנות ולהזמין אתכם למפגש ה -11 של קהילת ה – BI. המפגש יתקיים בתאריך ה – 24/2/2010 בשעה 17:30. כתובת: משרדי מיקרוסופט, הפנינה 4 רעננה. חנייה בחניון האורחים של מיקרוסופט. בתוכנית: 17:30 – 17:45 התכנסות 17:45 – 19:15 החיפזון הוא מהענן – מה אנחנו באמת יכולים לעשות עם מחשוב ענן לסביבת ה-SQL Server ? – מרצה: מאיר דודאי 19:15 – 19:30 הפסקה וכיבוד קל 19:30 – 20:45 הכרות עם ה – Data Profiling Task ב-SSIS: שימושים בסיסיים וישומים מתקדמים בסביבת DWH. – מרצה: יניב מור על המרצים...

One of the data flow destination objects in SSIS is the Flat File destination object. You use this destination object when you export data from a source (SQL Server, Oracle, or anything else for that matter) to a flat file. This can come handy when you maintain an Operational Data Store (ODS) in a Data Warehouse environment and you need to store data in text files before loading it to the Data Warehouse database for example or when you need to distribute a segment of data to the outside world in...

I’m using SSIS for several years now, and I want to shortly cover an SSIS feature which last week help me a lot: using checkpoints in order to recover failed packages. I’m currently developing an ETL solution which requires the import and export of data in and out of a production system on a daily basis, and it is very important to ensure the process only touches the system when required and does not impact on the system performance (or, should I say, impact the least). What I actually need is to...

Technorati Tags: SSIS , Data Flow Task I came across a BOL topic discussing SSIS data flow optimization techniques . For the OLE-DB source component there is a recommendation to use a SELECT statement instead of the "Table or View" access mode. For the sake of clarity, when you use the "Table or View" access method, you get to choose a specific table or view from the database you have designated as your source database, in a drop-down list. When you use the "SQL Command"...