Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rob41
Yak Posting Veteran
67 Posts |
 Posted - 2009-07-13 : 10:40:29
|
I am new to SQL SErver 2005/Visual Studio 2005. I have created a new project. I have 2 connections one is to the data warehouse and one is linked to tables in an access 07 db. How do I get connection a which pulls info from a datawarehouse to push data to connection b which is the linked tables in access 07. Connections were easy to create in visual studio 2005 and they are both ODBC. I've tried to find the answer in books with no luck whatsoever.  |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-13 : 11:39:22
|
| Use a Data Flow Task. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-13 : 13:43:36
|
| and inside use OLEDB source and OLEDB destination. source will use Microsoft sql server and destination will use Microsoft Jet 4.0 OLE DB Provider connection managers |
|
|
|
|
|
|
SQL Server/Visual Studio 2005