March 4, 2011 at 6:49 am
Phil Parkin (3/4/2011)
Just dive in and keep asking questions and you'll soon gain the requisite experience.
heh...makes me think of that sig (can't remember whose at the moment) "semper in excretia, solum profundum variat"
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 4, 2011 at 6:58 am
jcrawf02 (3/4/2011)
Phil Parkin (3/4/2011)
Just dive in and keep asking questions and you'll soon gain the requisite experience.heh...makes me think of that sig (can't remember whose at the moment) "semper in excretia, solum profundum variat"
So true - plus say it in Latin and it somehow raises the tone.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 4, 2011 at 7:01 am
Don't get discouraged. It shouldn't be a setup problem, unless you're missing a service pack or a hot fix.
Answer my questions above, and let me know what build you're running, and I'll help you narrow down the problem the best I can.
March 4, 2011 at 7:02 am
Phil Parkin (3/4/2011)
jcrawf02 (3/4/2011)
Jeff Moden (3/3/2011)
Heh... or just do it all in T-SQL stored procedures. :-D:-P;-)How do I decide when to use subpackages vs stored procedures vs straight SQL tasks? I would have assumed (had using a sub-package occurred to me) that keeping things within the same package would run smoother than jumping to a different one, but I don't suppose a SQL task would be any different than executing a stored procedure.
Jeff's a T-SQL evangelist who doesn't generally enjoy his exploits with SSIS, so expect a heavy bias in anything you read that's written by him 🙂 Personally, I think he's filled his brain with so much T-SQL it can't accommodate SSIS too 😀
There are no rules about when to use what, unfortunately and there are usually several ways of achieving the same outcome, some more elegant and efficient than others.
There are obvious portability attractions in keeping your package self-contained and that is worth striving for. SP's can improve performance if there is a lot of processing to be done. Sub packages come in useful if something has to be executed repeatedly, under the control of a master package. Just dive in and keep asking questions and you'll soon gain the requisite experience.
It depends. Sometimes you have to test and just see what works best for your situation.
One of my co-workers on another site has starting running into some performance issues.
They will be upgrading to 2008 R2, and part of the migration is to test moving SP functionality into some other SSIS flows.
In particular, some of the SP's are for emulating Change Data Capture.
I'm nowhere near as smart as Jeff with this stuff, and when they had me look at an execution plan, even I had to laugh.
Greg E
March 4, 2011 at 7:14 am
Brandie Tarvin (3/4/2011)
Really? That's odd.What type of objects are you trying to copy? And how are you trying to copy them? Across packages in different solutions or across packages in the same solution?
Yes, I specialize in Odd, gotta play to your strengths.
copying Execute SQL tasks, across packages in the same solution. Running 2008 R2 BIDS, so Visual Studio 9.0.30729.4462 QFE, SSIS Designer 10.50.1600.1
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 4, 2011 at 7:43 am
jcrawf02 (3/4/2011)
Brandie Tarvin (3/4/2011)
Really? That's odd.What type of objects are you trying to copy? And how are you trying to copy them? Across packages in different solutions or across packages in the same solution?
Yes, I specialize in Odd, gotta play to your strengths.
copying Execute SQL tasks, across packages in the same solution. Running 2008 R2 BIDS, so Visual Studio 9.0.30729.4462 QFE, SSIS Designer 10.50.1600.1
Ah. I haven't worked with 2008 R2 BIDS yet. I've got it on my laptop, but I can't play with it until after work.
Copy N Paste works fine in SSIS 2k5, so maybe it's a bug in R2. But I'll check as soon as I get a chance.
Just to verify... You don't have any variables or expressions in these Execute SQL Tasks, do you?
March 4, 2011 at 7:50 am
Brandie Tarvin (3/4/2011)
jcrawf02 (3/4/2011)
copying Execute SQL tasks, across packages in the same solution. Running 2008 R2 BIDS, so Visual Studio 9.0.30729.4462 QFE, SSIS Designer 10.50.1600.1Ah. I haven't worked with 2008 R2 BIDS yet. I've got it on my laptop, but I can't play with it until after work.
Copy N Paste works fine in SSIS 2k5, so maybe it's a bug in R2. But I'll check as soon as I get a chance.
Just to verify... You don't have any variables or expressions in these Execute SQL Tasks, do you?
I have 2008 R2 BIDS (which is actually just 2008 BIDS, no difference).
I can copy paste Execute Package Tasks without a problem. Only the connection manager needs to be refreshed.
My set-up:
Microsoft Visual Studio 2008
Version 9.0.30729.4462 QFE
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 10.50.1600.1
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2011 at 7:53 am
According to this thread, some dll's should be registred to solve the error:
Register the xml parser dlls with the below commands.
regsvr32.exe msxml3.dll
regsvr32.exe msxml6.dll
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2011 at 9:05 am
Brandie Tarvin (3/4/2011)
Just to verify... You don't have any variables or expressions in these Execute SQL Tasks, do you?
Nope. Thanks!
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 4, 2011 at 9:06 am
Koen Verbeeck (3/4/2011)
According to this thread, some dll's should be registred to solve the error:Register the xml parser dlls with the below commands.
regsvr32.exe msxml3.dll
regsvr32.exe msxml6.dll
Thanks Koen, I'll check it out.
Edit: Worked like a charm! Thanks! 😀
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 4, 2011 at 2:45 pm
jcrawf02 (3/4/2011)
Koen Verbeeck (3/4/2011)
According to this thread, some dll's should be registred to solve the error:Register the xml parser dlls with the below commands.
regsvr32.exe msxml3.dll
regsvr32.exe msxml6.dll
Thanks Koen, I'll check it out.
Edit: Worked like a charm! Thanks! 😀
Great! Glad that it all worked out. On to the weekend! 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 11 posts - 16 through 25 (of 25 total)
You must be logged in to reply to this topic. Login to reply