Integration Services

When I try to run Data Flow to get multiple mdb files getting this error
any thoughts '
TITLE: Package Validation Error
--
Package Validation Error
--
ADDITIONAL INFORMATION:
Error at Data Flow Task [OLE DB Source [1]]: The AcquireConnection method
call to the connection manager "Northwind_1" failed with error code
0xC0202009.
Error at Data Flow Task [DTS.Pipeline]: component "OLE DB Source" (1) failed
validation and returned error code 0xC020801C.
Error at Data Flow Task [DTS.Pipeline]: One or more component failed
validation.
Error at Data Flow Task: There were errors during task validation.
Error at ForEachLoop [Connection manager "Northwind_1"]: An OLE DB error has
occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for ODBC
Drivers" Hresult: 0x80004005 Description: "[Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified".
(Microsoft.DataTransformationServices.VsIntegration)Gopinath,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
HTH
Jerry
"Gopinath" <Gopinath@.discussions.microsoft.com> wrote in message
news:628161DE-68B2-47F5-9420-897A93BB7D32@.microsoft.com...
> When I try to run Data Flow to get multiple mdb files getting this error
> any thoughts '
>
> TITLE: Package Validation Error
> --
> Package Validation Error
> --
> ADDITIONAL INFORMATION:
> Error at Data Flow Task [OLE DB Source [1]]: The AcquireConnection method
> call to the connection manager "Northwind_1" failed with error code
> 0xC0202009.
> Error at Data Flow Task [DTS.Pipeline]: component "OLE DB Source" (1)
> failed
> validation and returned error code 0xC020801C.
> Error at Data Flow Task [DTS.Pipeline]: One or more component failed
> validation.
> Error at Data Flow Task: There were errors during task validation.
> Error at ForEachLoop [Connection manager "Northwind_1"]: An OLE DB error
> has
> occurred. Error code: 0x80004005.
> An OLE DB record is available. Source: "Microsoft OLE DB Provider for
> ODBC
> Drivers" Hresult: 0x80004005 Description: "[Microsoft][ODBC Driver
> Manager]
> Data source name not found and no default driver specified".
> (Microsoft.DataTransformationServices.VsIntegration)
>|||Hi Jerry,
Please check the URL its not have any details about my question, Am I
missing anything.
Thanks
Gopi
"Jerry Spivey" wrote:
> Gopinath,
> Please see:
> http://www.aspfaq.com/sql2005/show.asp?id=1
> HTH
> Jerry
> "Gopinath" <Gopinath@.discussions.microsoft.com> wrote in message
> news:628161DE-68B2-47F5-9420-897A93BB7D32@.microsoft.com...
> > When I try to run Data Flow to get multiple mdb files getting this error
> >
> > any thoughts '
> >
> >
> > TITLE: Package Validation Error
> > --
> >
> > Package Validation Error
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > Error at Data Flow Task [OLE DB Source [1]]: The AcquireConnection method
> > call to the connection manager "Northwind_1" failed with error code
> > 0xC0202009.
> >
> > Error at Data Flow Task [DTS.Pipeline]: component "OLE DB Source" (1)
> > failed
> > validation and returned error code 0xC020801C.
> >
> > Error at Data Flow Task [DTS.Pipeline]: One or more component failed
> > validation.
> >
> > Error at Data Flow Task: There were errors during task validation.
> >
> > Error at ForEachLoop [Connection manager "Northwind_1"]: An OLE DB error
> > has
> > occurred. Error code: 0x80004005.
> > An OLE DB record is available. Source: "Microsoft OLE DB Provider for
> > ODBC
> > Drivers" Hresult: 0x80004005 Description: "[Microsoft][ODBC Driver
> > Manager]
> > Data source name not found and no default driver specified".
> >
> > (Microsoft.DataTransformationServices.VsIntegration)
> >
> >
>
>|||If the SSIS package doesn't validate then a likely cause is that you
have configured something incorrectly.
The first thing I would check is the OLE DB Connection Manager that
you are using.
Go over each step of the configuration and check that you set it up
correctly.
If you don't see a solution by that simple expedient I suggest that
you go to
http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19 and post
your question on the Integration Services forum.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 08:00:05 -0700, "Gopinath"
<Gopinath@.discussions.microsoft.com> wrote:
>When I try to run Data Flow to get multiple mdb files getting this error
>any thoughts '
>
>TITLE: Package Validation Error
>--
>Package Validation Error
>--
>ADDITIONAL INFORMATION:
>Error at Data Flow Task [OLE DB Source [1]]: The AcquireConnection method
>call to the connection manager "Northwind_1" failed with error code
>0xC0202009.
>Error at Data Flow Task [DTS.Pipeline]: component "OLE DB Source" (1) failed
>validation and returned error code 0xC020801C.
>Error at Data Flow Task [DTS.Pipeline]: One or more component failed
>validation.
>Error at Data Flow Task: There were errors during task validation.
>Error at ForEachLoop [Connection manager "Northwind_1"]: An OLE DB error has
>occurred. Error code: 0x80004005.
>An OLE DB record is available. Source: "Microsoft OLE DB Provider for ODBC
>Drivers" Hresult: 0x80004005 Description: "[Microsoft][ODBC Driver Manager]
>Data source name not found and no default driver specified".
> (Microsoft.DataTransformationServices.VsIntegration)|||Gopi,
The URL is basically indicating the *best* community to answer your SQL
Server 2005 questions. SQL Server 2005 has not yet been released and is
still in BETA. Choosing the best NG to answer your post will likely expite
an answer and will help minimize a duplication of effort when posting to a
2000 and 2005 NG.
HTH
Jerry
"Gopinath" <Gopinath@.discussions.microsoft.com> wrote in message
news:5CA99ED7-07C4-48A2-883A-046CD61F007E@.microsoft.com...
> Hi Jerry,
> Please check the URL its not have any details about my question, Am I
> missing anything.
> Thanks
> Gopi
>
> "Jerry Spivey" wrote:
>> Gopinath,
>> Please see:
>> http://www.aspfaq.com/sql2005/show.asp?id=1
>> HTH
>> Jerry
>> "Gopinath" <Gopinath@.discussions.microsoft.com> wrote in message
>> news:628161DE-68B2-47F5-9420-897A93BB7D32@.microsoft.com...
>> > When I try to run Data Flow to get multiple mdb files getting this
>> > error
>> >
>> > any thoughts '
>> >
>> >
>> > TITLE: Package Validation Error
>> > --
>> >
>> > Package Validation Error
>> >
>> > --
>> > ADDITIONAL INFORMATION:
>> >
>> > Error at Data Flow Task [OLE DB Source [1]]: The AcquireConnection
>> > method
>> > call to the connection manager "Northwind_1" failed with error code
>> > 0xC0202009.
>> >
>> > Error at Data Flow Task [DTS.Pipeline]: component "OLE DB Source" (1)
>> > failed
>> > validation and returned error code 0xC020801C.
>> >
>> > Error at Data Flow Task [DTS.Pipeline]: One or more component failed
>> > validation.
>> >
>> > Error at Data Flow Task: There were errors during task validation.
>> >
>> > Error at ForEachLoop [Connection manager "Northwind_1"]: An OLE DB
>> > error
>> > has
>> > occurred. Error code: 0x80004005.
>> > An OLE DB record is available. Source: "Microsoft OLE DB Provider for
>> > ODBC
>> > Drivers" Hresult: 0x80004005 Description: "[Microsoft][ODBC Driver
>> > Manager]
>> > Data source name not found and no default driver specified".
>> >
>> > (Microsoft.DataTransformationServices.VsIntegration)
>> >
>> >
>>