Do you have to run the DTS package using VB.net? Can you just run DTS package by itselft ?  DTS package can pass parameter.

I don't know what do you do in your oracle procedure.  If it is just a query and update statement, then you can use DTS package to run the query...

Are you using transform data task to do the transfer data ?  If you do, then when you click on the tab 'Transformation' - if it already has a link,...

Why can't you run the procedure in Oracle? 

Is there any relationship between table1 and table2, table3 and table4.  It seems to me the SystemUser_id, Buyer_ID, supplier_ID in table1 should be related to the same field name in Table1.

In PL/SQL when you want to exec a procedure, the syntax is

Begin

ProcedureName();

End

It is different from SQL Server.

I did some research to exec Oracle procedure in DTS.  I don't think you...

There is no system procedure to get size of the table, it has system procedure to get size of the file or file group.

But you can calculate the size of...

To get the size of the database

sp_helpdb @dbname= 'databaseName'

You are right, I am a developing / application DBA not the administrative type.  But my job title is not DBA.  How can I put DBA in the resume even...

To transfer the jobs, there is another way is using DTS package, the is a task called "Transfer Jobs Task", you specify the source server and destination server and select...

For SQL jobs, you have to use script. You have to script out each job and put it in production.  For DTS package, open the DTS package, click on save...

If you want to find out all the columns in a table, use the following

CREATE TABLE #conv_tables_fields (

 TABLE_QUALIFIER NVARCHAR (128) NULL ,

 TABLE_OWNER NVARCHAR (128) NULL ,

 TABLE_NAME NVARCHAR (128) NULL ,

 COLUMN_NAME...

We have the same problem, so first before the update, we find out which user is using the database and kill the session.  If all your users under one role...

In oracle, if you want to convert the date to character format, you don't use convert.  In the SQL task, you have to convert the date to character format,

the...

This worked if you have window authenication sign on in the server, otherwise you need to put in login name and password.

EXEC master..xp_cmdshell 'DTSRun /S "ServerName" /E /N "PackageName"  /W "0" '