Hi,
We are attempting to use the MS SQL Server Load stage for the first time in our shop. I am running a simple test trying to load a 4 row text file into an SQL server table.
Sequential file====>> Interprocess====>>MS SQL Server Load stage
I receive the following warning when I run and don't know where to begin looking.
jptest..MS_SQL_Server_Load_3: SQL server OLEDB provider authorization failed. followed by...
jptest..MS_SQL_Server_Load_3: Failed to establish datasource connection.
Thanks - - John
MS SQL Server Load stage error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am