Re: exporting to access

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi chris2383,

If you'd rather not provide any additional information, you could do
what Warren suggested above with some minor modifications:

1) Filter your data at the source. You do this by using a SQL
Statement in your OLE DB Source task inside your data flow. This is
the recommended method of using a OLE DB Source task anyway as a
custom SQL statement (even if it is simply "SELECT * FROM MyTable")
uses a more efficient connection to the one used by simply selecting a
table or view.

2) To export to Access your destination will need to be an OLE DB
destination using the Microsoft Jet 4.0 driver, the Excel destination
only allows exporting to an Excel file.

As a good starting point, try running the Export Data wizard from
inside SSMS and instead of choosing "Run immediately" at the last
step, choose to save the package (to the filesystem). Then open this
package in BIDS and have a look at what has been generated. This
should give you a basic feel for how SSIS packages are created.

Good luck!
J
.

Relevant Pages

  • Re: exporting to access
    ... Warren Brunk - MCITP,MCTS,MCDBA ... Statement in your OLE DB Source task inside your data flow. ... To export to Access your destination will need to be an OLE DB ... package in BIDS and have a look at what has been generated. ...
    (microsoft.public.sqlserver.dts)
  • Re: elaboration circularity detected problem, How to fix?
    ... package into two seperate packages "Location_Send' and 'Location_Receive'. ... Yep the tasks CHICAGO_RECEIVE and DESTINATION are still waiting for input. ... > package Station is ... > CHICAGO pings the Destination ...
    (comp.lang.ada)
  • RE: SSIS Newbie
    ... I will be running the package multiple times to get it right ... Table 1 file and send it to an OLE DB Destination (not SQL Destination) ... key1 steve smith 100 Park Street NoWhere Fl ...
    (microsoft.public.sqlserver.dts)
  • Re: Missing rows from Transform - Intermittent Issue??
    ... It is the rowcount in the ... destination you are using to determine how many rows were moved or are you ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I execute the DTS package, ...
    (microsoft.public.sqlserver.dts)
  • Re: Fixed Field Columns Missing
    ... it's copied to the destination via a VB script. ... > Allan Mitchell MCSE,MCDBA, ... >> In my package design, I'm running a SQL Truncate Table from the Mainframe ... >>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)