I have defined in my DTS package several date Global Variables, these hold dates in various formats…
10 years, 4 months ago
Hired a solid tech with a great Oracle development background but need him to do Sql Server develop…
10 years, 5 months ago
We have 4 SQL Server 2000 jobs in production which uses DTS packages to pull data from Oracle. Thes…
10 years, 7 months ago
I have to make a connection to a Oracle DB 11g with a DTS. I add the connection settings in my …
11 years ago
By: Gift Peddie
I am using Weblogic 8.1 and Oracle 9i. I simply want to insert a CLOB into an Oracle
11 years, 2 months ago
My DTS have 5 parallel transfer data from sql db to oracle db at the same time, it have come up…
I have to migrate stored procedure created in sql server to ORACLE 10g.
I done with searchi…
In oracle I use this query to format the date field. chg_dt is a date field in addchg ta…
11 years, 3 months ago
By: Jeff Moden
I've been handed a backup of an Oracle DB.
We need to get that data into a SQL Server DB.
By: Nice Marmot
Hi all, please help if anyone can, I am sure here are masters 🙂 i create linked server to access…
11 years, 5 months ago
By: Steve Jones - SSC Editor
I'm doing some work in Oracle on date ranges, and have a calendar table with Activity_date. I'd…
i am trying to save the output of a query to a delimted text file with comma as delimter.
if a colu…
I need to know if it is possible to use openquery within a statement to execute the alter sessio…
I have a table which allows for storing notes about a client. One field is ntext(8000), where the u…
11 years, 7 months ago
This is my scenario.. I need to synchronize data from oracle server to MSSQL Server 2000, …
By: Vijaya Kadiyala
Viewing 15 topics - 16 through 30 (of 47 total)
You must be logged in to create new topics.