DSXchange

any special characters in your password??

[quote="kduke"]Extract as varchar and use a SQL Server function to convert back and forth from varchar to timestamp when reading and writing to the database. ...[/quote]

thanks for the reply but it does not work..

Dear Gurus, here is my problem. i am trying to extract the data from sqlserver2005 table. the field is datetime field (ex: 2009-01-22 21:00:55. 330 ). i imported the metadata and the datatype is timestamp(23,3). when i use view data ( using ODBC Eneterprise stage) the above time is showing as 2009-0...

on the outputside of aggregator stage set the preserve partioning to "CLEAR"

the aggregator not connected to any stages downstream???

set "CLEAR" to stage downstream and see

select "CLEAR" preserve partioning falg upstream...

any warnings in the log???

[quote="tatikramos"]one per column.[/quote]

check the metadata for all the inputs to the FUNNEL stage.
they should have same number of colums/column names and metadata as well.

check the setting in the format tab to the same as in the file

yes

Actually there is no transformation. It is almost like filtering out few different columns everyday.[/quote]

then you should be good mentioning the layout as schema file in both input/output..

convert the decimals to varchar before writing to the file
and mention some null field value in the format page of the sequentail file so that the null fields will be filled with the mentioned value...

you can mention schema of the input/output file dynamically in a sequentail file stage

[quote="krishna81"]No, I did not moved .o file to any where.but my make file copying file to prior directory.[/quote]

did you compile with the same compiler options as in the project settings??