<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
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Andy Leonard
»
The SSIS Data Pump - Step 2 of the Stairway...
57 posts, Page 2 of 6
««
1
2
3
4
5
»
»»
The SSIS Data Pump - Step 2 of the Stairway to Integration Services
Rate Topic
Display Mode
Topic Options
Author
Message
Jamie Thomson
Jamie Thomson
Posted Wednesday, April 06, 2011 7:30 AM
SSC Eights!
Group: General Forum Members
Last Login: Yesterday @ 1:03 AM
Points: 877,
Visits: 185
Andy,
Why have you referred to it as a Data Pump?
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Post #1089266
johnbrown105 56149
johnbrown105 56149
Posted Wednesday, April 06, 2011 8:08 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:07 PM
Points: 10,
Visits: 584
I have not actually read the article yet. I'm just asking about these paragraphs that seem to be a little jumbled.
First, SSIS will never store or save decrypted password fields. If your connection requires a password, and you check the Save My Password (or Save Password, depending on the version of SSIS you’re running) checkbox, and your SSIS package is encrypted.
SSIS will store your password internally and encrypted if you use Windows Authentication, the Connection Manager will connect to the database in the context of the user who executes the package.
I think that you really meant to say:
First, SSIS will never store or save decrypted password fields. If your connection requires a password, and you check the Save My Password (or Save Password, depending on the version of SSIS you’re running) checkbox, and your SSIS package is encrypted, then SSIS will store your password internally and encrypted. If you use Windows Authentication, the Connection Manager will connect to the database in the context of the user who executes the package.
Post #1089291
Andy Leonard
Andy Leonard
Posted Wednesday, April 06, 2011 10:23 AM
Old Hand
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:53 PM
Points: 375,
Visits: 947
Jamie,
Uh oh. What's wrong with referring to the Data Flow Task as a data pump?
John,
Yep - I missed that. You worded it correctly.
:{>
Andy Leonard
CSO, Linchpin People
Follow me on Twitter:
@AndyLeonard
Post #1089389
Jamie Thomson
Jamie Thomson
Posted Wednesday, April 06, 2011 10:31 AM
SSC Eights!
Group: General Forum Members
Last Login: Yesterday @ 1:03 AM
Points: 877,
Visits: 185
Andy Leonard (4/6/2011)
Jamie,
Uh oh. What's wrong with referring to the Data Flow Task as a data pump?
What other than "that's not what it is called"? Nothing, nothing at all!
Sorry, I'm a bit of a terminology zealot - I just think it could be risky using wrong terms because then people start to misuse them and that's where communication breakdowns begin (I speak as someone that has spent a lot of time on forums trying to understand what people *really* mean)
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Post #1089395
Andy Leonard
Andy Leonard
Posted Wednesday, April 06, 2011 10:41 AM
Old Hand
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:53 PM
Points: 375,
Visits: 947
Thanks Jamie,
I think you're being prudent and that I was sloppy with my terminology. It's ok to make analogies, but it's best to keep them out of the title of a major article. Good point. I will avoid this going forward.
Thanks!
Andy
Andy Leonard
CSO, Linchpin People
Follow me on Twitter:
@AndyLeonard
Post #1089404
lydia.fang
lydia.fang
Posted Wednesday, April 06, 2011 6:07 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, September 11, 2012 3:37 PM
Points: 2,
Visits: 16
great article and easy to follow.. cannot wait to see the next ones. thanks a lot.
Post #1089650
Mr Quillz
Mr Quillz
Posted Friday, April 08, 2011 7:14 AM
Valued Member
Group: General Forum Members
Last Login: Monday, May 20, 2013 4:09 AM
Points: 60,
Visits: 175
Hi Andy,
I wish i had got your article back when I started working with SSIS 2.5 years ago. A great article. It covers great detail and is yet simple for all to understand. I also found myself looking for Step: 3. lol!!! In fact I will spread the word of your work. I'm certain my team member can benefit from your articles.
I'm definitely looking forward to the next installment.
Aquila Hanise
BI Developer
South Africa
Post #1090600
Koen Verbeeck
Koen Verbeeck
Posted Sunday, April 10, 2011 11:56 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378,
Visits: 6,473
Another great article Andy!
I found it very nice that you gave some attention to the layout of the package, as unfortunately, messy control and data flows do appear in books or blog posts.
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 #1091255
h.parajuli
h.parajuli
Posted Saturday, August 06, 2011 8:26 PM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 1:42 PM
Points: 18,
Visits: 32
An Excellent article Andy. I am a beginner of SSIS and this article makes me everything so clear and easy. I am really waiting forward for next articles.
Post #1155626
Eric Hielkens
Eric Hielkens
Posted Saturday, October 08, 2011 3:11 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, June 29, 2012 1:46 AM
Points: 2,
Visits: 41
Fine and professional article, thanks! It has been well written and easy to follow. A great resource for starting out with SSIS.
Post #1187462
« Prev Topic
|
Next Topic »
57 posts, Page 2 of 6
««
1
2
3
4
5
»
»»
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.
