Articles by Rajesh Manjarekar (Tip/Tricks: 3)

No articles have been posted.

No blogs have been submitted.

Database Development
SQL Server	SSIS: Archive or Copy Files using dynamically specifying FileSpec file types for File Enumerator in Foreach loop [Tip/Trick] 28 Dec 2012 Updated: 24 Jan 2013 Rating: 4.00/5 Votes: 4 Popularity: 2.41 Licence: CPOL Views: 43,491 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. How do I set FileSpec dynamically for looping files in a foreach loop container?
	SQL Change Data Capture (CDC) table not working after adding new columns to the source table and Using CDC with a frequently changing schema [Tip/Trick] 13 Mar 2015 Updated: 13 Mar 2015 Rating: 2.75/5 Votes: 4 Popularity: 1.66 Licence: CPOL Views: 19,530 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. When CDC is turned ON against a table and the underlying table schema changes, such as adding/removing a column, changing datatype etc
	SSIS 2008 drop last data row from .csv or .txt file while import data using SSIS DataFlow Task.. [Tip/Trick] 19 Feb 2013 Updated: 19 Feb 2013 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 19,171 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. I found out that a possible cause is the difference between the SSIS 32 bits and 64 bits environment