|
|
|
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 can not run dts on sql server 2005 Posted by Amir Steta at 6/28/2007 11:30:01 PM I have sql server 2005 standard edition version 9.00.3054.00 (service pack 2
installed). Recently, I have run sql server hotfixes deliveres over our
organizational sus server. Although, it was run at least 6 times update could
not be finished. Some errors were reported.
Now I can not run DTS...more >>
SSIS: how to show the current status in webform or winform? Posted by Bob Yang at 6/28/2007 2:42:44 PM I plan to create a windows form or web form to triger SSIS to do data
inserting.
I can see the current status in "SSIS"->" data flow", but how can I
make them apper in webform or windows form? or anyway to access that
information? The web form or winform may update every 3 seconds and
somethi...more >>
Looping query for parameters Posted by skicam07 NO[at]SPAM gmail.com at 6/28/2007 2:39:07 PM I am building a DTS package that will transfer data from an Oracle
server to a local MSSQL server. I have the data transformation task
almost complete and working well, but the SQL query still needs to
take a "batch" string parameter.
I need to loop the transformation task each time for howev...more >>
Foreach Loop in DTS on SQL 2000 Posted by Yehuda Katz at 6/28/2007 11:37:46 AM I am trying to download product data from a supplier to put into an
online store.
The supplier gives me a list of warehouses, and i can only download
from one at a time.
I created a DTS script to download the warehouse specificed in
DTSGlobalVariable("Warehouse"), but i can not figure out how...more >>
How could I permit another user to change my DTS? Posted by Geri Reshef at 6/28/2007 7:20:43 AM When another user try to work with my DTS he receives the following message:
"only the owner of dts package 'MyDTS' or a member of the sysadmin role may
drop it or any of its versions"
How could I let him work with it without making him a Sysadmin? (For
example- how could I change the owner of...more >>
Check Table Exist before Drop Posted by IronSights at 6/28/2007 5:54:10 AM I have a DTS package that connects to an Oracle Database and pulls some
information from it with a SELECT query. I then take the results and place
them in a table on the local SQL server.
The DTS package has been wroknig fine for over a year, but there was an over
sight on my part. I had no...more >>
SSIS Newbie Posted by Ed at 6/28/2007 3:14:15 AM Hi All,
First of all is this the correct group for SSIS questions (I did not see
an SSIS one)?
Secondly my beginners question,
I have Table A and B in my database, would like to process all records
in Table A and do either an update or insert in Table B depending on
wether or not the ...more >>
WebService Task and session enabled methods in SSIS Posted by Mogens Nielsen - WM-Data A/S at 6/28/2007 1:38:00 AM Hi,
I'm currently setting up a SSIS package.
The purpose is to read a comma-separated text file and call a webservice
with the values from the text file using the webservice task in SSIS.
The webservice methods are session-enabled that is, I call an
Initialize-method, then the Add-method for ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
FTP Step Fails Posted by James at 6/27/2007 7:42:04 AM I have a dts package that works fine when I execute it directly. However when
I schedule a job to run it it fails on the 1st step. The first step ftp's a
file from one network folder to another. If it is a rights issue what account
do I need to give the rights to, and what rights should the ac...more >>
DTS pacakges causing low memory Posted by Simon at 6/27/2007 6:56:01 AM I have written a series of DTS packages which move data from a FOX database
onto SQL2000. The packages work fine for small tables. However when I run a
package that looks at a large table in FOX then I get an unspecified error in
the DTS designer. Before the error comes up I get a message sayi...more >>
Execute DTS 2000 Package in SQL 2005 fails Posted by Coop at 6/25/2007 5:25:00 PM Hi. I have a simple DTS package that runs fine on a SQL 2000 server. But
when I try to run it from within a SSIS parent package, it fails with:
SSIS package "CopyFundWareTables.dtsx" starting.
Error: 0x0 at Execute DTS 2000 Package Task:
System.Runtime.InteropServices.COMException (0x80040...more >>
Dynamic Properties Task in .NET Posted by pearsons_11114 at 6/24/2007 8:26:03 PM When retrieving a dynamic properties task in .NET the assignments collection
is set to null. Is this a known bug, or is there something special that needs
to be done to get the RCW to load this collection? Thx. ...more >>
Syntax and howto on 'dropping and recreating index' before and after a transformdata task Posted by rshivaraman NO[at]SPAM gmail.com at 6/22/2007 8:24:36 AM Hi :
For performance reasons, it has been identified that dropping an index
before loading a table and then recreating it after loading, is
beneficial.
I would like to do this, but cannot get the syntax straight.
If you have done it, please share your syntax
1. truncate tableA
2. drop ind...more >>
excel worksheet renaming Posted by gremlin321 at 6/22/2007 7:58:01 AM i have a package that picks up xls file from a specific directory, puts it
into working directory. here is the problem. all files droped will have
worksheets named diferently in order for me to read it i need to have the
same name my excel read task is trying to read the sheet. i use a simple ...more >>
DTS Package(s) fails when scheduled Posted by pltyler at 6/22/2007 4:03:00 AM Hello, hope somebody can help me out!
In 2005 I created some data views on SQL Server 2000 and used the DTS Export
Wizard to set up 4
local packages which were scheduled as Jobs to run on a daily basis. These
packages transformed SQL
data into an MS Access database residing on the ser...more >>
SSIS in SQL Server 2005 Posted by John Jayaseelan at 6/22/2007 1:44:09 AM Good Morning,
SSIS in SQL Server 2005
I tried to assign a value stored in a variable to the flat file source
connection using a script task as below and received the following error
message.
Dts.Connections("REJECTION_FILE").ConnectionString =
Dts.Variables("gv_Extract_file").Value.ToStr...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |