Hi, env = Visual Studio 2010 and using SSIS template for connection to DB2 databases.
Within a package we have an OLE DB Task which is configured to run a basic SQL comand and this is successfull, e.g.
[SELECT * FROM TQATTF2.TDFP11]
We have now changed the connection user id & pwd to that of a service account which only has access to the required library. Leaving the SQL statement exactly the same, it is again successfull.
The benefit of using the service account should mean that when required we can remove the library and then promote the package from one environment to another by simply changing the connection userid / pwd, the statement will now be such as:
[SELECT * FROM TDFP11]
The above statement now fails to run as we have removed the library from the statement. Can anyone tell me where/how i can acheive the removal of of the lib.
For info, when running the same sql from say a MS access db, we would change the ODBC setting to be *SYS naming convention and remove the default library.
Thanks very much.