When trying to create a data source in Solution Explorer the Provider is greyed out and only allows me to create a connection to a SQL server database although I can connect to an oracle database in Server Explorer
View 5 RepliesI am a Visual Studio .net developer and understand Solutions and Projects in VS.net. Nevertheless, it appears that the paradigm of using Solutions Explorer in SQL Server is not exactly the same. That is, in Visual Studio you can't get anything done without creating a solution first. In SQL Server, it is entirely possible to get a lot done without a solution and the ability to create and make use of a solution seems almost an after thought or an add-on.
I am particularly interested in using a solution in SQL Server to allow me to make use of SourceSafe. In the past, we jumped through all kinds of hoops to keep a running trail of changes we had made to (for example) stored procedures. It appears now that this can be managed more efficiently with the use of a Solution and SourceSafe and saving scripts or .sql files. I guess it is not possible to save a pristine copy of a stored procedure directly in SourceSafe, but you can save the code that makes up the stored procedure as a .SQL file which I suppose is about as good.
Anyway, what I would like to know is whether there is a good white paper (or chapter in a book) on the philosophy behind Solutions and projects in SQL Server and how MS intends us to use them; perhaps something other than the cold facts from the documentation. I would appreciate something more that gives me the big picture on just how MS sees them being used in SQL Server so I can get the most out of them. I have the feeling that if I "get the vision", they are meant to be an integral part of SQL Server now and in the future.
Woody
Good afternoon,
This is a simple question....how can I order packages by name in solution explorer ? I have a solution with more or less 50 packages
and it's very ime consuming to find a package ! ehehe
Thanks everybody
Up to the moment I don't need it at all
tia
Hi..
Isnīt it possible to create sub folders in the solution explorer??
I have it hard time to create a decent structure inside the SSIS Package folder, since I have like 30 packages in my project. Is it just me being silly or cannot this be done?
Have a nice day
/Erik
Can the items, i.e. reports within the SSRS Report Designer Solution Explorer be arranged in a custom manner instead of being sorted alphabetically only?
View 2 Replies View Related
Hello,
When you create a Reporting Services project it by default creates two folders: Shared Data Sources & Reports. When I right click on the Reports folder in solution explorer in Visual Studio 2005 there is no option to add subfolders, I am simply left with handful of options adding report files. Is there a way to add subfolders to the Reports folder? I am going to be migrating over 40-50+ reports and it would be helpful to organize them into their own folders.
Thanks,
Flea
I'm stuggling to find information on how to use the Deploy menu within a project in solution explorer. I would like to understand how to setup modify and delete the attributes that affect the actions of the Deploy menu. How to set different settings so that I can deploy to a test server ad then later change it so that I can deploy to a production server.
All help is welcome.
Thanks
I assume this is the best forum for this quesiton; if not, please direct me.
View 3 Replies View RelatedHello all,
A simple one: How can I sort the packages in my project (in the solution explorer) in an alphabetical sort?
Thanks,
Liran
I've submitted a bug report for this, but I also want to be sure it's not my own installation.
In the solution explorer, when I drag a package (usually accidentally) to another spot in the list, it disappears from the list. If I try to re-add the package, it thinks the original already exists, and names the second one with a "(1)" suffix. I can work around this by moving the original package out of the primary package folder and then re-adding it through solution explorer, but that's a touch cumbersome.
I don't really have a question here other than perhaps validation of the issue. Thanks.
Here's the bug report if others experience the same issue:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=258908
Yesterday, SQL Server 2005 SP2 was installed on our DEV Server (Windows 2003 SP1 x86) and now I cannot right-click a package in the Solutions Explorer window in BIDS and Execute Package. When I do, I get the following error
===================================
Object reference not set to an instance of an object. (Microsoft Visual Studio)
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)
I know I could do this yesterday morning pre SP2. I've attempted this with a couple of different packages and solutions, so it is probably not a corrupt package (unless now they are all corrupt). I can execute in debug mode if I open the package first and then hit Start Debugging. However this is not always an optimal solution because I sometimes have many connected packages and sometimes what gets executed is not what is expected.
Your thoughts would be appreciated.
Hi,
I have been fighting this problem for several days now.
All I need to do is run a query against a table on mssql 2005 server and update a table (only update) in Oracle
Here are some of the things I have tried:
1) from a forum tip, I set up a dataflow: OLE DB Source (MS SQL) -> Derived Column -> OLE DB Command (Oracle)
- I get "Error at Data Flow Task [OLE DB Command [2850]]: Columns "NyNamn" and "id" cannot convert between unicode and non-unicode string data types."
2) I have tried a Source - OLE DB Source (MS SQL) -> Derived Column -> OLEDB Desination (Oracles OLEDB)
- Error when trying to preview:
TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [OLE DB Destination [2953]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF.
Error at Data Flow Task [OLE DB Destination [2953]]: Opening a rowset for ""APPINV2"."OWNERS"" failed. Check that the object exists in the database.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
3) I have tried a Source - OLE DB Source (MS SQL) -> Derived Column -> OLEDB Desination (MicrosoftsOLEDB for Oracle)
- Error when trying to preview:
TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [OLE DB Destination [2953]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Unspecified error".
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle error occurred, but error message could not be retrieved from Oracle.".
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Data type is not supported.".
Error at Data Flow Task [OLE DB Destination [2953]]: Opening a rowset for ""APPINV2"."OWNERS"" failed. Check that the object exists in the database.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
I have full rights on the oracle database with the account used, i can connect with toad with no problems.
To me, this should be a simple task. has anyone got any advice for me ?
Thanks
I am using MS SQL Server Managment Studio 2005 - I also use the old Enterprise Manager from time to time. My questions are about making SMS2005 more user friendly.
I) Is there a way to keep the list of server connections displayed in the object explorer after the application is closed and re-opened?
II) Is there a way to save the password in the "Connect Object Explorer" so I don't have to keep confirming the password to enable the connection?
In summary: In Enterprise Manager, the database engines are always displayed in the Object Explorer and are automatically connected upon opening the manager. Is this functionality possible in SMS2005?
Hello,
On my dev server I have working ssis packages that use connections Microsoft OLEDB provider for Oracle MSDAORA.1 and Oracle provider for oledb and OracleClient data provider.
I use one or the other according to my needs.
In anticipation and to prepare for the build of a new production server, I have build a test server from scratch and deployed to it the entire dev.
Almost everything works except Microsoft OLEDB provider for Oracle.
ssis packages on the test machine will return an error
Error at Pull Calendar from One [OLE DB Source [1]]: The AcquireConnection method call to the connection manager "one.oledb" failed with error code 0xC0202009.
Error at Pull Calendar from One [DTS.Pipeline]: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
[Connection manager "one.oledb"]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle error occurred, but error message could not be retrieved from Oracle.".
I have used the same installers for OS, SQL and Oracle SQL*Net on both dev and test machines. The install and then the restore/deployment on Test went fine.
Does anyone could point me to the right direction to solve this issue?
Thanks,
Philippe
In SQL Visual Basic 2005 Express Edition, I was wondering if it is possible in the Add Connection dialog under Advanced settings to change the Data Source SQL server from the local .sqlexpress to a network SQL Express server. It seems as though the option is locked. I am in a doman, and using Windows Authentication. I also have TCP/IP enabled on the SQL server, and no firewall restrictions for the SQL service. Also, my account permissions should also allow me to do this.
John55616
Hello,
I'm trying to add a new connection in server explorer. The server will not appear
in the server drop down list, and when i manually type in the server and database name,
the connection fails saying
"An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - could not open a connection
to SQL Server)"
I made sure the remote connections were on, and I am having no problems open
the sql connection in code.
Thanks in advance,
Sharp_At_C
Hi
First up - my apologies if this is not the right forum for this question. Please let me know if there is a more appropriate one for this question.
I have come across an issue with my SQL Server 2005 Express Edition install. It has been running fine since the install (a few months back). And I can still interact (query, update etc) the databases just fine. However, SQL Management Server Studio Express has started to produce an error message when I attempt to connect the Object Explorer.
The error message is shown below.
I have tried to access the link shown in the error message but there is no information provided there.
I can use SQL Management Server Studio Express to run queries on the databases so it would appear that the underlying services are all running OK.
The SQL Server is installed using SQL Authentication only and I have not made any changes to Service accounts or the services themselves. The protocols all appear to be in order too - Shared Memory, Named Pipes, TCP/IP are all enabled.
I have restarted the SQL services and even rebooted the machine, but to no avail.
I would really appreciate if anyone out there could give me some guidance on what may be causing this issue.
Note: The SQL Server is installed on WinXP Pro SP2 running in a VirtualPC. All apps are release versions (no beta or CTP)
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
hi
i am working with Asp.net2.0,Sqlserver2000.
i uploaded my developed application to the webserver.
all webpages are opening..bt when i try to interact with database it is raising error as following..
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
i set Enamble to namedPipes,Tcp/IP
i set Remote connection to enable
my web.config looks like this..
<?xml version="1.0"?>
<configuration> <appSettings>
<add key="cn" value="User ID=redot;Password=redot;Data Source=216.185.43.148:1423;Initial Catalog=redot" /> <!--<remove key="LocalSqlServer"/> ;ProviderName=System.Data.SqlClient-->
</appSettings> <connectionStrings> <!--<remove name="LocalSqlServer"/>-->
<add name="redotConnectionString" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> <add name="redotConnectionString1" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> <add name="redotConnectionString2" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> <add name="redotConnectionString3" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> <add name="redotConnectionString4" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> <add name="redotConnectionString5" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> <add name="redotConnectionString6" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> <add name="redotConnectionString7" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> <add name="redotConnectionString8" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> <add name="redotConnectionString9" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> <add name="redotConnectionString10" connectionString="Data Source=216.185.43.148:1423;Initial Catalog=redot;User ID=redot;Password=redot" providerName="System.Data.SqlClient" /> </connectionStrings> <system.web>
<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=216.185.43.148:1423;User ID=redot;Password=redot;Trusted_Connection=True" cookieless="false" timeout="60" />
<compilation debug="true" /> <!-- The <authentication> section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. -->
<customErrors mode="Off"> <error statusCode="404" redirect="filenotfound.htm" /> </customErrors>
</system.web> <system.net>
<mailSettings>
<smtp> <network host="216.185.54.55" port="25" /> </smtp> </mailSettings>
</system.net></configuration>
i will be very thankful ,if anyone help me to resolve this problem..
pls..its urgent for me
Thanks& Regards
Shobha
Hi everyone - I'm getting myself into a right muddle and am looking for advice.
How do people deal with connection string matters when taking a dataset defined in one assembly (and by default using the connection strings defined within that assembly in the settings files) and then using that assembly in an app (which also has a requirement to see the same physical database).
I'm not sure I've explained that terribly well but what I'm trying to avoid is duplicate copies of my database which so far seems to be the only way that I've managed to make stuff work. I'm not very experienced with SSCE data access (I'm a serices/sockets/ip person) and this may just be ignorance. Most of the examples seem to assume that the data is in the same place as the app whereas I'm trying to collate a whole series of functions into a helper assembly that I'd like to re-use for other things.
Ideally the dataset designer would provide an easy way of choosing from centralised connection strings - perhaps this is what the Dataset Project implies - but again the docs are mostly focused on SQL Server? Otherwise the best I've been able to do is make the connection properties public and try to update them that way or use a post-build action to copy the database from my datalayer project directory to that of my application |DataDirectory|
I suppose the question might be if you have a dataset containing multiple tableadapters that assumes one connection string, is there any easy way to keep such strings co-ordinated between projects without hardcoding them? With a server resource, the same non-specific connection string resolves to the same server (if that make sense) and this seems to be were I can't make the logical shift.
Does anyone have any thoughts and can they please point this SSCE noob in the right direction?
Cheers
Hi all,
I just realized recently that a database "XYZ" in the Object Explorer of my SQL Server Management Studio Express (SSMSE) is put in the Database Explorer of my VB 2005 Express for processing a Stored Procedure in executing the SELECT statements (not by using Input and/or Output Parameters) during the ADO.NET 2.0-VB 2005 Express programming, then the content of the database "XYZ" is not in the SSMSE. How can I return the database "XYZ" from the DataBase Explorer of VB 2005 Express back to the Object Explorer of SQL Server Management Studio Express (SSMSE) safely? Please help and advise.
Thanks in advance,
Scott Chang
I need a way to connect to an Oracle database and pull the information from that database into a Sql Server Database. An Oracle gateway is not an option.
Is there a way to set up an odbc connection to connect to the database or is there another way to connect?
Thank you,
Anita Ossowski
I've created a SQL stored procedure and would like to connect to an Oracle database & query results within the procedure. Is this possible?
View 1 Replies View RelatedI am moving dta afrom an Oracle source to SQL serevr 2005 using SSIS
Used: Provider: Microsoft OLE DDDB provider for Oracle and typed in Server and username with password.
When executed the package with defaul settimngs( Package ProtectionLevel: EncrptSensitiveWith userkey OR DONTSAVESENSITIVE, EncrptAllwithPassword) and Isolationlevel: serializable/ read comitted) the package responded fine.
When I try to do 'Package Configuration' and type in password in config file the package doesn't responds. it gives following error.
TITLE: Microsoft Visual Studio
------------------------------
Error at Package2 [Connection manager "DEV04.XYZ"]: An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Error at Data Flow Task [OLE DB Source [1]]: The AcquireConnection method call to the connection manager "DEV04.XYZ" failed with error code 0xC0202009.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
I also get this error:
Executed as user: XYZUHSQLServer. ...042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:01:42 PM Error: 2008-05-19 13:01:43.22 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2008-05-19 13:01:43.96 Code: 0xC0202009 Source:ExtAWMData Connection manager "XYZ ABC" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E4D Description: "ORA-01017: invalid username/password; logon denied ". End Error Error: 2008-05-19 13:01:43.96 Code: 0xC020801C... The package execution fa... The step failed.
Please advice on
1) Selection of provider for Oracle connection
2) ProtectionLevel
3) Isolation Level
4) Package configuration - Connection Strings (MSDAORA.1)
5) Publishing the package on Server best way.
Thnak a lot for all your valuable time and efforts.
AWM
I've installed 32 and 64 bit oracle drivers. I was testing running the two different dtexec.exe programs the other day, logged in as the sql agent and they both worked. Running the 64 bit as a job did not work. 32 bit does not work, since the agent process is 64 bit, from what I understand.
Today I'm working on it again and trying the same steps. Running the 32 bit executable dtexec is now returning "not a valid win32 executable". I swear this worked the other day, and works on our other server.
Running the 64bit executable from the agent just hangs up on this log entry:
HRD1.Cardiff (my oracle connection)
ExternalRequest_pre: The object is ready to make the following external request: 'IDataInitialize::GetDataSource'.
Anyone know what is going on?
http://support.microsoft.com/kb/918760/
I read this article, but didn't think it applied,since I chose for protectionLevel = sql to handle permission (I think they ) -
So I created a proxy using my credentials and gave it access to cmdexec and ssis and it worked. Can anyone explain this to me??
Hi,
I have created a simple report that reads data from Oracle within Visual Studio. I have no problem with previewing the report within Visual Studio. When I deploy the report to the Report Server (same machine) and try to open the report through Report Manager, I get the following error message:
An error has occurred during report processing.
Cannot create a connection to data source 'xxxx'.
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
I am aware of the following issue that requires extra security to be assigned to the Oracle directories: http://support.microsoft.com/Default.aspx?kbid=870668
Even after applying the Read/Execute access to the Network Service account that is running the Reporting Service, I still get the error message.
Can anyone help me with the debugging of this issue?
Thanks,
Ben
I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.
Reports off the SQL Server Data Sources arerunning fine.
Can any one out there help me out on this. I will really appreaciate.
Regards,
Sam.
I am having some difficulty to update a record in a table from SQL Server 6.5 to Oracle 7.3 DB.
Basically I want to write a insert trigger in Sql Server 6.5 table and I want to update the same inserting record to Unix Oracle table. I tried by writing a DLL and use that in SQL Server External Stored Procedure, but I dont know how to pass the parameter for that. Parameter here is record which I want to insert in to Oracle Table.
Is there any easy way to do that? Did any body did that before? Please help me out.
Thanks a lot
We are in the process of setting up some type of interface between 2 applications that utilize SQL Server(ours) and theirs which utilizes Oracle. These servers will actually sit in the same server room. My thought was to take the simple approach of each DB setting up views needed by the other and assigning a user and security so the other DB can look at the data. We currently do this in house. THeir solution is to use a somewhat sophisticated mesaging system which will pass XML information back and forth between the systems. I hate to take the simpleton approach but why go through all that trouble where a simple view not only provides the same functionality, but is a dynamic as it gets. If anything goes wrong with the messaging system itself or problems with a specific message this needs to be resolved before the data is available. Non of this is a problm with the view. Any input from anyone who has this in place(either solution) appreciated. Or any arguments against my point of view
View 1 Replies View RelatedHi,For a customer we have implemented a datawarehouse with a connection toOracle. From the beginning of the project the connection to Oraclegives troubles. The next morning is the connection still active andwhen the customer looks in the processes of SQL Server a " Wait type,RESOURCE_SEMAPHORE." is shown. For what i know. SQL Server is waitingfor a resource, in this case Oracle but doesn't tell me anything aboutwhat could be the problem.The customer uses the Oracle driver instead of a microsft oracledriver.What could it be? and how can we tackle this problem? Are there ways tolook from Oracle point of view? Can we monitor something?Greetz,Hennie
View 2 Replies View RelatedHi,
We are trying to change our current SSRS reports to point to an Oracle 10g database. I can connect to the Oracle db from the report server via the ODBC Administrator and also through the BI 2005 studio. The connections work fine. However, when I publish the reports and try to run them from the web I always get a connection error. When I use the oracle connection it acts as if it doesn't see the oracle client and when I use ODBC it throws a werid 114 error.
Is there anything I am missing? I just don't understand why the report will work in BI Studio, but not when it is published (on the same machine)?
Any thoughts?
S
Hi,
I'm trying to get some developers going with ssis on their desktops running
XP sp 2
Microsoft SQL Server Integration Services Designer
Version 9.00.3042.00
Oracle client drivers 9.2.0.1.0
Oracle Enterprise 8.1.7.4.0 and 9.2.0.1.0
I have the same setup on my machine and it's working fine. I duplicated steps I used to get data on the develoeper machine and got these errors.
Code Block
Pre-Execute
Execute phase is beginning.
Execute phase is beginning.
PrimeOutput will be called on a component. : 1 : OLE DB Source
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01403: no data found".
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01403: no data found".
SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
I'm at a loss of where to go next and I need to get these guys rolling!
Next step is to reinstall drivers...but I'm doubting that is going to have any effect.
Thanks for any help
The problem being faced is : I am unable to access the oracle data through DTS Transform Data Task or Data Driven Query Task.
I have added the connection object . The test connection succeeds but when I move to the properties of either TDT or DDQ , It just hangs up