Re: SQL 2005: Integration Package Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Create an ADO.Net connection, selecting the Odbc Data Provider.

You can then use the Data Reader source against this connection.

There is also an Integration Services newsgroup -
microsoft.public.sqlserver.integrationsvcs.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"TomT" <tomt@xxxxxxxxxxxxxxxx> wrote in message
news:F897423D-00AC-4E68-8DF3-4C8F6F80A970@xxxxxxxxxxxxxxxx
> We have a number of DTS packages running on a SQL 2000 server, pulling
> data
> from a non-relational accounting database.
>
> The package is set up using an ODBC connection to this database, which
> uses
> a system dsn on the machine.
>
> I want to re-create all this over on a SQL 2005 system. I have installed
> the
> ODBC driver which allows me to create the dsn, which tests successfully. I
> am
> creating a new SSIS package to try this out, but am a bit stumped. I've
> created a data source based on the dsn, which appears to work fine (and
> appears in the connection managers), however I'm at a loss as to how to go
> from here. I have been trying to create a data flow task to access the
> accounting data, but the choices don't include (as far as I can see) and
> ODBC
> connection, just OLE DB, which does not let me use the connection I set
> up.
>
> I would have thought there would be and ODBC data flow source? In 2000, I
> used a transform data task, but so far have not found it's equivalent in
> 2005. I'm sure I'm missing something obvious (I hope) - I'm just looking
> for
> a way to use the odbc connection in a data flow task.
>
> At this point, I don't want to just import the previous dts packages, as
> I'd
> like to completely re-do them.
>
> Any help would be most appreciated,
>
> Thanks,
>
> Tomt


.

Relevant Pages

  • Re: Reading mm datasource
    ... When in Word on my machine, I click on open datasource, pick Connect ... > do not seem to have a specific driver name for the connection string. ... But before you go much further, I hadn't realised you were taking that particular approach to making the connection, and AFAIK the consequence is likely to be that you will be opening your data source, using the "OLE DB Provider for ODBC data sources" which is an approach I know little about but will ...
    (microsoft.public.word.mailmerge.fields)
  • Re: VFP Updates?
    ... Try talking ODBC or OleDb and they say HU. ... make up my apps so that what ever they want to run has to be from a command ... kind of connection and assign it the right to do exactly what you want. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... # Same query previously worked in Progress 8.x using SQL89. ... This entry allows you to keep your existing code written with the ODBC ... BTW, if you put all of the connect information into the connect string, ... I also tried putting the whole thing in the connection string: ...
    (microsoft.public.access.modulesdaovba)
  • Re: OpenDataSource & stored procedure
    ... recognises the ODBC escape syntax. ... You shouldn't need the connection parameter since Word gets it from the ... return multiple result sets - enough to confuse software such as MS Query ... >>> The call works in MSQuery but won't return the data to Word. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)