Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Basic Cube

Author  Topic 

satheesh
Posting Yak Master

152 Posts

Posted - 2014-08-18 : 05:29:53
Hi All,

I have to transfer a huge chunk of data from a table so i created my first SSAS cube. Now i want to transfer this. How to export this cube to transfer via mail. Any help will be highly appreciated.

Thanks

Regards,
SG

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-08-18 : 05:36:05
BCP is the fastest way to export and import data for tables.
Why did you opt for the CUBE approach?



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

satheesh
Posting Yak Master

152 Posts

Posted - 2014-08-18 : 06:43:28
Thanks for your reply. How to copy just a table using BCP method. Any help will be highly appreciated.

Thanks
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-08-18 : 09:18:32
BCP "dbo.Table" out "C:\Temp\data.txt" -SServerNameHere -PPassword -UUserName


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
   

- Advertisement -