Using Excel 2007 files as a Source in SSIS 2005

Thanks to “jaegd” for his post here: http://forums.microsoft.com/… on how to accomplish this. Below please find some more details along w/ a example which can be downloaded here (ssis-2005-excel-2007-source-example). Steps Create new OLEDB Connection by right clicking on the Connection Manager tray Chose any valid type or value for the connection and click okay Rename the […]

Excel Tip: Identifying the max length of values in a column

Sometimes files are received such as client feeds that contain values in columns that exceed the maximum number of characters allowed in the destination database. When these records are imported an error occurs when trying to fit this value into the column with the character limitation. In these cases it is helpful to have a […]

1 13 14 15