Running a Query Using a Text File for Input

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  January 18, 2008 at 10:57 am

  #769796

  Very good comprehensive article. I just don't understand why a simple BULK INSERT couldn't be used to populate a temp table...

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• jhasbufuidh

  Ten Centuries

  Points: 1002

  More actions

  January 18, 2008 at 1:26 pm

  #769867

  mojo (1/14/2008)

  ---

  Does anyone know the Microsoft.Jet.OLEDB.4.0 engine works with 64-bit SQL 2005 server?

  See this

  http://sqlblogcasts.com/blogs/simons/archive/2006/01/05/SSIS-64-Bit_2C00_-Excel-and-Access.aspx

  It has a link to another post where more details are discussed.

  BI Guy

• barbichaf2000

  Grasshopper

  Points: 13

  More actions

  March 4, 2008 at 2:29 pm

  #785216

  Hi

  I am new to SQL servers and I would like to know how does one script a database and what is scripting. I know how to use the copy tables but I don't want to copy tables only, I would like to copy the entire database.

  Thank You

• Jay Tucker

  Right there with Babe

  Points: 719

  More actions

  June 24, 2009 at 5:34 pm

  #1014995

  Anatol,

  I used your method to prepare text input to use in a WHERE clause with an IN ( ) list. If I have a lot more data to input, I would want to use a file for input, but I don't know how to actually use the file that is created in your example. Please explain.

  Thanks.