I have the same issue.

my 'unc' folder automatically set security without fullcontrol for SQLSERVERAGENT when I setup the publictions. I had manully granted full control to SQLSERVERAGENT. (xp_cmdshell enabled....

Thank you for helping me on this issue.

I set a trace on SQL Profiler for EventClass of 'Uer Error Messate' and 'Audit Login Failed'. Got many error messages about 'changed...

Hi randy.jaye,

Thank you so much!!! It works just like your said.

Best Regards,

Wei

Open the Flat File Connection Manager Editor, in the Advanced section, rename each column, select DateType and OutputColumnWidth according you destination table

Over all, it should looks like:

column ...

Hi All,

Thank you for all your help!

VIEW is good solution for me.

Thanks again.

Hi All,

Thank you for taking a look, and willing to help me.

I tried looking for something related...

And I tried run an individule task (by disabling all other taskes, if there...

Hi All,

thank you for all your replies and examinations. For now, I'll try to use an IDENTITY column to get closer to a guaranteed order.

All your posts are good points...

Hi Ron & Paul,

Thank you for your posts and queries. That would help. Particularly, the 'Records inserted into a HEAP will come back in insertion order...' lets me understand...

Hi Jeff & Ron,

Thanks again!

I'm working on updating part of an old project. Let the output table sorted without the use of 'order by' is the requirement. (If...

Hi Jeff & Ron, Thank you for your helps!

HI All,

Thank you for all of your helps and replies.

Hi Paul, your reply (REAL 4 bytes. 3.4E+38 precision = 7) helps me figure out my problems.

Again, thank you for all...

Hi Dixie Flatline, lmu92:

Thank you for all of you!!!

HI lmu92,

Thank you so much for your help.

I tried, seems still not working for me.

If I change the destination data type to either money, decimal, or number, will working...

If try something simple, it might make things easier and less errors,

If you could return the CHECKINTIME, just go the the Text Box Properties, in the Number/Custom section, using Custom...

Just pass the Textbox(the column name resides on) value to the subreport parameter.