I have a tilde seperated file, any thoughts on how to load this into SQL server? Thanks in advance!

Specify tilde as the text qualifier in the flat file connection. Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

Peace out, In your connection manager editor you have to mention the text qualifier. Thanks Manish Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Try this: Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com