Viewing 15 posts - 796 through 810 (of 11,676 total)
You can send emails in a stored procedure by using sp_send_dbmail.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 8, 2015 at 1:16 am
You can either dump the data into a staging table and then check the validity of the data.
Or you implement a blocking script transformation where you load all records, check...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 8, 2015 at 1:14 am
Use a for each loop with a wildcard, store the filename into a variable and use a flat file connection manager with an expression on the filename using that variable....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 8, 2015 at 1:12 am
Nice question, but a bit of an oversight on the tmp schema.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 8, 2015 at 1:09 am
Check msdb.dbo.sysjobs.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 7, 2015 at 7:07 am
Rune Bivrin (4/7/2015)
The FIRSTROW attribute is not...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 7, 2015 at 2:01 am
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 7, 2015 at 1:11 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
April 7, 2015 at 12:49 am
dwain.c (4/6/2015)
And here I thought Easter was about putting your eggs in one basket.
Very true. Easter is according to some historians actually a holiday about spring and fertility. And the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 7, 2015 at 12:45 am
Kathi Kellenberger (4/4/2015)
There are a few things, such as creating a custom window aggregate function.
With CLR?
Kathi Kellenberger (4/4/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 7, 2015 at 12:41 am
coool_sweet (4/4/2015)
hieven if i calculate in my sql script it will come as a column
i need last row only sum in my excel sheet
Can you give some sample data and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 7, 2015 at 12:37 am
Yes, that seems about right.
If you run the package in 64-bit, you need to set the registry setting in the normal path as well (without the wow6432node).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 7, 2015 at 12:36 am
Kathi Kellenberger (4/3/2015)
Be sure to check out my new book as well!
I might. Is there anything in there that is not in Itzik's book?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2015 at 4:29 am
tooba111 (4/3/2015)
One more quick question, do I have to change on my local...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2015 at 4:28 am
Alan.B (4/3/2015)
I actually came into the "Anything that is NOT about SQL!" forum to ask this question but think it's appropriate here....How do you report spam?
At the top right of...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 3, 2015 at 11:29 am
Viewing 15 posts - 796 through 810 (of 11,676 total)