I am Sunil babu and am new to ssis,I am coding to save xml to sql database ,So I have used Xml Source to which I am giving the xml path and Oledb Destination to save xml in database.
But when I execute the package I get the error
Transfer Error Messages Task] Error: An error occurred with the following error message: """ is not an SMOServer connection.".
Can any body give me a solution for the error and can plz tell me what would be the cause of this error.
for quick reference I have uploaded an snap of the error which I have got while executing the package.
Thank you in advance
There is no snapshot attached.
Are you sure you want to be using the SMO Server connection manager? I would think you'd be using the OLE DB Destination.
I have faced similar kind of error when I was trying to fetch data from DB2 to SQL Server. This was happening at the time of fetching data from DB2 server. Some how the connection was not stablished properly with the DB2 server.
Ultimately I succeeded to resolve the issue. This was happened because the password was missing in the configuration file.
So, please check the credentials carefully.