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.
| Author |
Topic |
|
savior faire
Posting Yak Master
194 Posts |
 Posted - 2009-12-31 : 15:17:38
|
| I've been fiddling with SQL Server 2008 BI on my own, and bought a BI study guide, a step by step text, that contains hands on practice exercises.I noticed that in SSIS projects where the data flow is targeting output to a database table, and SQL Destination is being used, this results in an error during execution. The processing error indicates that Visual Studio has to be run "as administrator". I thought this extremely odd. I changed the destination object to OLE DB and it worked fine.___________________________________________Talk sense to a fool and he calls you foolish. |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2010-01-17 : 04:47:38
|
| You cannot use the SQL Server destination in packages that access a SQL Server database on a remote server. Use OLEDB destination insteadhttp://www.sqlserver007.com |
 |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-01-17 : 07:36:16
|
| Thank you for the response. I am doing this on my stand alone, personal desktop computer at home, so I would be referencing the SQL Server server that is "local".______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
|
|
|
|
SQL Destination task