Viewing 15 posts - 5,566 through 5,580 (of 13,879 total)
June 8, 2017 at 12:26 pm
I'm having some problems with a stored procedure which is called every hour...
June 8, 2017 at 9:20 am
June 8, 2017 at 8:35 am
This is a tough requirement, I sympathise.
MERGE JOIN in SSIS is not something I would recommend for such high volumes.
Maybe you could split this into two parts:...
June 8, 2017 at 6:48 am
coool_sweet - Wednesday, June 7, 2017 2:22 PMsorry I m using execute process task but how can I get .gz extension here
I'll...
June 7, 2017 at 3:11 pm
i am using execute sql task to zip my files to .gz extension.
but getting error...
June 7, 2017 at 2:14 pm
It seems that many others have experienced similar issues. One method which appears to have worked for some is using an ODBC connection rather than ADO.NET. Is this a possibility...
June 7, 2017 at 1:10 pm
Anyone in the mood for talking about RAM requirements while remaining tight-lipped about the use of NOLOCK? Here you go.
May 22, 2017 at 6:00 pm
It does sound as if locale might be the issue (DMY vs MDY).
Just to be clear, please confirm the following:
a) The source is a spreadsheet with a date...
May 22, 2017 at 1:42 pm
May 22, 2017 at 6:59 am
Might be useful to know what version of SSDT/BIDS you are both using.
May 22, 2017 at 5:27 am
So we are a 24/7 operation so for my new/first DW I have a...
May 21, 2017 at 6:57 am
May 19, 2017 at 8:57 am
May 19, 2017 at 6:53 am
The temp table is created within the scope of the execution of the dynamic SQL and is not available to the outer process, because it's out of scope.
May 18, 2017 at 12:29 pm
Viewing 15 posts - 5,566 through 5,580 (of 13,879 total)