OT: dts package password recovery HELP!!!

2005-09-30 Thread Tony
hi there. your favorite numbskull has forgotten a password for a DTS package that he made, and now needs to alter it just a bit :) any idea how to recover? i googled and didnt come up with anything i could get into and read without paying :( help if ya can. thanks! -- tony Tony Weeg

Re: OT: dts package password recovery HELP!!!

2005-09-30 Thread Tony
found it. numbskull is back in action. tw On 9/30/05, Tony [EMAIL PROTECTED] wrote: hi there. your favorite numbskull has forgotten a password for a DTS package that he made, and now needs to alter it just a bit :) any idea how to recover? i googled and didnt come up with anything i

RE: OT: dts package password recovery HELP!!!

2005-09-30 Thread Emmet McGovern
Crap... You didn't give me a chance to point my finger and laugh at you. Oh well, maybe next time. ;) -e -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Friday, September 30, 2005 9:33 AM To: CF-Talk Subject: Re: OT: dts package password recovery HELP!!! found

Re: OT: dts package password recovery HELP!!!

2005-09-30 Thread Tony
:33 AM To: CF-Talk Subject: Re: OT: dts package password recovery HELP!!! found it. numbskull is back in action. tw On 9/30/05, Tony [EMAIL PROTECTED] wrote: hi there. your favorite numbskull has forgotten a password for a DTS package that he made, and now needs to alter it just

OT-DTS

2003-03-27 Thread Greg Luce
Anyone ever used DTS to migrate data from MS Access to MySQL? I've installed the MyODBC driver and created an ODBC connection then I'm using DTS to export the data from the specified access db to the mysql db. It creates all tables, but when inserting Memo type columns (I think) it gives this

RE: OT-DTS

2003-03-27 Thread Robertson-Ravo, Neil (RX)
This is a mySQL problem methinks and it would appear to be self-explanatory. -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 14:29 To: CF-Talk Subject: OT-DTS Anyone ever used DTS to migrate data from MS Access to MySQL? I've installed the MyODBC driver

Re: OT-DTS

2003-03-27 Thread John Paul Ashenfelter
, March 27, 2003 9:35 AM Subject: RE: OT-DTS This is a mySQL problem methinks and it would appear to be self-explanatory. -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 14:29 To: CF-Talk Subject: OT-DTS Anyone ever used DTS to migrate data from

RE: OT-DTS

2003-03-27 Thread S . Isaac Dealey
This is a mySQL problem methinks and it would appear to be self-explanatory. -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 14:29 To: CF-Talk Subject: OT-DTS Anyone ever used DTS to migrate data from MS Access to MySQL? I've installed the MyODBC

OT - DTS and Oracle

2003-02-05 Thread erica . lomax
I'm using DTS to copy data from a SQL Server database to an Oracle database. That works fine. I am them attempting to run an Oracle Stored Procedure to update my data. I can execute the stored procedure from SQLPLUS and can call it from a cfm page (CFMX) with no errors. I execute the sp

OT: DTS Export Wizard

2002-10-09 Thread Brook
Hello, I may have just done something stupid. I was attempting to transfer ONE table from a temp DB to a live database using the transfer objects DTS Export Wizard. I got to the screen that asks if you want to transfer all objects and I de selected that checkbox. BUT, I forgot to select the

Re: WAY OT DTS PACKAGE

2002-05-17 Thread cf refactoring
SQL 2000's DTS package allows you to run any Win32 process or batch file via a Execute Process Task. You can use this to run the unzip program before you import the data. I don't think this is available for SQL 7. --- Joshua Tipton [EMAIL PROTECTED] wrote: Does anyone know via DTS how to open a

WAY OT DTS PACKAGE

2002-05-16 Thread Joshua Tipton
Does anyone know via DTS how to open a zip file so that I can attach to a dbf file that is in the zip file? Josh __ Structure your ColdFusion code with Fusebox. Get the official book at

Re: WAY OT DTS PACKAGE

2002-05-16 Thread Jon Hall
From within the DTS Designer choose the Execute Process Task, and run an unzip program on your zip. jon - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 10:18 AM Subject: WAY OT DTS PACKAGE Does anyone know via DTS

ot dts help

2001-09-10 Thread Joshua Tipton
I am pulling from an oracle database and need to do a lookup on the sql server. How can I do this been working on this one all weekend please help. SELECT PROBLEM_ID, SEVERITY, USER_ID, PROBLEM_CODE, SYSTEM, CLOSE_DATE, CLOSE_TIME, FIRST_LOCATION_ID, FIRST_CONTACT_ID, LOCATION_ID, CALLER_ID,

RE: ot dts help

2001-09-10 Thread Peter Stolz
, SESSION_USER_ID FROM oracle_link...PROBLEM_VIEW WHERE (userid in (sql table) HTH, P. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 9:22 AM To: CF-Talk Subject: ot dts help I am pulling from an oracle database and need to do