February 14, 2006 at 8:47 am
I am relatively new to the BI concept from Microsoft but have been happily playing about on my MS SQL Server Enterprise with little to hold me up. However, I have since found that if you create an SSIS package that squirts data into an SQL Server Destination db, you must create that package on the server containing the destination db. This would imply that I have to allow whoever is to be our package creator, access to the server itself just to design packages. Surely this isn't good practice. On saying this I have said I'm relatively new at it so maybe I've missed a simple way around this.... HELP!! Andy |
February 15, 2006 at 7:56 am
Its truer to say that the package must be executed (as opposed to created)on the same server as the destination DB.
Its not a problem tho. The "default" destination adapter to use is the OLE DB Destination adapter. The SQL Server Destination adapter is there to provide extra speed in certain circumstances. Those circumstances being:
1) You're inserting to SQL Server
2) The package is executed on the same machine as SQL Server is running.
Use the OLE DB Destination adater.
Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
February 15, 2006 at 8:04 am
Thanks for your help jamie, I'll give it a try!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply