|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Newbie Posted by Chakra at 9/30/2005 4:07:25 PM Can a DTS package, developed though a DTS wizard ,be wrapped into a Stored
procedure ? Would it make sense to do so at all , since the DTS itself is a
database object , just like a Stored procedure ?
The reason i am asking is because i have to update one table of one SQL
database from anothe...more >>
Main = DTSTaskExecResult_Failure does not raise an error Posted by SJM at 9/30/2005 2:07:00 PM
Hello.
I am experiencing an odd event.
I use the following to return the failure of a step/task:
Main = DTSTaskExecResult_Failure
However, the package just continues to run as if nothing happened. None
of the OnFailure workflow is used.
I have tried turning Fail package on first ...more >>
DTS package that imports a CSV file from an URL Posted by SivaRCherukupally at 9/30/2005 12:13:02 PM I need to be able to create a DTS package that imports a CSV file which is
loated at an URL. If I put the URL address in Text file address it brings the
csv file to a local drive. And whe I run it again it bring only local file
and doesnot bring new file from the URL
Please help point me to...more >>
Plans for DTS Support in SQL 2000 64-bit Posted by Bob Churchfield at 9/30/2005 6:28:04 AM Does anyone know if Microsoft plans to ever support DTS in SQL 2000 64-bit
edition?...more >>
Error handling of file in use Posted by Stijn Verrept at 9/30/2005 5:08:48 AM I read import a text file and need to delete it afterwards. I don't
know any VBScript so I had to look up some code to delete it. I found
the following:
'**********************************************************************
' Visual Basic ActiveX Script
'**********************************...more >>
SQL DTS The way I worked Posted by jsfromynr at 9/30/2005 4:13:19 AM Hello All,
First when using data Transform task I selected all the columns
(Source and destination) then I Click on new Transformation and choose
ActiveX Script .
Then I Click on the Properties to see the VBScript Generated
..Later I realised that it is combersome to map each and ev...more >>
Updating records Posted by M4TT at 9/30/2005 3:07:02 AM Hi all,
I need to update records in a sql table based on records in an oracle table.
The update needs to be done where OracleTable.C_Ref = SqlTable.C_Ref. I am
unable to get the databases linked and there are 14 million records in the
oracle table and 200,000 records in the sql table. Can...more >>
DTS FTP Task: File disappears after DL! Posted by jrazor247 at 9/29/2005 8:00:54 PM Hi,
creating FTP task to download file. The file name is determined by
ActiveX script before since the file name is based on the date. It
connects, downloads the entire file (you can see file size increasing
if you refresh in explorer), and then the file vanishes after the task
is complete....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Rundts from QA is giving "Access Deniad" Posted by sasachi sachi sachi at 9/29/2005 3:18:33 PM
Hi everybody
I created a dts package to transfer data from a fixed width text file
located on a sharable folder in a central server. When I run the dts
package from DTS designer the package gets executed successfully where
as when I run the same dts package from query analyzer using xp_Cmd...more >>
dts quick to access 97 but slow to access 2003 Posted by Andrew Brill at 9/29/2005 10:51:38 AM There are 3 machines involved, the sql server, a file server holding the
access databases and a client installation of sql server.
We have dts packages designed to export data from the sql server to the
access databases. These were created while the databases were in 97 format
and were pre...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |