DTS Permissions

Assuming you can open the package, simply click on
package in the upper left and save as...
>--Original Message--
>We have a DTS package that was created and saved by
>someone who is no longer with the company. How can we
>convert this DTS package to a valid ID? Thanks
>.
>try sp_reassign_dtspackageowner
Olu Adedeji
"Peter Cwik" <anonymous@.discussions.microsoft.com> wrote in message
news:155bb01c3fa49$ecf965f0$a601280a@.phx
.gbl...
> Assuming you can open the package, simply click on
> package in the upper left and save as...

DTS Package

Hi:
I am simply trying to use vbscript in a package to sort through and find
records.
I cannot seem to get the regular vbscript code to run properly, it either
doesn't parse properly, or it tells me I am using an incorrect recordset.?
Please help.
Thank you ,
Kyle
Unfortunately that doesn't give us enough information to
help you out. Could you post the VB Script code you are
using?
-Sue
On Mon, 12 Jul 2004 07:49:05 -0400, "Kyle McAdam"
<kyle.mcadam@.sympatico.ca> wrote:

>Hi:
>I am simply trying to use vbscript in a package to sort through and find
>records.
>I cannot seem to get the regular vbscript code to run properly, it either
>doesn't parse properly, or it tells me I am using an incorrect recordset.?
>Please help.
>Thank you ,
>Kyle
>
|||Kyle,
Do please check your system clock.
Dejan Sarka
"Kyle McAdam" <kyle.mcadam@.sympatico.ca> wrote in message
news:4booc.44840$FH5.1018229@.news20.bellglobal.com ...
> Hi:
> I am simply trying to use vbscript in a package to sort through and find
> records.
> I cannot seem to get the regular vbscript code to run properly, it either
> doesn't parse properly, or it tells me I am using an incorrect recordset.?
> Please help.
> Thank you ,
> Kyle
>
|||Can you post the code and the error messages you are receiving?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Kyle McAdam" <kyle.mcadam@.sympatico.ca> wrote in message
news:4booc.44840$FH5.1018229@.news20.bellglobal.com ...
Hi:
I am simply trying to use vbscript in a package to sort through and find
records.
I cannot seem to get the regular vbscript code to run properly, it either
doesn't parse properly, or it tells me I am using an incorrect recordset.?
Please help.
Thank you ,
Kyle

DTS Oracle Connection - Importing Data

I have SQL Server 2000 and am using DTS to simply import some data located on a remote Oracle DB.

If I have the following information:

TNS Name:

 ThisApp.world
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS =
 (COMMUNITY = tcpxxx.world)
 (PROTOCOL = TCP)
 (Host = SomeHost)
 (Port = 1234)
 )
 )
 (CONNECT_DATA =
 (SID = App)
 (GLOBAL_NAME = ThisApp.world)
 )
 )

And I also have the name of the Table.

Using the DTS Wizard, on the Choose a Data Source screen, I pick the following:

Data Source: Microsoft ODBC Drive for Oracle
Server:
Username:
Password:

I don't know what I should put into the other fields, given what I have above, i.e. what to put in for Server, Username, and Password! Or should I use a different procedure to import this Oracle data? I am almost positive I was not supplied the username/password. I was told I could connect given the above TNS information. What do you all recommned?

Your assistance will be greatly appreciated.Given the above information, how can I use Server Explorer in VS.NET 2002? It still prompts me for a Username/Password, which I do not have.

Please help anyone.