I already set the delay validation to be true. I just figured out that " validate metadata" property on excel source =false. In this case it will not throw error....

Also , since you worked on Excel source. I have a question , my excel source always looks for test files which i pointed in excl connection manager at...

Please see the pacakge hierachy. Let me know if i can cahnge anything with copying? As the move file should be locked but copying of file should work fine. I...

In excel connection manager : Retain same connection manager : true.

Mine are xlsb files and they require retain same connection , as i am trying to load 2 xlsb files in foreach loop ...each file load process has sequence...

It runs fine with all the SQL agent owner when i diable to task which copies the file to a archive folder. This can be done in Dev enviornment...

Hi Phil,

Thank you for your quick reply. I tried the sql agent permissions and it ran perfectly. I was banging my head from morning to fix this issue.

Thanks Phil for replying. It works.

Did you find any solution, as i am running into same error.

Can you be more precise...i did not know exactly where you changed?

I tried the same...but no use. it still appends 0's for hh:mm:ss. 2016-07-18 00:00:00

I don't need 0's appended at last.

here is the ccolumn date output in text file :2016-07-05 02:38:52.1900000 +00:00

The column from table is of type datetimeoffset

truncation of timezone apprears in tsql but not when loaded to...

I used Convert(varchar(19) , [Date] ,120 )

still i get the same in text file with datetimeoffset

My query column coversion to varchar :

CONVERT(varchar(19),[Date],0) =2016-07-05 02:38:52

Before conversion date column value in table: 2016-07-05 02:38:52.1900000 -04:00

Since there is change in flat file columns, i changed datatype on...

I wanted to delete this post in this section but could not. So, cross posted in correct section.