July 30, 2012 at 7:25 am
I am attempting to work through the an example in "Delivering Business Intelligence with Microsoft SQL Server 2008". The task involves loading the Datamart with data from an accounting db(chapter 8 pg 236). The dataflow simply involves an ADO.net datasource(accounting db) and a SQl Server Destination(dm). Both databases(dm and accounting db) are located on the same server which is not my local machine. When I attmpt to configure the SQL Server Destination in the data flow I get a warning that the bulk insert can only be executed on the local computer. I am unable to do anything else(view mappings,avdanced, or preview). Can someone tell me what I am doing wrong?
July 30, 2012 at 10:00 am
I have come across the same type of scenario. Administrative rights are a big factor in your ability to perform bulk inserts. For me at work, I have admin rights but not for bulk inserts as the IT/DBAs of the company I work for do not allow departmental IT to perform bulk inserts on account that they worry about server overloads. At home I was able to perform bulk inserts but not without a lot of trial and error. Source to destination data types are critical with bulk inserts so maybe you could check to make sure all your data types match.
Regards:
Mordred
Keep on Coding in the Free World
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply