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
            (

Hi Solomon,

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...

Hi,

Imho if there is constant number of Stuff's, you can use the Conditional Split to route data rows to different outputs

Br.

Mike

Hi

Imho you can find some useful information about shrinking tempdb there:

https://support.microsoft.com/en-us/kb/307487

Regards

Mike

Hi,

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.

Imho this...

Hi

Please take a look for Lowell's solution: http://www.sqlservercentral.com/Forums/Topic1502894-1351-1.aspx

Regards

Mike

Hi

Quite simple, not a lot to think about here.

This dynamic data masking function returns first character as it is and rest is replaced.

Regards

Mike

Hi Joy,

Please tell me, there was any other Sql Server version installed before?

Br.

Mike

Hi

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...

Hi Jason

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...

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

...

Hi All

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...

Hi

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.

Best regards,

Mike

Hi Ravi

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).

Best regards,

Mike

Hi

Please clarify, you want to return digits "1 year" or "one year"?

Beside of question above ,small example:

SELECT name,

CAST(DATEDIFF(yy, create_date, GETDATE()) AS NVARCHAR(4)) + ' years, ' +...