joelwenzel
Programmer
- Jun 28, 2002
- 448
How long can a TSQL script file be?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Are there limits to the length of DTS TSQL script files? 1
- Thread starter joelwenzel
- Start date
- Status
-
1
- #2
mrdenny
Programmer
- May 27, 2002
- 11,595
I think the limit is 64k per batch. If you need more than that you can increase the number of batches by putting GO statments within the script. This will require you to redefine all variables and repopulate them with data.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
(Not quite so old any more.)
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
(Not quite so old any more.)
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question