Viewing 15 posts - 1,456 through 1,470 (of 11,676 total)
Is there an error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 5, 2014 at 3:22 am
kapil_kk (11/5/2014)
sorry, posted the wrong desired output..please seet he modified one
You should also provide an explanation of what you are trying to accomplish.
At the top of my head, I can...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 5, 2014 at 3:22 am
Probably something like this:
SELECT Feed = 'A', [No of Records] = COUNT(ID)
FROM TableA
UNION ALL
SELECT Feed = 'B', [No of Records] = COUNT(ID)
FROM TableB
UNION ALL
...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 5, 2014 at 2:58 am
SELECT * FROM Table2 WHERE Status = 'A';
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 5, 2014 at 2:54 am
AWLS = advanced wilderness life support?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 5, 2014 at 1:20 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
November 5, 2014 at 1:09 am
What are the values of those variables?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 5, 2014 at 1:07 am
mario17 (11/4/2014)
Thanks, and then still deploy ?dtexec.exe /F works OK without any deployment.
M
With file system "deployment" you just copy the package to the file location where you want them.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 5, 2014 at 1:05 am
Try converting the project to the package deployment model.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 4, 2014 at 12:48 pm
They are not mutually exclusive.
For example, if you want to restore to a point-in-time after the last back-up, you need to do a tail-log back-up first.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 4, 2014 at 6:49 am
There are no other errors?
There may be error messages posted before this with more information on why the AcquireConnection method call failed
How did you configure the expressions on the Excel...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 4, 2014 at 6:45 am
How did you configure the expressions on the Excel connection manager?
Can you post all messages from the output window?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 4, 2014 at 6:17 am
How did you configure the expressions on the Excel connection manager?
Did you set DelayValidation to true?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 4, 2014 at 6:04 am
santoshkal (11/4/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 4, 2014 at 5:48 am
What are the errors?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 4, 2014 at 5:42 am
Viewing 15 posts - 1,456 through 1,470 (of 11,676 total)