Can I execute a Bexquery in a SSIS package of sqlserver?

[edurne_murgiondo]

Hi ,

Hi,

we have our bwp in sqlserver 2012 database. We need to execute a bexquery in a SSIS package for export the result to another sqlserver.Is this posible? We do not find information of this. Does anyone have experience in this?

thanks in advance

[jyothirmayee_s]

Hi,

I have not worked integrating SSIS and BW but looks like you can:

Below link FYR, thanks to author who clearly explained the steps. Older version but still should help you to start.

http://kelzein.blogspot.com/2011/07/how-to-extract-bex-query-and-bw.html

Thanks,

Jothi