January 26, 2011 at 10:05 pm
I have created a sybase connection using ASE driver and I can preview the data successfully in the source. My source is using SQL command to pull the dataset from Sybase database. I can also run my package locally on my laptop with no issues. When I put the package in the MSDB on my server, and run from a SQL Server Agent Job, I get the following error
Description: Unable to retrieve column information from the data source. Make sure your target table in the database is available.
The driver is the same on both my laptop and the server, the DSN is the same on both machines. And I was able to test the connection in ODBC Sources on the server.
Any ideas?
January 27, 2011 at 1:39 am
This was removed by the editor as SPAM
January 27, 2011 at 11:28 am
I check the ValidateExternalMetadata to False and that error has gone away, now I am getting this error:
Description: The connection manager failed to defect from the transaction
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply