Business Intelligence, Data wharehousing and Microsoft SQL Server services for BI Impelmentation SSIS , SSAS , SSRS
Migrating large amount of data with nvarchar(MAX) in SSIS
Be aware when you deal with the nvarchar(MAX) as a source data for the SSIS OLE data Source as in the large number of data the temp files couldn't be generated so the migration fails. i had a case with 48 columns nvarchar(MAX) with 45000 rows and the migration failed. but converting them to 50 length it worked...!!!
Anonymous comments are disabled