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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
|