How To Add New Values In SQL 2000 DTS Enumeration Task

Apr 10, 2008

Hi. I am using SQL 2000 and DTS package to transfer data between two databases. In my DTS package, I need to create a enumeration task with a enumeration data task. However when I tried to add enumeration values, I cannot find any ways to create new values by right click to select from drop down menu or use Control + New in the enumeration properties. Could anyone point out how I can add new values in DTS Enumeration type.


Thanks

View 1 Replies


ADVERTISEMENT

Enumeration In SQL Server?

May 31, 2006

Is there "enumerate values" in SQL server? I know that VB.Net has enumeration. If there is enumeration in SQL server, how to do that?
Thanks.

View 11 Replies View Related

ResultSetOptions Enumeration ?

Jul 18, 2007

While using SQLCE 3.0, I need to insert ~20000 records. I using the following code :


Code Snippet

cmd.CommandText = "M_Reclass";

cmd.CommandType = CommandType.TableDirect;

SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Updatable | ResultSetOptions.Scrollable);

SqlCeUpdatableRecord rec = rs.CreateRecord();

while ((strInput = srFile.ReadLine()) != null)

{

if (strInput.Trim().Equals(""))

continue;

intCount = intCount + 1;

arInfo = fileIO.SplitRow(strInput, fldSep);

try

{

// GKH 2007/07/17 : Perform check, but sacrifice speed

//if (arInfo.Length >= 5)

//{

rec.SetString(0, arInfo[0]);

rec.SetString(1, arInfo[1]);

rec.SetString(2, arInfo[2]);

rec.SetString(3, arInfo[3]);

rec.SetString(4, arInfo[4]);

rs.Insert(rec);

ProgressText("Processing " + Para.RECLASS_IMP_FILE + ": " + intCount + " records(s)");

//}

}

catch (Exception ex)

{

throw new Exception("Record " + intCount + " cannot be imported : ", ex);

}

}



I did a search on MSDN, I found the option available are:








Code Snippet






Member name
Description


Insensitive
The ResultSet does not detect changes made to the data source.


None
No ResultSet options are specified.


Scrollable
The ResultSet can be scrolled both forward and backward.


Sensitive
The ResultSet detects changes made to the data source.


Updatable
The ResultSet allows updates.



SqlCeResultSet.Scrollable Property : True if the ResultSet is scrollable; otherwise, false.

SqlCeResultSet.Updatable Property : True if the values in the record can be modified; otherwise, false;

SqlCeResultSet.Sensitivity Property :

The sensitivity of the ResultSet indicates whether the ResultSet is aware of changes to the data source. A ResultSet that is sensitive is aware of changes; an insensitive ResultSet is unaware of changes. If no sensitivity is set, the ResultSet is asensitive and will use the optimal configuration based on other settings.The default value is asensitive.





Since I just insert only, does it mean I no need "Scrollable" ( i think insert is mere forward scroll)?

But what about "Updatable" ? which one from SIUD (Select/Insert/Update/Delete) need to use this "Updatable"?

View 3 Replies View Related

Example Illustrating SMO Enumeration Needed.

Jun 5, 2006

I planned to write a VB.NET SMO app enumerating all tables in a given database, all fields in each table, the properties (length, NULL, PK, etc) of each field, and finally store the result in a table. I think that should be quite doable.

But I noticed that the ForEach Loop editor has a SMO enumerator. (I don't know if it can be used to do exactly what I want.) By clicking on the options in the ForEach Loop editor I can get the Enumerator as follows:



Database[@Name='AdventureWorks']/Table[@Name='AWBuildVersion' and @Schema='dbo']/SMOEnumObj[@Name='Columns']/SMOEnumType[@Name='Names']

but it's not clear to me how to work with this thing! ( It must return a collection of items that I access through a variable.) Anyone know of an example illustrating SMO enumeration?



TIA,



Barkingdog

View 1 Replies View Related

For Each Loop Container File Enumeration

Feb 27, 2008



I am trying to move files from one directory to anonther using the For Each Loop Container and a File System Task. However, on the FIRST iteration of the ForEach Loop the variable that I am setting to the 0 index of the For Each Loop is returning me a valid directory with no file ( path only ) from who knows where ????

On the second iteration of the For Each Loop everything works as expected and I get the full path and file name and it iterates through all the files in the directory o.k.

So I have had to put a Hack to skip the fist iteration of the loop and then execute the File Task on the second iteration but I dont see anyone else doing this.

Where in the heck is it getting this odd directory from on the fist iteration ( its not my User varible because I am initializing it to \nowhereofile ). What am I doing wrong?

View 3 Replies View Related

Execute DTS 2000 Package Task. Mischievous Task??

Sep 21, 2006



Hi everyone,

For first time I'm testing this task and surprisingly, when I try "Edit Package" option:


1)The DTS host failed to load or save the package properly
2)The selected package cannot be opened
3)Error HRESULT E_FAIL has been returned from a call to a COM component

But after these messages you can see all the tasks but they haven't name!!

It seem as if RCW mechanism has failed between managed and unmanaged coded-partially.

I don't dare to follow doing more stuff, I don't know if that package is well-loaded or not from there. ?¿

Any guidance or idea about this?

View 5 Replies View Related

Error:Collection Was Modified; Enumeration Operation May Not Execute

Apr 7, 2008

Hi,
This is my save procedure.
Please check and give me some advice.looping is need or not?
i get error "Collection was modified; enumeration operation may not execute"
plz help me.
-------------------------------------------------------------------------------- Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim con As SqlConnectionDim cmd As SqlCommand
Dim da As SqlDataAdapter
Dim userid As String
Try
userid = Request.QueryString("userid")con = New SqlConnection(ConfigurationSettings.AppSettings("strcon"))
' con.ConnectionString = ConfigurationSettings.AppSettings("strcon")
con.Open()cmd = New SqlCommand("dbo.sp_AddAns", con)
cmd.CommandType = CommandType.StoredProcedure
 
 For Each Item As DataListItem In dlAQ.ItemsDim paramid As New SqlParameter("@id", SqlDbType.Int, 4)
paramid.Value = userid.Trim
cmd.Parameters.Add(paramid)Dim paramans As New SqlParameter("@proansw", SqlDbType.NVarChar, 50)
Dim txtbox As New TextBoxtxtbox = CType(Item.FindControl("txtAns"), TextBox)
paramans.Value = txtbox.Text.Trim
cmd.Parameters.Add(paramans)
 Dim paramprodesc As New SqlParameter("@prodesc", SqlDbType.NVarChar, 50)
Dim lbldesc1 As New Labellbldesc1 = CType(Item.FindControl("lbldesc"), Label)
paramprodesc.Value = lbldesc1.Text.Trim
cmd.Parameters.Add(paramprodesc)
 Dim paramproid As New SqlParameter("@proid", SqlDbType.Int, 4)
Dim lblproid1 As New Labellblproid1 = CType(Item.FindControl("lblproid"), Label)
paramproid.Value = lblproid1.Text.Trim
cmd.Parameters.Add(paramproid)Dim paramreso As New SqlParameter("@proreso", SqlDbType.NVarChar, 50)
Dim lblreso1 As New Labellblreso1 = CType(Item.FindControl("lblreso"), Label)
paramreso.Value = lblreso1.Text.Trim
cmd.Parameters.Add(paramreso)Dim paramchk As New SqlParameter("@chk", SqlDbType.Int, 4)
paramchk.Value = "2"
cmd.Parameters.Add(paramchk)
'Dim rowaffected As Integer
cmd.ExecuteNonQuery()
bindData()
 
 
Next Item

View 1 Replies View Related

ForEach File Enumeration With Bulk Insert Problem

Jul 14, 2007

OK, a new package, with a Foreach container enumerating CSV files in a directory.

I create the container pointing it at the directory and retrieving the fully qualified name, and create a variable (called 'CSVFiles') with a package scope, but no value.



Inside the container is a bulk insert task. The destination db/table is set, and the input flat file connection manager for the CSV files is defined with the connection string set to the variable created above.



As it iterates through the files, the variable is correctly set to the next file in the directory (I put a message box in the stream to display the file name/variable). It resembles 'C: empLocation1.csv'.



But when it gets to the bulk insert, I get this error message:



[Bulk Insert Task] Error: The specified connection "CSVFiles" is either not valid, or points to an invalid object. To continue, specify a valid connection.



What's going on here? Can I not use a bulk insert task in the container? Or some other parameter needs to be set?



SQL Server 9.00.3159









View 4 Replies View Related

Change Self Reference Values In A Data Flow Task

May 9, 2006

Hi,

We migrate data from a legacy system to new system using SSIS. The primary key of legacy system is a user-defined sql server which holds alpha-numeric values. The primary key of new system is a big int(sequential numbers).

When we migrate data, we generate a sequential number for each legacy key(the primary key of legacy data) and insert data in to new system tables. The newly generated sequential numbers and the legacy keys are persisted in an intermidiate table for look up operations of child tables.

We are facing problem when we try to migrate tables which has self referring coulumns. For example a table called Employee has a column ManagerKey which refers to Key column of Employee table. We are struck up in defining data flow tasks to replace legacy ManagerKey column values with the new values(sequential values) generated during the migration process.

Please help me to solve this problem.

Regards,

Gopi









View 3 Replies View Related

Custom Task Not Updating Property Values Or Saving.

May 2, 2008

Hi Folks,

I have a task I wrote which does not always update the property value (as seen in the properties pane)
Basically, change something on the form, then update the task host property with:
this.taskHostValue.Properties["Duration"].SetValue(this.taskHostValue, Convert.ToInt32(spnDuration.Value));

Stepping through this, it does exactly what it is supposed to. Having a look at the property value, it confirms it has changed.
Reopening the UI and resetting all the controls returns the expected results.

The package however does not realise it has changed. There is no * next to the package name in the top tabs.
As long as the package thinks it is unchanged, SaveXML does not get called either so the tasks do not persist.

Changing the value on the properties pane works fine though.

The frustrating thing is this is slightly random. Slight in the sense that sometimes it works but most of the time it does not.


The sample code I used was the MS download IncrementTask (Which works BTW) so I can't see it as being a VS / SSIS bug but rather something I am / am not doing. 3 tasks I have written all behave the same. I have to "nudge" them before savign the package.

Any ideas what the problem might be?



TIA


Cheers,
Crispin

View 3 Replies View Related

Script Component Task, Values Such As 000-00-00 To Smalldatetime Field

Jun 15, 2006

From a text file I'm importing date values by a variable.

dFecha = Left(Row.Column21, 4) & "/" & Mid(Row.Column21, 5, 2) & "/" & Right(Row.Column21, 2)

After that I've got values as "0000-00-00" and obviously sql (at target smalldatetime) doesn't support them. How do I for to solve?

If IsDate(dFecha) Then

.Parameters("@FecEnajenacion").Value = dFecha

Else

.Parameters("@FecEnajenacion").Value = vbNull

End If



TIA

View 1 Replies View Related

How To Pass Values To A Stored Procedure Parameters By Using Script Task

Nov 27, 2007



Hi All,

I have One package that it contains one Execute SQL task in that i have placed a Stored procedure .
Now i want to pass values to Stored procedure parameters from a databse table by dynamically .For this i am trying to use " Script task "
How can i pass that table column values to that stores procedure thru using Script Task?

Regards,
Maruthi..

View 3 Replies View Related

Data Flow Task - Have Null Values Take Table Default

Jun 6, 2006

Hi,


I have a data transform from a flat-file to a SQL server database.
Some of the flat-file fields have NULL values. The SQL table I'm
importing into does not allow NULL values in any field, but each field
has a Default value specified.


I need to have it so that if a null value comes across in a field using
the data transform, it takes the table default on import. I could of
sworn I had this working a few days ago, but I get errors now that
state I'm violating table constraints. Has anyone done this before?


Thanks
Jeff

View 5 Replies View Related

Integration Services :: How To Capture Execute Task Values In Table

Jun 19, 2015

How to capture execute sql task results.

Example if the execute sql task runs select statment (select * from table)means , how do i capture into  sql table.

View 10 Replies View Related

Integration Services :: Joining Object Variable Values In Script Task

Jul 23, 2015

I have a object variable named "UserList" which gets populated through execute sql task - stored procedure.I wish to concatenate all the values in "UserList" using ssis script task - in lang vb.Output should be like (User1,User2,User3,....)

View 8 Replies View Related

Default Values Of Columns Not Transferred In SSIS Transfer Objects Task

Sep 6, 2006

I am working on a project that is creating a new application, my area of the project being the migration of data from the old application database, transforming it, and populating the new database.

The transformations to the old data are done in a staging database.

At the end of the process, the staging database ends up with a lot of new applications tables, populated with the migrated legacy data.

We need to move these tables from the staging database to (initially) our test databases, but ultimately what will be the live database.

We have tried using the "Transfer SQL Server Objects Task" in SSIS, but have ran into a problem that a lot of the database tables have default values for columns.

These default values are not brought over.

Example. Tables contain a "GUID" field, which has a default of value of newid()

Right clicking and the table generating the CREATE script generates

[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_tbCRM_Client_GUID] DEFAULT (newid()),

However, the Transfer objects task does not create this default of newid()

Examining the SQL generated by the Import / Export Wizard when investigating this shows that the wizard generates this column as

[GUID] uniqueidentifier NOT NULL

and the column default value is lost.

Is there something i should be setting somewhere to force SSIS to bring these column definitions over correctly?

View 10 Replies View Related

Integration Services :: Adding Values To A Drop Down List In Custom SSIS Task

May 12, 2015

I am writing my first custom SSIS task and I can see that, if I put a public property into the task, I see that property in the standard Properties window. If I add a property of type String, I can put a value in that property, in the task code, and when I instantiate the task in a package, I can see the value I entered.

To try and get a drop down list property in the Properties window, I declared a property of type Combobox, and indeed a drop down list appears in that property.

My problem is trying to get values in that property. I have used the test items:

    Property.Items.add("Fred")
    Property.Items.Add("Jim")

But I do not see the values in the drop down list. All I do see is one item with a value of "(none)".

View 3 Replies View Related

DTS - FTP Task - SQL Server 2000

May 28, 2004

Hi

Could any body tell How to download files from Internet where Source file server is using SFTP (Secure FTP)?

Note: I am able to configure and download files from Internet where Source file server is configured for FTP using FTP task in DTS Package.

Thanks

View 2 Replies View Related

Sql 2000 Dynamic Properties Task

Feb 26, 2001

Hi,
DTS now has a dynamic properties task in sql 2000 which at a first glance is pretty cool. However i do not know if it would sort out a particular issue I have.

I need to have a generic DTS package that pulls data from different locations based on the project selected by a user. The source is a btrieve database
The name of the tables change with the project, so for example the F24 project would have its source table named F24TACT and the IFO source would have its source table named IFOTACT.

I need to be able to dynamically retrieve the table name from a local SQL table and assign this name to the data pump for the data extraction..

I don' t know if this is achievable in DTS. I can retrieve the value into a look up variable but how can i set it at runtime ?

thanks
Tony

View 2 Replies View Related

Error When Trying To Run Execute DTS 2000 Task

Jan 28, 2008

I'm converting a package from DTS to IS. My manager does not want to spend the time re-writing it to make use of the Script task so that's why I'm using a DTS 2000 task which contains some ActiveX.

The tasks themselves run fine when I'm in the designer and click the run button, but when part of the entire package it fails. I search on the error message and nothing comes up.

This is the error message:
Error: System.Runtime.InteropServices.COMException (0x8004043B): Exception from HRESULT: 0x8004043B at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()

I've set them to run on the main thread but that doesn't seem to help.

Any help would be greatly appreciated!

Thank you,

Kelly

View 4 Replies View Related

Execute DTS 2000 Task - Silly Question...

Feb 13, 2006

I must be missing something very simple here but how do you set an inner variable with a value stored in an outer variable, or any other variable?

I've tried various syntaxes used elsewhere to refer to variables without any success, and the help topics have been less than useful for this task.

Thanks,

John

View 1 Replies View Related

Support For Execute DTS 2000 Package Task On Win 64 AMD?

Apr 26, 2006

I have imported a series of SQL 2000 DTS packages to our 64bit AMD SQL 2005 server. I then created SSIS pkgs to run each SQL 2000 package using the Execute DTS 2000 package task. Then I deployed these packages to the Yukon server as well.

I can run these packages when launching them via Integration Services from Management Studio on my workstation, but when I try to run them via a SQL Job or the DTExec command on the server, I get this error. Anyone know of a workaround?

OnError,xxxxxx,xxxxxxx,Execute DTS 2000 Package Task,{94769783-575C-4D1E-90F6-C2BDB3EA3CE2},{E05551C1-CDDE-40E3-87B4-C65D4E1B3A53},4/26/2006 3:01:37 PM,4/26/2006 3:01:37 PM,0,0x,This task does not support native Win64 environment. Please run the package in 32-bit WOW environment instead.

OnError,xxxxxx,xxxxxxx,Execute DTS 2000 Package Task,{94769783-575C-4D1E-90F6-C2BDB3EA3CE2},{E05551C1-CDDE-40E3-87B4-C65D4E1B3A53},4/26/2006 3:01:37 PM,4/26/2006 3:01:37 PM,-1073594105,0x,There were errors during task validation.


Is the DTS 2000 Package Task not supported on Win64?

I have installed the SQL Server 2000 DTS components from the November feature pack on both my workstation and the server.

Thanks for your help!

View 4 Replies View Related

Adding Values Of Rows In Ms Sql 2000

Jun 3, 2006

I am building a website in asp.net 1.1 with vb.net 2003 which will have the standings of the teams in our baseball league.  Below is the database table I have created.
 
ID(int)  home_team (nvarchar)  away_team(nvarchar)  win_teampf(nvarchar) lose_teampf(nvarchar)
1    Elmwood    Murdock    7   22    Louisville     Manley       4   33    Manley        Elmwood    9  8
ID is the primary key.  What I am attempting to do is add each instance of Elmwood from the win column to output the total number of wins from Elmwood and do the same for Elmwood in the losing team to output the total number of losses. The result will look something like this:
Elmwood: 1 Win  1 Loss. .500
Thanks for your reply.
 

View 5 Replies View Related

SQL 2000 - Large Text Values

Oct 10, 2007

Hi all,

I have an existing database, which is used to store complaints data and have one field, which stores notes in a varchar(8000) column.

My users are now wanting to store information, which exceed the number of available characters. What options do I have in facilitating this?

Many thanks

View 5 Replies View Related

Removing -1.#IND Float Values From SQL 2000

Dec 12, 2007

How can I remove -1.#IND values from a float column in SQL Server 2000 (8.00.2039 SP4).

So far I've tried
- Using Query Analyzer, setting the value to a proper float value. I receive error €œA floating point exception occurred€?
- Using Query Analyzer, deleting the record with the invalid float. I receive error €œA floating point exception occurred€?
- Using Enterprise Manager, setting the value to a proper float value. I receive error €œA floating point exception occurred€?
- Using Enterprise Manager, deleting the record with the invalid float. I receive error €œA floating point exception occurred€?
- Previously I was able to convert the column to nvarchar, but now this fails because the table is being replicated.

I don€™t really care what happens to the records, I just need them to go away.

Thanks

View 2 Replies View Related

Dynamic Properties Task In DTS 2000, Need To Convert It To SSIS

Jun 28, 2007

I have a Dynamic propeties task in dts 2000 that process/executes a global variable.

The global variable basically executes a bat file.

How do i set this up in ssis. The migration failed to properly convert this task.

Please help.



Thank you.

View 11 Replies View Related

Error With Execute DTS 2000 Package Task On 64-bit With 32-bit Exec

Dec 17, 2007

Hello all,


I am running a package on a 64-bit server using the 32-bit dtexec. It contains an embedded Execute DTS 2000 package. I deployed the package to the server using the sa account. I set up a SQL Agent job that runs under an account that should have complete admin privileges. The network guys tell me that Legacy components have been installed (although I believe that shouldn't be necessary because SSIS is installed). This is SQL Server 2005, SP2.


When I execute this job, I receive this error message:


Executed as user: Domainuser. ...age Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:13:18 AM Error: 2007-12-17 11:13:35.65 Code: 0xC0010018 Source: Execute DTS 2000 Package Task Description: Error loading a task. The contact information for the task is "Execute DTS 2000 Package Task;Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. End Error Error: 2007-12-17 11:13:35.71 Code: 0xC0010026 Source: Execute DTS 2000 Package Task Description: The task has failed to load. The contact information for this task is "Execute DTS 2000 Package Task;Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". End Error Error: 2007-12-17 11:13:35.71 Code: 0xC0024. The step failed.


Is there any way to get this to run?


Thank you very much,
Jessica

View 7 Replies View Related

Send Mail Task Problem Using A Combination Of ForEach Loop, Recordset Destination, Execute SQL Task And Script Task

Jun 21, 2007

OK. I give up and need help. Hopefully it's something minor ...



I have a dataflow which returns email addresses to a recordset.

I pass this recordset into a ForEachLoop configuring the enumerator as (Foreach ADO Enumerator). I also map the email address as a variable with index 0.



I then have a Execute SQL task which receives this email address as a varchar variable (parameter 0) which I then use in my SQL command to limit the rows returned. I have commented out the where clause and returned all rows regardless of email address to try to troubleshoot this problem. In either event, I then use a resultset to store the query result of type object and result name 0.



I then pass this resultset into a script variable to start parsing the sql rows returned as type object. ( I assume this is the correct way to do this from other prior posts ...).



The script appears to throw an exception at the following line. I assume it's because I'm either not passing in the values properly or the query doesn't return anything. However, I am certain the query works as it executes just fine at the command prompt.



Try

ds = CType(Dts.Variables("VP_EMAIL_RESULTS_RS").Value, DataSet)



My intent is to email the query results to each email address with the following type of data by passing the parsed data from the script to a send mail task. Email works fine and sends out messages but the content is empty. I pass the parsed data as string values to the messagesource and define the messagesourcetype as a variable in the mail task.



part number leadtime

x 5

y 9

....



Does anyone have any idea what I might be doing wrong?

thanks

John

View 5 Replies View Related

Please Help! Cannot See Values In Output Params From SQL Server 2000 Using C# / ASP.NET

May 26, 2004

Hi,

I've got the following C# function to add a customer record to the database. The record gets added without any problems but the OUTPUT PARAMETER (Parameter[10]) is always NULL and I can't see why. I'm also using the Microsoft Data Application Block.

Here's the C# function:

public void SaveCustomer(int customerId,string customerName,string address1,
string address2,
string town,
string county,
string postcode,
string webSiteAddress,
string mainTelNo,
string mainFaxNo)

{
try
{
SqlParameter[] parameters = DA.SqlHelperParameterCache.GetSpParameterSet(this.ConnectionString,"UpdateCustomer");
parameters[0].Value = customerId;
parameters[1].Value = customerName;
parameters[2].Value = address1;
parameters[3].Value = address2;
parameters[4].Value = town;
parameters[5].Value = county;
parameters[6].Value = postcode;
parameters[7].Value = webSiteAddress;
parameters[8].Value = mainTelNo;
parameters[9].Value = mainFaxNo;
parameters[10].Direction = ParameterDirection.Output;

int RetVal = DA.SqlHelper.ExecuteNonQuery(this.Connection,"UpdateCustomer",parameters);

if (RetVal > 0)
{
int Key = Convert.ToInt32(parameters[10].Value.ToString());
}

}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString(), ex);
}

}


And here's the SQL Server 2000 Stored Procedure:


CREATE PROCEDURE UpdateCustomer

@CustomerId int,
@CustomerName varchar(100),
@Address1 varchar(50),
@Address2 varchar(50),
@Town varchar(30),
@County varchar(30),
@PostCode varchar(10),
@WebSite varchar(50),
@MainTelNo varchar(15),
@MainFaxNo varchar(15),
@ReturnValue int OUTPUT

AS

IF @CustomerId = 0
BEGIN
INSERT INTO Customer
(CustomerName, Address1, Address2, Town, County, Postcode, WebSite, MainTelNo, MainFaxNo)
VALUES(@CustomerName, @Address1, @Address2, @Town, @County, @Postcode, @WebSite, @MainTelNo, @MainFaxNo)

IF @@ERROR = 0
BEGIN
SELECT @ReturnValue = @@IDENTITY
END
ELSE
BEGIN
SELECT @ReturnValue = -1
END

END
ELSE
BEGIN
UPDATE Customer
SETCustomerName = @CustomerName,
Address1 = @Address1,
Address2 = @Address2,
Town = @Town,
County = @County,
Postcode = @Postcode,
WebSite = @WebSite,
MainTelNo = @MainTelNo,
MainFaxNo = @MainFaxNo
WHERECustomerId = @CustomerId

IF @@ERROR = 0
BEGIN
SELECT @ReturnValue = @CustomerId
END
ELSE
BEGIN
SELECT @ReturnValue = -1
END
END



Any help would be appreciated as it's starting to drive me mad now!!

View 7 Replies View Related

Adding Up Column Values (asp && Access 2000)

Nov 30, 2006

HiI've got a quandry - I have a detailed database that handles advertorders between a design agency and printers / magazines etc.I want to add up the total spent by the client and put the results to afield.I've actually done that using a query table in access - it should bequite simple as i can bind the 'total amount' to my table - the onlything it does not currently do is filter the total based on the monthselected.For example if you look athttp://www.daneverton.com/dg2data/months/2006-12.aspThe data here is filtered by the issue equaling Dec-2006The actual order total is £13,622 but the column is showing the totalfor all entries to date (a years worth = £ 422,048)I'm sure that there is only a basic tweak required but i'm banging myhead over what to doThe sql is "SELECT * FROM monnodraught, q_monodraught_total WHERE[Issue / Edition] LIKE ? ORDER BY Publication ASC"Any help gladly received.

View 1 Replies View Related

Transpose Row Values As Column In MS Sql Server 2000

Apr 23, 2008



How can i transpose rows value as Column?

Table A





TypeID

Payment Type


1

CASH


2

EFPOS


3

BANK CARD


4

VISA


5

AMEX


6

DINNER

NOTE: User can add some more Payment type

Required Output




CASH

EFPOS

BANK CARD

VISA

AMEX

DINNER

€¦











































































































Thanks
DA

View 5 Replies View Related

Xcopy Command Failed In Sql Server 2000 As Scheduled Task

Jul 20, 2005

After setting up the linked server connection at the standby server, Itried to xcopy a file through the sql server 2000 schedule task to thestandby server's shared directory. But it keeps giving me the errormessage with'Invalid Drive Specification'.My whole process includes1) set up linked server connection on the standby server2) set up job to xcopy file as operating system commend in sql serverfrom the production box(xcopy c:directoryfile.bak\standby_servere$directory /c)3) test, but not successful - I am already running the whole scheduletask as a Windows user with Admin authority.)What did I do wrong or did I miss something?Thanks in advance

View 6 Replies View Related

Workflow Error On Execute DTS 2000 Package Task In SSIS

Feb 1, 2008


I have a "Execute DTS Package 2000 " task in SSIS. The SQL 2000 DTS has one task which precedence is "completion". Using SQL2000 it works properly, but when I invoke it from SSIS it doesn€™t respect the precedence. So, when the task above fails it ends the DTS execution.


Is it possible to configure the task to respect the precedences?

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved