troubleshooting Question

SSIS

Avatar of spirose
spirose asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
16 Comments1 Solution348 ViewsLast Modified:
I need to do data transfer text file to SQL server. However, the text file is a log file that is generated from running the command robocopy.exe on the command prompt.
The text file log.txt looks like the file I attached here as an example. I cannot send the exact log file from my machine due to security reasons.

 This is the strange part: when I try to import the file log.txt  into SQL Server, there are unicode characters(square boxes) that appear randomly in the Columns tab of the Flat File Source. They do not appear on the log.txt itself BUT only at the time of data flow transformation. Can anyone please help?
log.txt
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 16 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros