THanks a Lot for replying and giving me an idea.

Can any one tell me if i want to run the Perfmon counters,

how much Time i have run to verfiy...

Thanks reply,

I had specified the length for each column and now it showing correctly.

But running the package it not uploading the data to table.Bit package executed successfully.

can you plz suggest

Thanks

Lenth has been specifed but still it is showing as

i said before.

Thanks for reply,

yes am using RAgged right

but i did not defined the length for each column.do i need to specify it any where.

could you Please let me know...

Thanks for reply:

ON general tab:

code page:1252(ANSI-LAtin I)

Format :RAgged right

header row delimiter :{CR}-{LF}

Note: when seleted columns tab i am getting a pop widow with message

INput column are ignored because...

HI,

CAN ANY ONECHELP ME HERE PLEASE

Many thanks.

As you said i have checked and the flatfile was corrupted due to which i am not able see the data present in the flat file.

We have replaced...

I am using flatfile an oledb components.

we are loading the data form flatfile to table.

We are unable to see the flatfile (source file) data as data is displaying...

HI ,

When i Add a data viewer to the dataflow path that goes into My conversion transformation. I could not see any data in dataviewer window when ran...

yes ,

i have changed that too.

Now it showing as

advance editor for ole db destionation -----input.output tab---external columns

-----data type :dt_str

lenght- 255

Thanks...

Hi

i have changed the cloum len to varchar(255) on the table and i have exctued the job but still getting the same error.

Message

SQLagent. Microsoft (R) SQL Server Execute Package...

Many thanks for reply,

Length of cloumn2 in flatfile is 255

Manny thanks..

1)I could see in the database table the .

column size is char(1)--------

2)advance editor for ole db destionation -----input.output tab---external columns

-----data type :dt_str

...

Thanks reply,

Can you please clarify were to check the space of the column and were i have to incease the column.

we are using package to load the data form flatfile...

THanks,

i hvae converted the data types and further ran the pacakage and got below error.

[Flat File Source [1]] Error: Data conversion failed.

The data conversion for column "Col002" returned...