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