Microsoft Blog Images
Browse by Tags
Search this blog
Search all blogs
RSS for posts
Tagged Content List
Synchronize two tables using SQL Server Integration Services (SSIS)-Part II of II
Please, refer to this link for the first part of this post. In this part we will start with the same sample scenario where “table A” in “database A” needs to be synchronized with “table B” in data warehouse “database B”. During the first part of this post we discussed how to deal with new records in...
8 Dec 2010
Synchronize two tables using SQL Server Integration Services (SSIS)–Part I of II
There are situations where a SQL Server DBA needs to keep two different tables in sync. Usually, the DBA needs to keep a copy of a table in a in a data warehouse repository that is used as a solution for archiving and/or reporting. SQL Server provides a robust method for keeping data synchronized across...
7 Dec 2010
“Cannot open the datafile <path_to_file>” Error Accessing a Flat File in SSIS Using a Proxy Account
I did find this error on a Windows Server 2008 and SQL Server 2008 installation but as you will see the error is not tied to an specific SQL Server or Windows version. In this case my customer was trying to run a SQL Server Agent Job with 17 different steps. These steps were of different types like running...
28 Nov 2010
SSIS error DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER when connecting to Oracle data source
This time I want to discuss a support case that took me some days to get fixed. This case may be of interest for anyone having problems connecting a SQL Server installation to an Oracle data source using SQL Server Integration Services (SSIS). In this case my customer was trying to connect to an Oracle...
12 Feb 2008
Page 1 of 1 (4 items)
© 2014 Microsoft Corporation.
Privacy & Cookies