No Available i/p Columns

• Minnesota - Viking

  Hall of Fame

  Points: 3469

  More actions

  February 1, 2011 at 4:18 pm

  #231450

  My select statement spans across multiple DBs

  Step1: Selects data from DB1 joining few tables and creates a Global temp table ##Temp1

  Step2: Few tables in DB2 are joined along with ##Temp1 to create req result of 1000 rows.

  I need to create a table in a different DB on a different SQL server

  Options I tried

  1. Import Export Wizard -- Repeatedly fails (may be since my target is a temp Table, is it so ?)

  2. Linked Server (I dont have permision )

  3. Cant create a Perm Table to try with imp Exp Wizard..

  4. SSIS (Source as my Original Server, Target as the server on which i need to create table)

  When i put the SQL in it shows perfect preview, but when i try to map it ..phew.....

  😛 it asks me to get lost , says No available i/p columns

  YES i did go through this article .

  But I dont have a PROC so what do i do ?

  [font="Verdana"]
  Today is the tomorrow you worried about yesterday:-)[/font]

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  February 2, 2011 at 2:29 am

  #1281296

  What is the exact error that you get?

  Is it possible to show us the source query that you have written?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP