Running a Query Using a Text File for Input

Question

Running a Query Using a Text File for Input

Viewing 4 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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 · Answer 4

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.