Archived Months
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
all groups > sql server dts > september 2006 > threads for september 29 - 30, 2006

Filter by week: 1 2 3 4 5

Missing Edit Features for DTS200 Packages in SQL Server 2005
Posted by Rick Brandt at 9/30/2006 12:34:01 PM
We have SQL Server 2005 and have installed the "add-in" that allows us to edit DTS2000 packages. However there seem to be two areas that were available in SQL Server 2000 that are not available in 2005 using the add-in. First off there seems to be no way to access the logging of the DTS2000 ...more >>


parameter driven DTS
Posted by Senthilkumar at 9/29/2006 10:13:51 PM
Hello to all, I am trying to learn the DTS one step at a time. I want to execute a DTS package using .Net. I got the idea from one of the posts here with the sub: Executing a DTS Package from VB.NET forms . It works fine when all the rows of a table are exported. Based on this, i used a p...more >>

Hung SSIS package is hanging my database
Posted by Hasan Quadri at 9/29/2006 4:55:01 PM
I have an SSIS package that recently hung in the middle of execution. It was in the middle of a ReadCommitted transaction that is accessing one database. During this time, all other SQL queries to this database hang. If I stop the SSIS package, everything works fine. This package has been ...more >>

DTS export to Excel with VB
Posted by andree_noel NO[at]SPAM yahoo.ca at 9/29/2006 2:38:10 PM
Hi, I have been reading all day trying to figure out this one and I can't find out why I am having this issue.... I have created a DTS package that export a SQL statement to Excel. The package runs perfectly in Entreprise Manager, however, when I run the package in VB, I received the follow...more >>

SQL Server To Oracle
Posted by biano.brito NO[at]SPAM gmail.com at 9/29/2006 9:53:37 AM
I need to update a table in the oracle with data that came from the SQL Server but I cant delete all the lines in the oracle I need to check if the line doenst exist in the destination table and then append this line. I know how to do it using transact-sql when the source table and the destin...more >>

SSIS Oracle error on an execute of PL/SQL procedure
Posted by vnapoli at 9/29/2006 9:20:02 AM
I need to extract data from an Oracle 10g database to SQL server 2005 data mart using a pl/sql procedure to do the extract from the source system. I can run PL/SQL selects and create statements from SSIS to an Oracle 10g database using the MS OLE DB provider for Oracle. I cannot get an ...more >>

Transaction support through firewall.
Posted by Willy S at 9/29/2006 2:16:01 AM
Hi, Is it possible to get transaction support between two ms-sql servers (ms-sql 8.0) on windows 2003 servers, on different nettworks with firewall between - and only one way traffic on specific ports allowed? Thanks, Willy ...more >>

What is the SQL Server 2005 CTP
Posted by karenmiddleol NO[at]SPAM yahoo.com at 9/29/2006 1:20:47 AM
I have a MSDN SQL Server 2005 Developer edition disk called as SQL Server 2005 CTP what is this CD ? is it the 2005 beta CD please confirm. Is it OK to install from this disk. Thanks Karen ...more >>




DevelopmentNow Blog