small help in ssis

Question

small help in ssis

Chinna

SSCertifiable

Points: 5408
More actions
August 8, 2008 at 11:01 am

#122847

i have a dts package with 10 stored procs lik e
exec stored proc1
exec stored proc 2
now i need to create one in ssis ...so can i do all th e 10 sp in execute sql task in ssis....as i have a connection for execute sql task in dts i just got this doubt regd this.....
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Sure you can execute multiple statements in an Execute SQL Task. I usually put a GO between them, but you don't have to. The only issue is that if 1 fails you won't know which one caused the failure.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Chinna SSCertifiable Points: 5408 More actions · Answer 2

thanks jack got it .....

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

SrikanthSv Ten Centuries Points: 1197 More actions · Answer 3

use a go

that should help

Regards
Venkat
http://sqlblogging.blogspot.com[/url]

elegantkvc SSCommitted Points: 1910 More actions · Answer 4

hi,

You have to use a go statement with the each set of stored procedures in the SSIS.

Thanks & Regards

vijay