title: Columns with same name in query output but not allowed in SSIS query output?
body: <p>In reference to my last question that was answered <a href="http://tinyurl.com/o7srwnd" rel="nofollow">here</a>, when I run the query in QA, it gives me the output with the same column name in two separate columns just fine.  However, when I try to create a package with the query in it, I can't create it because it gives an error saying </p>
  
  <blockquote>
    <p>Error 0xc0207015: Source - Query <a href="http://tinyurl.com/o7srwnd" rel="nofollow">1</a>: There is more than one data
    source column with the name 'national_provider_id'. The data source
    column names must be unique.</p>
  </blockquote>
  
  <p>So how do I go about fixing this so it won't give me this error yet give me the results I need for the output file?</p>