qew420 (11/15/2010)
Hi,(Step I) I'm building a Package where I need to run Query to update a table say "mytable1"
Mytable is a tmp table
You're already in trouble. SSIS should not be working with #tmp tables outside of a *single* Execute T-SQL object. It does not guarantee a consistent batch.
(Step 2) then I need to run a store procedure which will update certain records in "mytable"
Using a staging table, instead of a #tmp, this will be easy.
(Step 3) : Send the data to network drive as a text file
You'd use the updated data and then ship it to a text file that you could adjust as a variable in scripts as to the exact name/location if you like.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA