Answers to Advanced SSIS Interview Question

Who is online?  0 guests and 0 members
Home  »  Blogs  »  DevinKnight  »  Answers to Advanced SSIS Interview Question
 
0
/5
Avg: 0/5: (0 votes)

Comments (7)

Anonymous
Anonymous said:
Very very useful.Thanks.Plzput more questions & answers
4/16/2010
 · 
 
by
vasireddybharath

very nice qa....

 

thanks

bharath reddy vasireddy

9/7/2010
 · 
 
by
pkumar3
pkumar3 said:

Very useful post.

 

Thanks Devin. Please put more.

 

 

Thanka

Pradeep

4/16/2011
 · 
 
by
agastis
agastis said:

Hi,

Just to say some thing regarding question "Would you consider it a best practice to create a configuration file for each connection manager or one for the entire package? "

I will say, we should use only one file, because it will be easy to manage. Secondly, if there are variables which are not common in two packages, you can still put all the variables in one file.

So file will contain Common Variables of 1st and 2nd Package + Uncommon Variables of 1st Package + Uncommon Variables of 2nd Package. And it works

 

6/23/2011
 · 
 
by
agastis
agastis said:

regarding "how checkpoints work in a package."

We shouldnt have two or more seperate source to target mapping in one data flow task. Otherwise whole idea of check points will useless.

6/23/2011
 · 
 · dixitmca likes this.
 
by
leorajj
leorajj said:
For point #1, we can use single config file with all connection managers used in multiple packages. But we need set the property SuppressConfigurationsWarning = True.
4/9/2012
 · 
 · dixitmca likes this.
 
by
upendra478
upendra478 said:
really nice questions covered...thanks please add some more if you can?
7/23/2012
 · 
 
by
Blogs RSS Feed

DevinKnight's latest blog posts

Blogs RSS Feed

Latest community blog posts