<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 Integration Services
»
SSIS Package Question
SSIS Package Question
Rate Topic
Display Mode
Topic Options
Author
Message
qew420
qew420
Posted Monday, November 15, 2010 3:17 PM
SSC Rookie
Group: General Forum Members
Last Login: Yesterday @ 8:46 AM
Points: 40,
Visits: 433
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
(Step 2) then I need to run a store procedure which will update certain records in "mytable"
(Step 3) : Send the data to network drive as a text file
Is it possible to design all this in SSIS package ? (I know yes)
I'm able to design Step I by Datasource
then I need to run store procedure which depends on the sucess of Step 1- how to do this step? because I still have to create the text file which is step3
Please let me know ASAP, thanks
Post #1021125
Evil Kraig F
Evil Kraig F
Posted Monday, November 15, 2010 3:22 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:03 PM
Points: 5,658,
Visits: 6,099
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.
- Craig Farrell
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
|
Forum Netiquette
For index/tuning help, follow these directions.
|
Tally Tables
Twitter: @AnyWayDBA
Post #1021132
Raunak Jhawar
Raunak Jhawar
Posted Tuesday, November 16, 2010 5:42 AM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946,
Visits: 1,739
Craig has answered you question completely. As a matter of design...create table --> Stage Data-->Data Transformations-->Truncate Table
Regards/Raunak
Now a member of Linkedin
Please visit the all new
Performance Point Forum
Please visit the all new
Data Mining and Business Analytics Forum
Post #1021407
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, November 16, 2010 10:45 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364,
Visits: 6,462
Craig Farrell (11/15/2010)
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.
If you set the property
RetainSameConnection
to True of the corresponding connection manager, there should be no problem. (if all task/components that use the temp table have the same connection manager of course)
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1021665
Evil Kraig F
Evil Kraig F
Posted Tuesday, November 16, 2010 12:11 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:03 PM
Points: 5,658,
Visits: 6,099
da-zero (11/16/2010)
Craig Farrell (11/15/2010)
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.
If you set the property
RetainSameConnection
to True of the corresponding connection manager, there should be no problem. (if all task/components that use the temp table have the same connection manager of course)
Whoopsies! Thanks for that correction Da-Zero.
- Craig Farrell
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
|
Forum Netiquette
For index/tuning help, follow these directions.
|
Tally Tables
Twitter: @AnyWayDBA
Post #1021730
qew420
qew420
Posted Thursday, November 18, 2010 11:25 AM
SSC Rookie
Group: General Forum Members
Last Login: Yesterday @ 8:46 AM
Points: 40,
Visits: 433
thanks all
I'll try out and will update you all
Post #1023076
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
