SSIS Odata source problem - No object exists with the ID 11.
Hey guys, I am currently facing a problem on my SSIS package and all your help would be very helpfull. Here is the scenario,I have a data flow with a Odata Source inside, here is the image bellow. I can confirm that the connection is working and the filter options are also working because I can view the data: Unfortunately when I run the package I get the following error: [SSIS.Pipeline] Erro: No object exists with the ID 11. [Fonte de Dados OData 1 [2]] Erro: The Fonte de Dados OData 1 was unable to process the data. Excepção de HRESULT: 0xC0047072 [SSIS.Pipeline] Erro: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Fonte de Dados OData 1 returned error code 0xC02090F5. 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. There is nothing else on the data flow, I just cant understand what is going on. Appreciate all the help.
Simple import data and lookup
I want to import data from excel and update a table in sqlserver The excel file has a column and a pk to compare with DB table, and update db table column. I am able to get the data using excel source and now looking for how to update the database table one column IsValid using excel (header in excel is same as header in sql table and data is also same) data. Excel file and db table has primary key value as ID, if the ID from excel and DB matches I want to update the table data column isValid using excels isValid field Is it using look up we can do it or using merge ?Ora source table receives continuous transaction
I have a oracle source table in my ETL which is getting loaded 24/7 continuously, when I run the data load from this table to SQL server using SSIS ETL with table fast load. My package loads some data and it fails.If I stop the oracle source table from getting continuously loaded, my ETL pkg runs fine, I see this in dev env. But in real time on prod I cannot do this, why can't my pkg load and run with out failing. One more thing, I have SQL server target table, I pick up the max of last inserted data in SSIS variable and use it for querying incremental load from source oracle table. Table lock and check constraint in destination(SQL Server) oledb are tickedERROR 4819
SQL Server: 2019 ERROR (4819) -" Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the follow" We tested the exact same stored procedures on SQL2019 System A and everything worked as expected. But it gives errors when we test on the SQL SERVER 2019 System B. SQL Server A and SQL Server B are the same version, 2019 but something is causing these jobs to fail. I’m not sure what to do next. Any thoughts/suggestions would be greatly appreciated. Thanks.Using SSIS Expression to build query to run on Oracle source
I am trying to build a query to run on oracle source by putting it in a variable, I am pulling max of date into a variablevarChildpkgMaxDt(e.g.2024-08-10 17:21:04.670 ) from SQL server target table. I need to build a query to run on oracle source. I have used datetime as datatype forvarChildpkgMaxDt to fetch from sqlserver in parent pkg and passing this as a parameter to child pkg. I created avarCpkgQuery variable as string and coded as below, the out put I am getting date, will this be the right way to execute this query in oracle I am using oledb as source for oracle I also want to ensure that thevarChildpkgMaxDt is properly compared in oracle with NVL(REVIEWDATE,CREATED) as this two fields in oracle are date with time stamp up till 3mill sec (2024-08-10 17:21:04.670) "SELECT * FROM dbo.virDocument WHERE NVL(REVIEWDATE,CREATED) > '" + (DT_WSTR, 50)(DT_DBTIMESTAMP2,3) @[User::varChildPkgMaxDt] + "'" Was able to remove the err, and now with above change I am getting '2024-08-11 21:00:43.000' do I have to use to_date or to_char for oracle to consider this as date and compare it ? Using oracle 19 C source, VS 2017 SSDT & SQL Server 2016
Login failed for user ''. ClientConnectionId:dad1cf40-fedd-4779-a402-d018ddd61d80
I am passing user in connection details like this but gettingLogin failed for user ''. ClientConnectionId:dad1cf40-fedd-4779-a402-d018ddd61d80 SQLServerDataSource ds = new SQLServerDataSource(); ds.setServerName(""); // Replace with your server name ds.setDatabaseName(""); // Replace with your database ds.setUser("**********");AWS S3 to SQL Server
I have a file on Amazon S3 that updates daily, and it's in SQL format. With these options, can I select a specific database to create and insert all the data into it in SQL Server? Essentially, I'm asking if I can transfer data from Amazon S3 to SQL Server and, once imported, run SQL queries directly on the SQL Server?
