Nothing in the forum thus far equates to my problem. I am simply using SSIS 2008 R2 to query Active Directory and dump the Attribute values into a database (or text file). I receive the above error (post title) and am at a loss as how to proceed further. Any help or suggestions would be greatly appreciated. Jon

I'm not familiar with that type of source, but is it possible to to use a CAST function to change the data type of that column?James Beresford @ www.bimonkey.com SSIS / MSBI Consultant in Sydney, Australia SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex

That error message isn't too helpful - but i'm assuming that the source is the error here - so it is either a) not connecting or b) getting data in an unexpected format. What source are you using? Can you manually preview the data? Are there any more error messages?James Beresford @ www.bimonkey.com SSIS / MSBI Consultant in Sydney, Australia SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex

Hello James, I totally agree as to the error message so I'll give as much as I can. When I enter the SQL Code in my Connection Manager (using the ADO Net Directory Services Provider) and select Preview I get the following warnings. The component reported the following warnings: Warning at {C33E3A1E-0B5D-4FC2-9666-D928CA4AC23D} [ADO NET Source [1]]: The data type "System.Object" found on column "distinguishedName" is not supported for the component "ADO NET Source" (1). This column will be converted to DT_NTEXT. When I acknowledge the warning the preview displays my data (desired/expected result). However, when I wire the connection up to dump the information to a flat file or database the package errors out with the following package validation error: ------------------------------ Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at Data Flow Task [Flat File Destination [70]]: The data type for "input column "distinguishedName" (85)" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component. Error at Data Flow Task [SSIS.Pipeline]: "component "Flat File Destination" (70)" failed validation and returned validation status "VS_ISBROKEN". Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration) I am totally at a loss. I even tried SSIS 2005 using a Data Reader source but unfortunately it will only retrieve 1000 rows. I would use this but do not know where/how to set the command objects page size property. (In my old DTS script I used objCommand.Properties("Page Size") = 10000.) If this additional information is helpful to your assistance in resolving this issue I would greatly appreciate it. Jon