LOOKING FOR RICHCWI
Thank you for the appended solution to my need to copy MAS90 v.4.2 data into a SQL Server 2005 database. I following your instructions up to the part where you say "a Data Conversion task and a OLE DB Destination task (your SQL Server connection). You will have to use the Data Conversion task to convert WSTR to STR and DateTime to Date in order to load extracted data into SQL Server."
If you can finish with the same detail as you started with,I would oh so greatly appreciate you. If you want to charge me for your solution, let me know. I just need to make it work. If you need to charge than let me know how to get in contact with you.
_____________________________
First we are on MAS 3.71 and using ODBC driver 3.33.10.00 (which you can get from ProvideX - let me know if you need it).
You create a silent named DSN.
In the VS2005 Integration Services Project you first need to create a Connection Manager to the silent DSN. So in the Connection Manager tab right mouse and select "New ADO.NET Connection...". This will bring you to the "Configure ADO.NET Connection Manager" dialog. Click on the New button. In the "Provider" drop down select ".NET Providers\Odbc Data Provider". Then select "Use user or system data source name:" and in the drop down select your silent named DSN. Then click the "Test Connection" button. If its successful then you have a good connection manager with the name of your silent DSN.
In the "Data Flow" tab drag a "DataReader Source" control on to the canvas. Edit it's properties and in the "Connection Managers" tab select the name of the connection manager you just created above. Then click on the "Component Properties" tab and enter the sql statement for the table you want to extract data from - for example "select * from IMA_ProductLine". Then Click on the "Column Mappings" tab and all the columns in that table should appear.
I assume you are going to copy tables/fields in MAS to SQL Server tables. For each table you copy you will need one of the Data Readers (as described above) a Data Conversion task and a OLE DB Destination task (your SQL Server connection). You will have to use the Data Conversion task to convert WSTR to STR and DateTime to Date in order to load extracted data into SQL Server.
Let me know if this helps....
Rich
Thank you for the appended solution to my need to copy MAS90 v.4.2 data into a SQL Server 2005 database. I following your instructions up to the part where you say "a Data Conversion task and a OLE DB Destination task (your SQL Server connection). You will have to use the Data Conversion task to convert WSTR to STR and DateTime to Date in order to load extracted data into SQL Server."
If you can finish with the same detail as you started with,I would oh so greatly appreciate you. If you want to charge me for your solution, let me know. I just need to make it work. If you need to charge than let me know how to get in contact with you.
_____________________________
First we are on MAS 3.71 and using ODBC driver 3.33.10.00 (which you can get from ProvideX - let me know if you need it).
You create a silent named DSN.
In the VS2005 Integration Services Project you first need to create a Connection Manager to the silent DSN. So in the Connection Manager tab right mouse and select "New ADO.NET Connection...". This will bring you to the "Configure ADO.NET Connection Manager" dialog. Click on the New button. In the "Provider" drop down select ".NET Providers\Odbc Data Provider". Then select "Use user or system data source name:" and in the drop down select your silent named DSN. Then click the "Test Connection" button. If its successful then you have a good connection manager with the name of your silent DSN.
In the "Data Flow" tab drag a "DataReader Source" control on to the canvas. Edit it's properties and in the "Connection Managers" tab select the name of the connection manager you just created above. Then click on the "Component Properties" tab and enter the sql statement for the table you want to extract data from - for example "select * from IMA_ProductLine". Then Click on the "Column Mappings" tab and all the columns in that table should appear.
I assume you are going to copy tables/fields in MAS to SQL Server tables. For each table you copy you will need one of the Data Readers (as described above) a Data Conversion task and a OLE DB Destination task (your SQL Server connection). You will have to use the Data Conversion task to convert WSTR to STR and DateTime to Date in order to load extracted data into SQL Server.
Let me know if this helps....
Rich