Viewing 15 posts - 1 through 15 (of 214 total)
Hi,I'm not quite sure what you are looking for, but please try this:IF OBJECT_ID('tempdb..#TBL_AUDIT') IS NOT NULL DROP TABLE #TBL_AUDIT CREATE TABLE #TBL_AUDIT (
October 5, 2018 at 3:51 am
thanks for your help, I checked IsInvariantToDuplicates first and it didn't help,
but I expected that, because it worked well in previous version where I used .NET List<T>.
So it confirmed...
July 19, 2016 at 2:03 am
Imho if there is constant number of Stuff's, you can use the Conditional Split to route data rows to different outputs
March 30, 2016 at 3:20 pm
Imho you can find some useful information about shrinking tempdb there:
March 23, 2016 at 4:03 pm
Please check memory configuration, SQL server is aggressive with memory allocation
and can occupy most of the memory, SSIS has to fight for memory allocated outside of SQL server.
March 22, 2016 at 4:48 pm
Please take a look for Lowell's solution: http://www.sqlservercentral.com/Forums/Topic1502894-1351-1.aspx
March 20, 2016 at 7:46 am
Quite simple, not a lot to think about here.
This dynamic data masking function returns first character as it is and rest is replaced.
March 20, 2016 at 7:21 am
Please tell me, there was any other Sql Server version installed before?
March 18, 2016 at 1:51 am
Local System or Network Service are the system accounts which have no network access.
The SQL Server service must be started using a domain user account to access any resources on...
March 17, 2016 at 6:36 am
I'm doing it in other way, there is a "queue" table where users (applications) can insert a task to do.
I created a Sql Server Agent job, it fires every...
March 16, 2016 at 8:59 am
Thanks Luis, you saved my time, that's it what I was looking for 🙂
Hugo, Kevin's advice was very helpful, but I have been scratching my head on this for three
March 2, 2016 at 1:48 am
Thanks for suggestions, as Hugo wrote, looping through table records as a substitute for cursor is not the best solution.
I'm trying to find a set-based option to increase counter...
March 1, 2016 at 1:44 am
Please set up properties "ColumnNamesInFirstDataRow - False and
DataRowsToSkip - 2 in the Flat File Connection.
You have to uncheck all columns except first one in Flat File Source.
November 24, 2015 at 3:56 am
My package uploads files on SFTP server. I prepared simple batch
"C:\Program Files (x86)\WinSCP\WinSCP.exe" /console /script=upl_conf.txt
and fire it with Execute Process Task (look for attached image).
November 24, 2015 at 2:43 am
Please clarify, you want to return digits "1 year" or "one year"?
Beside of question above ,small example:
CAST(DATEDIFF(yy, create_date, GETDATE()) AS NVARCHAR(4)) + ' years, ' +...
November 24, 2015 at 2:28 am