I have a problem with DataReaderSource.I'm trying to get data from Notes table. I created a Connection manager and the connection was successful. The SQLCommand in "Component properties"tab is a simple "select * from <table_name>". When I switch to the "Column mappings" tab, only the first column from the table is displayed. Pressing the "Reftesh" button resulst in the following error:Error at Data Flow Task {DTS.Pipeline]: The "output column <column_name> has a length that is not valid. The length must be between 0 and 4000.When I go to the "Input and Output Properties" tab, the DataType for the output column is not populated and the error message "Error in Data Flow Task [DTS.Pipeline]: The output column <column_name> had aninvalid datatype (0) set."The DataType property is not populated at all. Changing the data type to DT_STR results in error:"Property value is not valid". Details: Error at Data Flow Task [DataReader Source]: The data type of output columns on the component "DataReader Source" cannot be changed". I read on a previous post to explicitly convert field , and tried to explicitly covnert the dataype on the fieldin my query (ex. select convert(varchar(50) from fieldname) It then gives foll err: ERROR [42000] [Lotus][ODBC Lotus Notes]Incorect syntax near ','[Lotus][ODBC Lotus Notes]Name, constant or expression expected. Any idea on how to resolve this?

What is the datatype in the source and destination you had set. Are you sure that your output column field size was valid ?

The datatype on the notes view is "TEXT" Len =13 bytes. Destn is sql tbl with datatype varchar (255). So When I go to the "Input and Output Properties" tab, the DataType for the output column is not populated and the error message "Error in Data Flow Task [DTS.Pipeline]: The output column <column_name> had aninvalid datatype (0) set."The DataType property is not populated at all. So under Datreader output->output columns->I changed the data type to UNICODE string (DTW_WTSR) and len =254. Then when I go to Data Readet error output-> and change output column there to UNICODE string (DTW_WTSR), thats when it gives this err below."Property value is not valid". Details: Error at Data Flow Task [DataReader Source]: The data type of output columns on the component "DataReader Source" cannot be changed".

What you can do is ( as always check you have a backup) set up a description ( something you can find ) lllkkkppp change the validate external to NO ensure you use a select field,field..... not Select * ... save the GUI ( at this time the only think that is wrong is the length) open the code It may look big and complex. find lllkkkppp change the field manually in the code just along from the description (if this bit of XML is not something you are comfortable with leave it)Alun Davies