one for tabular getting fast popularity is ease of use, i.e. no need to process cube, you can start designing reports using the dimensional model.

Also DAX is built based on...

I hope you can use tally/number table to load the data into TableA from TableB.

CREATE TABLE #tblNums(n INT PRIMARY KEY)

DECLARE @cnt =1;

WHILE (@cnt <=100)

BEGIN

INSERT INTO #tblNums(n)

VALUES(@cnt)

SET @cnt = @cnt+1

END

;with...

Its interesting to learn that SSIS can process Word docs.

Thanks for the info.

For more info, refer to this URL.

http://stackoverflow.com/questions/24612375/ssis-export-all-data-from-one-table-into-multiple-files

I think you are using SQL Server as source database.

Use below approach to solve this:

SELECT

st.*

, (ROW_NUMBER() OVER (ORDER BY (SELECT NULL))) % 2...

Thanks for the updated solution.

Thanks for the response.

The recommended article is too good to miss.

You are missing the point.

Its not about connecting from SSMS but connecting using RDP(Remote Desktop); You can access this using MSTSC command in RUN in windows.

Hope the following link helps you to understand how to track the memory utilization of a running package.

https://social.msdn.microsoft.com/forums/sqlserver/en-US/a4b43c56-291f-4625-b9bf-236b36cf7625/memory-usage-of-ssis-packages

Yet another good alternative to learn but little complex compared to pivot solution.

Excellent, I learned this technique from you.

Thanks Luis for clearing my concepts.

Thanks for correcting me, infact its a type from me instead of SQL 2005 I wrote SQL 2008.

Exactly what I am thinking i.e. instead of using convert() its more accurate to use CAST() most of the times.

@luis,

CONVERT(DATE,GETDATE()-180) may not work for the OP if he uses SQL Server 2008 or earlier.