But all the records have been updated...

How do I check ANSI Padding setting in my server? Why it seems working differently on my two tables with same (looks same) records?

I have another table in the same...

Thanks for your hint, that's what I am trying. Can you provide more instruction on SSIS?

I did the following in Access:

I export the table to mdb, I tried to...

I checked char(9), char(10), char(13), none of them exist in my records.

select charindex(char(10), techowner_department) from epm where techowner_department is not null

OK, so it's not OBVIOUS.

Then how do I find out the special characters in my records?

Thanks.

Sorry I don't get you guys. As you can see from my screenshot, it is so OBVIOUS that length should be different for each record.

Here is my screenshot

Thank you.

If I add ID as a primary key field after the table has been automatically created by logparser, and then I tried:

logparser.exe "select c-ip, cs-uri-stem into log from ex070816.log" -i:iisw3c...

There are lots of fields in iislog, "Select * INTO log from iislog" will create those fields + some extra fields for you automatically.

The only problem is when you use...

Before you get into it deeper, I would STRONGLY SUGGEST YOU NOT USING CRYSTAL REPORT.

There are just too many problems with this tool.

Nothing special, just open a cursor and fetch record one by one and insert back to your new table.

I once have the same need, I did it by a cumbersome stored procedure using cursor.

Hold on, new problem::w00t:

When I use "select * INTO log from %1" to insert the logfile into sql table, at first there is no any problem, I got beautiful records....

Thank you. Now I can actually create a task to automate the log import into sql, and in the sql, I can do whatever join I want.