|
|
|
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 Partitioned view can not be updated Posted by Mike Torry at 6/30/2004 6:56:01 PM When try to update partitioned view, I get error: The view cannot be updated because its disallowed construct.
Why this happen? How to fix it?
Thanks for reply.
-Mike Torry...more >>
Import Performance Monitor file (TSV) Posted by Mike P. at 6/30/2004 3:30:00 PM
I am trying to import the performance monitor file (TSV)
into a SQL Server table. The performance monitor file is
in the TSV format.
When I try to import the data into the table listed below
I received the following error:
The number of failing rows exceeds the maximum specified
tran...more >>
How to: define and run a DTS package with connections as passed in arguments Posted by thegriff at 6/30/2004 3:13:32 PM I have a simple dts task. I need to update tables from a
source_server to a target_server.
Task: Drop table from target_server then copy table from
source_server to target_server.
Problem:
I want to be able to pass in the source_server and
target_server names as arguments.
How can I d...more >>
Newbie to DTS - could use some help Posted by Jesse O at 6/30/2004 2:45:14 PM I have a single table called customer, which has new records added daily and
also existing records being modified daily.
I'd like to bring the table over once a day after midnight, however I'm
running into a problem since there are two things I'd like to do, insert
records and update records....more >>
DTSrun with variable Posted by Sumbody at 6/30/2004 12:55:22 PM Hi All,
I finally got the DTS run to work with my new package thanks to Allan
Mitchell.... Now my question is this:
How do I pass the Dtsrun command line a variable?
EXEC xp_cmdshell 'dtsrun /Ssomesql /Usa /Ppass /NTEST /AMyVar:8=Mydata'
The above line works great as long as I hard c...more >>
DTS Workflow Question Posted by Kirk at 6/30/2004 12:09:02 PM I am using SQL Server 2000 and I am writing a DTS package that loops through a recordset and calls another package which does some work based upon passed values. It works and loops great unless the called package fails (which it can since it is connecting to an external server). What I want to do is...more >>
Error setting global variable in DTS ExecuteSQL Posted by ED P at 6/30/2004 11:26:10 AM I'm relatively new to DTS and am having what seems like a
very basic problem. I have simplified what I am trying
to do down to the following:
I create a global variable called gvRosterID as an int
with a default value of 10. Then I create a connection
and then and an associated ExecuteS...more >>
DTS Non-GUI install? Posted by FLX at 6/30/2004 10:55:17 AM I need install DTS package prpgammatically, without using Enterprise
Manager.
Is it possible to generate script for an existing DTS package and install it
on another server using this script?
If not, is there any utility that will allow me to do it? Just like dtsrun?
I know I can use dtsrun...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Generate script for DTS package? Posted by FLX at 6/30/2004 10:50:19 AM 1. Is it possible to generate the install script for a DTS package and
install it on another server by running the scripts generated, just like
creating tables, stored procedures?
2. I know I can use "dtsrun" to execute a DTS package saved as a
COM-structured storage file. Is there any similar...more >>
"Identity column does not allow nulls" Posted by dan at 6/30/2004 8:15:02 AM SQL Server 2000 on Windows XP.
I try to copy data from an Excel file to a table using a DTS Transformation
Task.
The PK of the table is CompanyID, declared int and identity.
In Transform Data Task Properties | Options, "Enable identity insert" is
checked.
However, the transformation fails wi...more >>
Transfer Master / Detail Data (adding with new identity value) Posted by redinblack NO[at]SPAM zworg.com at 6/30/2004 12:48:45 AM Salute,
Consider this scenario :
I have a master/detail database,
and another database with the same schema but different data.
Now, how can I ADD the master/detail data from the second DB
to the first one ? how can I resolve the identity conflict ?
If I...more >>
DTS Package variable Posted by DJohnson at 6/29/2004 4:18:31 PM Hi All and tia for your help.
I need to create a DTS package that can accept a parameter... The
package will be exicuted from stored proc or T-SQL statement. I am thinking
dtsrun.
My question is how would I create a package that expects a parameter, then
how would I call it?
The para...more >>
cross database query in active x script Posted by Chris at 6/29/2004 1:35:02 PM Hi,
I have an active x script in a DTS package.
It has access 2 to global variables in the package.
sql = "UPDATE tblplanlines SET tblplanlines.description = mastermap.dbo.tblstppdesc from tblplanlines INNER JOIN " & _
"mastermap.dbo.tblstppdesc ON tblPlanlines.PPLAN = mastermap.dbo....more >>
Data Extraction for a datamart Posted by Joe Mong at 6/29/2004 1:33:59 PM I'm extracting data into SQL Server 2000 from Progress 9.1.
Doing it serially is too slow. I tried to multithreading the extract
process but ended up with less data without any error message. Is there
a possible way of speeding up my extraction without losing data?
*** Sent via Devdex htt...more >>
Importing a specific Excel Sheet From a DTS Package Posted by Thomas at 6/29/2004 10:10:01 AM Hey All,
I am trying to figure out how to Import a specific Excel sheet in an ActiveX Script
set conTextFile = pkg.Connections("Microsoft Excel 97-2000")
conTextFile.DataSource = DTSGlobalVariables("gv_FileFullName").Value
DTSGlobalVariables("gv_sheet").Value = GetSheet()
But i don't kno...more >>
Import Text Files Posted by shenshiji NO[at]SPAM hotmail.com at 6/29/2004 9:44:20 AM I am trying to import a text file to a table in SQL
Server. It looks normal at the beginning. After I
chose "Fixed Field" - File type: ANSI, Row Delimiter: {CR}
{LF}, then click Next, it became misAligned. I could not
continue import. I tried different Row Delimiter, none of
them workin...more >>
Output with todays date Posted by Anup at 6/29/2004 9:28:13 AM I want to create an excel file through a DTS and stored procedure and the
file name should be named as todays date.
Anyone have any idea where do i put it or methods to do it.
Thanks in advance
...more >>
DTS Transactions Posted by GayeF at 6/29/2004 3:30:02 AM Hi,
I have a database with a number of temporary tables. The data in these temporary tables need to be transferred into tables in the same database. There are 5 transformations in all. I need to use transactions in the DTS job becasue if one transform task fails then I need to rollback all inserts...more >>
bcp and triggers Posted by Systemspecialist at 6/29/2004 2:07:01 AM Hi all,
I have SQL2000 and i try to load data from text file with bcp. Everything works fine, but triggers didn' t fire. I don;t knouw why. When i try to insert data from query analyzer, trigger fired. So, does anybody know , where can be problem?
Thanks...more >>
Open Access DB & Run Macro - How To? Posted by Pegasus at 6/29/2004 1:45:44 AM I need to be able to Open an MSAccess 2000 database then
run a macro at a scheduled time.
I think the best way to do this is through a scheduled DTS
package using an ActiveX script but I'm a novice with VB
and I just cannot work out the code required.
Is there someone out there who can h...more >>
DTS data turns into null Posted by JJ Wang at 6/29/2004 1:02:55 AM hi,
I have a sql server 2000 DTS package, that selecting
yesterday's data from one of our vendors database
(Advantage platform) into our sql server 2000 db, daily
process.
my select query is like this:
SELECT *
FROM vendor_table
WHERE (DATE = { fn CURDATE() } - 1)
Advantage don...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |