bryan99y
SSCarpal Tunnel
Points: 4672
More actions
May 9, 2002 at 7:58 am
#151692
I have a script that is about 11000 characters long that I need to run nightly.
DTS does not work with this.
Jobs only have a 3300 character limit.
How can I do this ?
Tom Goltl
SSCertifiable
Points: 5815
May 9, 2002 at 9:25 am
#428800
Is it tsql code. If so, you might be able to turn it into a stored procedure and then execute the stored proc through your dts.
Antares686
SSC Guru
Points: 125444
May 9, 2002 at 9:28 am
#428801
If it is an ActiveScript you should be able to invoke from inside DTS or even a Job use Operating System Command.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply