|
|
|
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 Versioning and Deployment Posted by MTsang987 at 1/31/2005 2:43:02 PM Hi,
I have my dts package as a structured storage file. I plan to save it to my
server for scheduling. Is there any way that I can remove the previous
versions from the file to make it smaller before I save it on the server?
Thanx...more >>
SQL Server 2000 DTS Designer Error in the DLL Posted by Eric Manko at 1/31/2005 2:21:04 PM When trying to open the DTS Designer, I get an error stating Error in the
DLL. It will then open, but when I save, I get the same error. Also, I cannot
open any DTS tasks previously created from another machine.
I have tried reregistering DLLs, and also removing and readding, SQL Server
2000...more >>
Sql replication and archive database Posted by willatkins NO[at]SPAM gmail.com at 1/31/2005 10:48:29 AM Hi,
Our software uses a SQL database and is designed to get rid of data
after a specified amount of time to maintain performance.
We would like to be able to keep that data in another database along
with the up date information for reporting purposes, while leaving the
main database to serv...more >>
Add a header to a Text File ("Destination") Posted by LP at 1/31/2005 10:27:06 AM Hello All,
I'm exporting a SQL table to a text file and want to add a little bit of
header information. Is the best option ActiveX Script using FSO?
Any thoughts.
Thanks,
LP...more >>
Problem With Scheduled DTS Package Posted by DeltaBankUser at 1/31/2005 10:18:04 AM SQL Server Agent reports the following error when attempting to execute a
scheduled DTS pacakge:
---------------------------------------------------------------------------------------
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
...more >>
How to link table from another DB Posted by Mike at 1/31/2005 10:16:29 AM Hi all,
I have a DB on SQL Server and I need to create a table that is a link to a
table inside another MsAccess DB. How can I do this?
I'd reply the same behaviour like I do in MsAccess when I run the command
"Link table".
Any help is appreciated.
Regard,
Mike....more >>
Adding to a DTS PAckage Posted by jaylou at 1/31/2005 7:35:02 AM Hi All,
I have a DTS Packag that copies tables from one server to another. Is there
a way to add a new table to this package? I have not been able to figure
this out with the help of BOL.
TIA,
Joe...more >>
Newbee DTS Question Posted by jj at 1/30/2005 3:53:44 PM Hello,
I have 3 sql servers running.
lets call them sql server 1,2 and 3
all 3 servers have a table with the following columns
ID, Location, transaction id.
server 1 and 2 collect data and populate thier tables....i would like server
3 to get the data from the tables on server 1 and...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Hyperion Essbase Posted by John Baker at 1/29/2005 7:27:38 PM Can DTS load data into Hyperion's Essbase?
I know I can output a text file and then call a .bat file that uses an Essbase load command, but I was wondering if DTS
supported a direct connection.
--
To Email Me, ROT13 My Shown Email Address
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |