loading 40 MB SQL script

#1

I have a 40MB SQL script that I'd like to load into a DB using DTS. Can
someone step me through setting this up in DTS designer? I believe I need to
define the dynamic prooperties, point to the scripts location, etc. Any help
will be greatly appreciated.

#2

to clarify, the 40MB file has INSERT INTO statements that loads data in 15
tables....is creating a SQL task to run xp_cmdshell osql statement the only
way to load these tables?

"SQLCat" wrote:

Quote:

I have a 40MB SQL script that I'd like to load into a DB using DTS. Can
someone step me through setting this up in DTS designer? I believe I need to
define the dynamic prooperties, point to the scripts location, etc. Any help
will be greatly appreciated.

#3

I went ahead and did a BULK INSERT task and loaded the contents of file.sql
containing the INSERT INTO statements for 15 tables into a staging table.
Now, the staging table - col01 has all the INSERT INTO statements. How do I
get from the staging table and into the 15 tables?

"SQLCat" wrote:

Quote:

to clarify, the 40MB file has INSERT INTO statements that loads data in 15
tables....is creating a SQL task to run xp_cmdshell osql statement the only
way to load these tables?

"SQLCat" wrote:

I have a 40MB SQL script that I'd like to load into a DB using DTS. Can
someone step me through setting this up in DTS designer? I believe I need to
define the dynamic prooperties, point to the scripts location, etc. Any help
will be greatly appreciated.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

loading 40 MB SQL script

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

loading 40 MB SQL script - 03-24-2006 , 12:45 PM

RE: loading 40 MB SQL script - 03-26-2006 , 07:08 PM

RE: loading 40 MB SQL script - 03-27-2006 , 11:02 AM