Viewing 15 posts - 8,641 through 8,655 (of 11,676 total)
What is the warning message?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 4:02 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 3:41 am
Jeff Moden (12/4/2011)
deepakagarwalathome (12/4/2011)
I have never worked with SSIS but I need to work with it now!
If expert knowledge of SSIS were gasoline, I wouldn't have enough to drive a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 3:36 am
Hmmm, at first sight that error has not much to do with checkpoints.
How do you populate the CustomerID variable?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 3:35 am
Luckily, this is very easy in SSIS (maybe easier than in TSQL? :-P) using a very will hidden property:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 2:17 am
Is it possible to give sample input and desired output?
Your explanation is not entirely clear.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 2:12 am
What is the error that you get?
Wise suggestion: do not use checkpoints. They only bring pain and misery 🙂
Design your package in a way that you can restart it without...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 2:11 am
The JurisID column, is that one already calculated or do you do it at the same time?
Why don't you take the current value of the JurisID column, instead of the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 2:09 am
Nice question. Always good to freshen up XML a bit, as I almost never use it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 1:36 am
Nice question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 1:28 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 1:15 am
SELECT F1 AS MyColumn FROM [Sheet1$]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2011 at 11:35 pm
SSIS could be giving troubles because of the length of the text. (there is a 4000 character limit, but I thought this was only in expressions)
I would do this in...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 29, 2011 at 3:44 am
Nic-306421 (11/29/2011)
I've spent a few hours, before I noticed the bug.
It may just be me, but I wouldn't class this a bug...
It's not just you 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 29, 2011 at 3:08 am
Try adding SET NOCOUNT ON at the beginning, as you have multiple SELECT statements in your query, albeit that only one returns data.
If you execute this in SSMS, what do...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 29, 2011 at 12:49 am
Viewing 15 posts - 8,641 through 8,655 (of 11,676 total)