February 27, 2012 at 4:20 am
I have two different IT environment, one local computer client Microsoft CRM 2011, the second local computer use Microsoft BI.
I need to extract specific data from CRM's database to my local computer by using Stored procedure and SSIS. It needs to be done in remotely.
My question is:
How do I retrieve data from CRM to my local computer by using SSIS and remote.
// akirajt
February 27, 2012 at 8:28 am
At a high level, you're going to create a SQL Agent job that runs a SSIS package that extracts/pulls the data you want from your CRM machine and writes it to your local computer. The account that runs the SQL Agent job will need permissions on both machines (CRM & your machine). I'm assuming that the CRM data is in SQL Server. You don't mention the format you want for your output, but you can output SQL Server, Access, Excel, ... Get the SSIS package working locally through BIDS before running it remotely.
I know that's very high level, but I hope it gives you an idea.
Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply