Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Running a Query Using a Text File for Input Expand / Collapse
Author
Message
Posted Friday, January 18, 2008 10:57 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 6:06 PM
Points: 35,218, Visits: 31,678
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #445035
Posted Friday, January 18, 2008 1:26 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:10 PM
Points: 49, Visits: 279
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
Post #445119
Posted Tuesday, March 4, 2008 2:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 12, 2008 2:09 PM
Points: 1, Visits: 6
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
Post #464094
Posted Wednesday, June 24, 2009 5:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 7, 2009 6:38 AM
Points: 19, Visits: 35
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.
Post #741448
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse