Browse Site by Tags

Showing related tags and posts accross the entire site.

How to Insert or Update records in SSIS DataFlow

If you import Data from a specified Source periodically in an Integration Service Project and you need to update existing data in the SQL Destination the best workaround for this is as following: First define a Source in the data flow e.g. Ole DB Source, make sure that your Columns does not contain NULL...

Posted to Nadine's Posts (Weblog) by Nadine Storandt on 12-07-2006
Error: There is already an open DataReader associated with this Command which must be closed first

If you receive the following error message There is already an open DataReader associated with this Command which must be closed first and you are sure that all dataReader are closed the following workaround can help you. The MARS default settings has changed at release RC1, so multiple Result Sets are...

Posted to Nadine's Posts (Weblog) by Nadine Storandt on 12-07-2006
SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Hi, I'm just getting confused today, because I tried to import Data from a Excel Source, but one column contains only NULL Values, but in the Excel Source there are a few entries for this column. So the problem was SSIS Excel Source only look at the first 8 Rows if they contain the same value SSIS...

Posted to Nadine's Posts (Weblog) by Nadine Storandt on 12-05-2006

Page 1 of 1 (3 items)