![]() ![]() Then I figured out other way using a linked server as mentioned in their forum. Index was outside the bounds of the array. ![]() ![]() TITLE: SQL Server Import and Export WizardĬolumn information for the source and the destination data could not be retrieved, or the data types of source columns were not mapped correctly to those available on the destination provider(left side of arrow being a source and right one being destination). I have tried to use the import/export wizard of SQL Server by creating source for ODBC driver datasource (my datasource is the server database path for sage data) and in the destination I provided driver for OLE DB provider for SQL but while I started the import for a single table, I get the following error: They also want me to have the CRM data inside SQL Server first and then migrate that data to Dynamics 365. My company is using Sage CRM and wants me to create a batch job to transport the data from Sage 100 to Dynamics 365 every midnight.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |