February 7, 2012 at 7:35 pm
Hi,
I'm trying to deploy an SSIS package to a client's server
The package is getting data from access.mdb database.
If I get data from flat table, everything is OK, as only I am trying to get data from linked tables - failed (running OK under VS)
with Message:
Executed as user: SqlAgentSvc. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:50:09 PM Error: 2012-02-08 12:50:09.52 Code: 0xC020838F Source: Data Flow Task 1 ADO NET Source [154] Description: An error occurred executing the provided SQL command: "SELECT * FROM DailyOutputQuery;". Object reference not set to an instance of an object. End Error Error: 2012-02-08 12:50:09.59 Code: 0xC004706B Source: Data Flow Task 1 SSIS.Pipeline Description: "component "ADO NET Source" (154)" failed validation and returned validation status "VS_ISBROKEN".
February 8, 2012 at 12:10 pm
are you able to connect to the source of the linked tables? By that I mean, skip Access and go to where the linked-to-Access tables actually live.
Just seems like using them as links could have ramifications larger than just the current/temporary lack of connectivity.
February 8, 2012 at 2:54 pm
this is what I am doing now, 2 Sources (Access db) and merge them in one, but thought that there may be another way. Not sure how to merge them in getting aggregates (sum, min, max).
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy