Viewing 15 posts - 796 through 810 (of 11,678 total)
You can send emails in a stored procedure by using sp_send_dbmail.
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...
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....
April 8, 2015 at 1:12 am
Nice question, but a bit of an oversight on the tmp schema.
April 8, 2015 at 1:09 am
Rune Bivrin (4/7/2015)
The FIRSTROW attribute is not...
April 7, 2015 at 2:01 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...
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)
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...
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).
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?
April 4, 2015 at 4:29 am
tooba111 (4/3/2015)
One more quick question, do I have to change on my local...
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...
April 3, 2015 at 11:29 am
Viewing 15 posts - 796 through 810 (of 11,678 total)