My package is to copy data from an Access 97 db into a SQL2k5 table.
Problem is that the 'mdb' is subscribed to a 'mdw' workgroup and I have been unable to workout / read how to get the SSIS manager to join the workgroup. Connection fails because "...you don't have necessary permission..."
I was able to do this previously for SQL 2k by messing with the registry, but I'm now on unfamiliar teritory.
Any answers? Cheers.
Open the connection manager UI, and select the All button. Within there you get the Jet OLEDB:System Database propery, which you point at your MDW. You could also just change the connection string directly from the properties grid, or use an expression or configuration if the location can be derived or just change.
|||Connection works. Although I found that I had to specify the password in both the 1st dialogue and security:password item in the 'All' page.
I'm now getting a unicode conversion failure - I've seen other pastings about this so I'll follow those.
Many Thanks.
No comments:
Post a Comment