|
Home > Archive > MS SQL Server DTS > March 2006 > loading 40 MB SQL script
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
loading 40 MB SQL script
|
|
| SQLCat 2006-03-24, 8:25 pm |
| 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.
| |
| SQLCat 2006-03-26, 8:27 pm |
| 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.
| |
| SQLCat 2006-03-27, 11:31 am |
| 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:
[color=darkred]
> 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:
>
|
|
|
|
|