Help With Fixed Length Record Loading

Dec 28, 2007

We are converting an old (circa 2000) VB app that used an Access database to a C#/SQL Server 2005 database. One of the key business processes in this app was to import large quantities of data (200K+ at a time). The format of the text file is fixed length and while we would love to change it we are unable to (the user community would burn us in effigee if not for real). I have been looking at DTS, BCP, and Bulk Insert using format files and, while I think we can get most of the way there I am not sure if I am understanding the format file structure completly. Below is the import specification for one of our files:

FieldName DataType Start Length
AFIID C 1 5
LOCID C 7 15
LOGDATE C 23 11
LOGTIME C 35 4
LOGCODE C 40 4
HEADDIR C 45 3
SLUGVOL C 49 7
UNITS C 57 10

As you can see the each column is separated by a single space so that the second column starts two beyond the length of the first column, etc, etc. Here is an example of the data (the numbers in the first two rows are there to assist counting characters and do not exist in the real import file)
1 2 3 4 5 6
1234567890123456789012345678901234567890123456789012345678901234567
AFP29 01-SB-01 10-AUG-2000 0900 ABB DRW 9999.99 CFS
AFP29 01-SB-01 10-AUG-2000 0900 ABB DRW 9999.99 CFS
AFP29 01-SB-02 30-DEC-2000 0900 ABB DRW 9999.99 CFS
AFP29 XX-XX 10-AUG-2000 1000 ABB DRW 123.23 CFS
C123 01-SB-01 10-AUG-2000 0900 ABB DRW 9999.99 CFS
AFP29 10-AUG-2000 0900 ABB DRW 9999.99 CFS
AFP29 01-SB-01 0900 ABB DRW 9999.99 CFS
AFP29 01-SB-01 SDKJFDKL 0900 ABB DRW 9999.99 CFS
AFP29 01-SB-01 10-AUG-2000 ABB DRW 9999.99 CFS
AFP29 01-SB-01 10-AUG-2000 900 ABB DRW 9999.99 CFS
AFP29 01-SB-01 10-AUG-2000 0900 ABB DRW DFDSF CFS
AFP29 01-SB-01 10-AUG-2000 0900 ABB DRW 9999.99 CFS

From what I have read about the structure of format files you start with the host file field order number, then the host file data type, then prefix length, then field length, then field terminator, then database column order, then database column name, and final the collation.
This looks like it would work great for delimeted files but in my case there are no delimiters. If I don't include a terminator ("") would the following format file spec import my data correctly?
9.0
8
1 SQLCHAR 0 5 "" 1 AFIID ""
2 SQLCHAR 0 15 "" 2 LOCID ""
3 SQLCHAR 0 11 "" 3 LOGDATE ""
4 SQLCHAR 0 4 "" 4 LOGTIME ""
5 SQLCHAR 0 4 "" 5 LOGCODE ""
6 SQLCHAR 0 3 "" 6 HEADDIR ""
7 SQLCHAR 0 7 "" 7 SLUGVOL ""
8 SQLCHAR 0 10 "
" 8 UNITS ""

Thanks,
Richard Anderson

View 1 Replies


ADVERTISEMENT

DTS & Fixed Length Text Files

Apr 13, 2001

I created a package to import records from a fixed length 700 byte text file to a table in a SQL Database. I used the wizard to set it up and note the byte where each column ends. I need to customize the process, as the name of the text file will change each night, so I want to be able to set the file name from the VB front end app.

I have tried modifying the Datasource property of the DTS connection to the flat file, without success. I have also tried setting a global variable for the datasource property in DTS, and assigning that from VB, similarly without luck.

Do I have to create a custom package in code from VB? If so, how do indicate where each column in the text file ends? If I can customize the existing package, is there a specific reference that I need to set in my project that will let me control the value of the global?

TIA

View 2 Replies View Related

Fixed Length File Output

Feb 5, 2008

I need to write data into a fixed column length file and was wondering the best (most efficient) way to tackle this. For example, the first few pieces of the report I'm working on now would be:

PacketID - Starting position 1, Field length 9
TransactionID - Starting position 10, Field length 9
Group number - Starting position 19, field length 10
PID/SSN - Starting position 29, field length 10

For the PID/SSN, if I have a PID it'll be 10 digits and fill the field length, if I don't I use SSN which is only 9 digits and enter a space as the 10th digit. Obviously if I don't have certain pieces of information I'll just need spaces of the specified length to satisfy the file format. I'm using SQL 2005. Thanks in advance for any help provided.

View 4 Replies View Related

Fixed Length Text File

Sep 23, 2014

I have approximately 13 columns. Each Column has a start position and end position.. I created this in a table and defined the position, it's still not working for me.

FiceCode char(6), -- starting position 1, field length 6
StateStudID char(10), -- starting position 7, field length 10
CampusStudID char(10), -- starting position 17, field length 10
LastName char(25), -- starting position 27, field length 25

[Code] .....

I need a text output file that will define each start position.I also used: right(replicate('0',25) + cast(last_name as char(25)), 25) in my sql statement.when I add the first_name, I can't get it to start in position 52.

View 1 Replies View Related

Fixed Length Text Field

Dec 4, 2007

How do I create a text file with fixed length fields from a SQL table using a stored procedure.

View 4 Replies View Related

Fixed Length File Read

Feb 15, 2006

I have a fixed-length flat file that contains about 30 columns. I have got it pretty well figured out using the flat file connection tool, but I am having trouble with the end of the line.

I know when I look at the file it is a CrLf that separates the rows, and SSIS only seems to understand this to a certain extent. It knows to go to the next line, but it also adds two rectangles to the lines, like this:

Col1 Col2 Col3 Col4 Col5
aaaaaa bbbbb ccccc ddddd eeeee

[][]aaaaa bbbbb ccccc ddddd eee
ee[][]aaaaa bbbbb ccccc ddddd e
eeee[][]aaaaa bbbbb ccccc ddddd

While this does create a cool pattern, it is a pain in the butt. The only solution I have found is adding two more spaces to the last column in the table, but the ?s just get appended there.

If anybody has any clue how to get rid of them, that would be great.

Thanks in advance

View 1 Replies View Related

Importing Fixed Length Text File..

Apr 16, 2001

Hi, Does anybody know how to import a fixed field length ASCII text file which is 370 bytes into a SQL Table by DTS?

Thnaks,
Mano

View 1 Replies View Related

Can't Import Text File Fixed Length

Apr 21, 2003

Will be getting new file for download from vendor to process in future. When I use DTS or Import wizard in sql server I get "could not find the selected row delimiter within the first 8kb of data, is the selected delimited valid? This is for a fixed length file. If I answer yes and continue everything is fine, until I get to the end of the record which it can't find. It basically lumps the records together. What is interesting, that if I import the same file in Access 2000, I don't get this problem. ANyone seen this before? Could not find anything on MSDN

View 2 Replies View Related

DTS Fixed Field Length File Limitations

Jul 20, 2004

Hi,
I am trying to upload a fixed field text file to a sqlserver table using the DTS wizard. The txt file has 111 columns and the total length of a single row is 5897. The problem is when I use the wizard to specify the starting and ending of each column, its not allowing me to specify the columns beyond the position 4095.
Is there a limitation on this? if so is there a work around ? to solve this.
Any help on this is truly appreciated.

Thanks much. :)

View 1 Replies View Related

Bulk Insert - Fixed Length File

Jan 10, 2007

I'm trying to do an insert using Bulk Insert with a fixed length file.I'm using a format file.I'm getting the following error message:Cannot perform bulk insert. Invalid collation name for source column 16in format file '\wbhq.comdfsdviDataIntGOPFilesGOPFormatFile. txt'.Any suggestions are appreciated.Thanks!JenniferFormat File Contents:8.0161SQLCHAR02""0Space""2SQLCHAR04""1YearID""3SQLCHAR02""0Space""4SQLCHAR02""2PeriodID""5SQLCHAR02""3CompanyID""6SQLCHAR01""0Dash""7SQLCHAR04""0Space""8SQLCHAR01""0Dash""9SQLCHAR04""4UnitID""10SQLCHAR01""0Dash""11SQLCHAR04""5AccountCode""12SQLCHAR05""0Space""13SQLCHAR01""6AccountType""14SQLCHAR029""0Space""15SQLCHAR016""7GLAmount""16SQLCHAR0105"
"0Space""Bulk Insert Statement:BULK INSERT FlatFile_GOPFROM '\wbhq.comdfsdviDataIntGOPFilesGLPAM.GOP'WITH(FORMATFILE ='\wbhq.comdfsdviDataIntGOPFilesGOPFormatFile. txt')Table Definition:CREATE TABLE [dbo].[FlatFile_GOP] ([YearID] [smallint] NOT NULL ,[PeriodID] [smallint] NOT NULL ,[CompanyID] [smallint] NOT NULL ,[UnitID] [smallint] NOT NULL ,[AccountCode] [int] NOT NULL ,[AccountType] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,[GLBalance] [money] NOT NULL) ON [PRIMARY]GOFile Contents:2007 210- -0002-3000 G196395.102007 210- -0002-3700 B1484.002007 210- -0002-3700 G1571.132007 210- -0002-3800 B157457.002007 210- -0002-3800 G161577.73

View 1 Replies View Related

Import Variable Fixed Length File

Mar 3, 2006

I have a requirement to import a file of rows containing fixed length data. The problem is that each row can be one of 5 different formats (i.e. different columns) -- where the "type" of row is indicated by the first two characters of the row. Each row gets inserted into its own table.

Could I use a simple Conditional Split to route the rows? Or is the split for routing similiar rows? Anyways, problems are never this simple...

In addition, each "grouping" of rows is related. The "first" row is considered the "primary" row (and gets a row id via IDENTITY, whereas the remaining rows in the group are "secondary" rows and have foreign key references back the the primary rows id.

Given (using spaces to separate columns and CrLf to show "grouping"):

01 MSFT blah blah
02 blahblah blahblahblah
03 boring boringblah

01 AAPL blah blah
02 blahblah blahblahblah
03 boring boringblah

01 CSCO blah blah
02 blahblah blahblahblah
02 blahblah blahblahblah
03 boring boringblah

So, the first 3 lines are all related to a MSFT record which needs to be spread across multiple tables. The next three lines are all related to AAPL, And the next FOUR lines (yes, each record can have zero, one, or more secondary rows) are related to CSCO.

(If this is still not clear, all the "01" rows will be written to [Table1] with each row having an IDENTITY value. All the "02" rows will be written to [Table2] the a FK pointing to the correct [Table1] row. All the "03" rows will be written to... and so on.

Any ideas would be appreciated.

View 13 Replies View Related

Fixed Length Text File Import

Dec 5, 2007



Hi,

I am trying to import a text file that has fixed length fields.
It also has column headers repeated in the file.

The text file is delimited by <CR><LF>.

Question 1

There are certain rows that end abruptly after a column for ex:
Row 1 <col1 data>.....<col2 data>.....<col3 data><CR><LF>
Row 2 <col1 data>.....<col2 data><CR><LF>

This seems to be throwing off the text file import as row 1 seems to be importing alright but row 2 gets ignored.
This not the behaviour I want. I want row 2 to also be imported and have a default of NULL for the columns that
are not specified.

Does anyone know how to achieve this?

Question 2

This is not that serious, but currently, I do not know of a way to ignore repeating column headers.
It would be nice if there was a way, but I can always resort to T-SQL based data cleaning after the import.

Thanks.

Shailen Sukul
|BSc|Mcsd.Net|Mcsd|Mcad|
Software Architect / Developer
Ashlen Consulting Services
http://www.ashlen.com.au

View 6 Replies View Related

Converting Int To Fixed Length Char With Leading Zeroes

May 25, 1999

Hello All,
Can someone tell me how (in SQL) to convert an integer to a fixed length character filled with leading zeros. For example, I have an integer value of '125'. My user wants to see it displayed as '00000125'. How do I get the zeroes to fill in to a char(8) field when the length of the value differs, ie. '1', '125', '3452', etc.

Thanks in advance,
Terry

View 1 Replies View Related

How To Bulk Insert A File With Fixed Row Length And No Row Terminator?

Jul 16, 2004

Hi All,

I have a file that has fixed row size of 148 and fixed column size, but the file has no end of line character. I know it is wierd but a client has made the file and refuses to change the format. So I am stuck with reading it the way it is.
In Enterprise Manager, I used the Import/Export wizard and I specified fixed length and it let me specify 148 as the lenght of each line. Then it recognized the file and I was able to read it in.
I saved the DTS package and I can run it over and over again using dtsrun. However I want to do the same thing using Bulk Insert. How do you specify fixed row length for Bulk insert and how do you give it individual column lengths?

Thanks,

Shab

View 3 Replies View Related

Flat File With Fixed Length Header And No Delimeter

Aug 21, 2006

Hi,

I'm trying to extract data from a Flat File which is as fixed length as they come. The file has a header, which simply contains the number of records in the file, followed by the records, with no header delimeter (No CR/LF, nothing).

For example a file would look like the following:

00000003Name1Address1Name2Address2Name3Address3

So this has 3 records (indicated by the first 8 characters), each consisting of a Name and Address.

I can't see a way to extract the data using a flat file connection, unless we add a delimeter for the header (not possible at this stage). Am I wrong?

Any suggestions on possible solution would be much appreciated - I'm thinking Ill have to write a script to parse the file manually.

Thanks in advance,

Scott

View 6 Replies View Related

No Row Delimiter For Fixed Length Flat File Destination?

Dec 8, 2006

When I use SQL 2000 DTS Export to create a fixed length flat file, the data rows are delimited by carriage return-line. Which means that when I open the flat file in a text editor like UltraEdit or WordPad, the data rows are broken out nicely (row ends at the max row length position and new row starts at position 0).

But when I use SSIS to create the file, the whole file is displayed as one line in WordPad. The data rows don't end at the max row lenght position in ultraEdit neither. From Flat File Connection Manager's Preview page, I can see the data rows are displayed properly.

Now I wonder if the flat file destination is a true fixed length file.

View 3 Replies View Related

Reading A Text File With Fixed Length Column

May 11, 2008

Hi,

I would like to read from a Text File using SSIS Integration Package.

The file has a fixed number of columns, let's say 3 columns.
There is no row header and each columns length is fixed. There is no delimiter as well.



Here is the sample of the file contents:
John Doe USA
Mary Monroe UK
Andy Archibald Singapore



Here is the hints to read the file contents
123456789
0123456789
0123456789
==============================
John Doe USA
Mary Monroe UK
Andy Archibald Singapore

If you notice, from the 1st column until the 9th column, it's reserved for the first name.
The 10-th column until the 19th column, it's reserved for the last name. Finally the 20-th column until the 29th column is reserved for the Origin Country.

Since there's no delimiter inside the flat file contents, i have difficulty in parsing this text using SSIS Package.

Please let me know if you need any necessary information.

Thanks for all your help.

Regards,

Hadi Teo.

View 4 Replies View Related

Import Fixed Length Text File To Sql Server Using SSIS

Apr 18, 2008



what is the best way to import fixed length text file to sql server using SSIS?

I was trying to using text file source and ole db destination..but since the text file has no columns and have different length per column and per line( it show only one column becasue it all concatnated), I can not map it to destination column..

How can I import it?

Here is the example of text file ( fixed with row delimeter)that i need to import to different columns...



010000000000000000001164.00023 YV

02004101 1 2008-04-OLL 43456 0000000001 2008-04-08

030000100000000000000000000007.00

047890 7556 YYU 779

View 8 Replies View Related

SQL Server 2008 :: Effect Of Updates On Fixed And Variable Length Columns

Mar 4, 2015

I have this doubt and want to be sure if my thinking is correct.

Lets consider 2 tables one with Fixed length columns (char) and other table with Variable length columns (Varchar).

The table with fixed length column will always allocate same size within a Page however, table with variable length column will allocate actual length of data within a page.

I think that updates happening on table with fixed length columns will have more possibility of InPlace updates at least from data length perspective, however updates on table with variable length columns will have more split updates from data length perspective.

View 0 Replies View Related

XML Format File For Bulk Insert Of Text File With Fixed Length Columns

Jan 2, 2008

Hey All,

Similar to a previous post (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=244646&SiteID=1), I am trying to import data into a SQL Table.

I am trying to program a small application that will import product data obtained through suppliers via CD-ROM. One supplier in particular uses Fixed width colums, and data looks like this:




Example of Data

0124015Apple Crate 32.12

0124016Bananna Box 12.56

0124017Mango Carton 15.98

0124018Seedless Watermelon 42.98
My Table would then have:
ProductID as int
Name as text
Cost as money

How would I go about extracting the data with an XML Format file? I am stumbling over how to tell it where to start picking up data for a specific column.
Is there any way that I could trim the Name column (i.e.: "Mango Carton " --> "Mango Carton")?

I don't know if it makes any difference, but I've been calling SQL from my code by doing this:




Code in C# Form

SqlConnection SqlConnection = new SqlConnection(global::SQLClients.Properties.Settings.Default.ClientPhonebookConnectionString);
SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO PhonebookTable(Name, PhoneNumber) VALUES('" + txtName.Text.ToString() + "', '" + txtPhoneNumber.Text.ToString() + "')";
cmd.Connection = SqlConnection;

SqlConnection.Open();
cmd.ExecuteNonQuery();
SqlConnection.Close();
RefreshData();
I am running Visual Studio C# Express 2005 and SQL Server Express 2005.



Thanks for your time,


Hayden.

View 1 Replies View Related

Layout File For A Fixed-Length Flat File

Sep 26, 2005

Hi,

View 5 Replies View Related

Max Record Length For DTS?

Apr 26, 2001

Hi folks,

I'm trying to load a flat file (text) into a table with 83 columns in it. The record length on the flat file is 251 characters long. For some reason when running the DTS import utility, DTS can't read the past the 142 character on the flat file, it spills on to the next line. The red bar is set on the 143 character when i use the fix field options in DTS import. Can the red bar be moved out further? Or is there a max field length using DTS?

anyone out there that can help?


Joe

View 1 Replies View Related

Record(row)length Of A Table

Apr 26, 1999

Hi,

Does any one know how to find a record (row) length of a table?

View 3 Replies View Related

Record Length Issue

Aug 23, 2007

I am having issues with exporting a file from a table. The data is correct however the Record Length for our
mainframe is 100 and the file I am sending is 23036. Any help would be appreciated

Mainframe Specifications
Record Format:FB
Record Length:100
Block Size:27900


My SSIS package Export File

Record Format:VB
Record Length:23036
Block Size:27998

Table that is exported (Details)
RMSTRANDTEvarchar(8)
RMSTRANTIMchar(4)
RMSACCTNUMchar(20)
RMSTRANCDEchar(2)
FIELDchar(6)
HSTNEWVALUchar(40)
INTEXTCODEchar(1)
AGENCYchar(4)
PLATFORMchar(4)
REGIONchar(4)
PRODUCTchar(4)
FILLERchar(3)

---All Precision Set to Blank
---All Scale set to Blank

SSIS Packages Specifications:
Flat File Destination
Code Page:1252
Locale:English
Format:Fixed Width
Row Delimiter:{CR}{LF}

View 1 Replies View Related

Adding A Header Record To A Fixed Width Flat File Data Export.

Jun 21, 2007

Hi-I have a sql database (2005) that I need to extract a report from that looks somehintg like  SELECT * From Empl_Hours WHERE some_flag <> 'true' .The thing works fine, but the problem is this: I need to insert a record in the 1st row that looks like "Static_text"+row_count() +"more_static_text"where row_count is the actual # of rows that were retrieved. Thanks in advance for any help.DAn 

View 3 Replies View Related

Loading Data File In SSIS With Multiple Record Layouts

Apr 4, 2007

I am trying to load a file using SSIS that contains records with two different layouts in one data file but in the flat file connection I can only specify one layout and this is causing the records with the second layout to be loaded incorrectly.



The different record layouts can be identified by the first character of the record. Example: If Field begins with "A" then assign one layout; "B" assign second layout.



Has anybody come accross this issue, if so some guidence would be appreciated.



Thanks,



ire_ssis

View 10 Replies View Related

Transact SQL :: Convert Non Fixed Rows To Non Fixed Columns Dynamically?

Oct 5, 2015

I have a table with 3 columns  (ID Int , Name Varchar(25), Course Varchar(20))

My source data looks like below

ID      Name        Course
1        A                Java
1        A                C++
2        B                Java
2        B                SQL Server
2        B                .Net
2        B                 SAP
3        C                 Oracle

My Output should look like below...

ID      Name       Course(1)     Course(2)         Course(3)     Course(4)  

1        A                 Java            C++
2        B                 Java            SQL Server .Net             SAP
3        C                 Oracle

Basically need t-sql to Convert non fixed rows to non fixed columns...

Rule: IF each ID and Name have more than 1 course then show it in new columns as course(1) course(2)..Course(n)

Create SQL:

Create table Sample (ID Int null , Name  Varchar(25) null, Course Varchar(20) null)

Insert SQL:

INSERT Sample (ID, Name, Course)
          VALUES (1,'A','Java'),
                 (1,'A','C++'),
                 (2,'B','Java'),
                 (2,'B','SQL Server'),
                 (2,'B','.Net'),
                 (2,'B','SAP'),
                 (3,'C','Oracle')

View 12 Replies View Related

T-SQL (SS2K8) :: Procedure Parameter Length Declaration Less Than Column Length?

Jun 30, 2014

is there any way or a tool to identify if in procedure the Parameter length was declarated less than table Column length ..

I have a table

CREATE TABLE TEST001 (KeyName Varchar(100) ) a procedure
CREATE PROCEDURE SpFindNames ( @KeyName VARCHAR(40) )
AS
BEGIN
SELECT KeyName FROM TEST001
WHERE KeyName = @KeyName
END
KeyName = @KeyName

Here table Column with 100 char length "KeyName" was compared with SP parameter "@KeyName" with length 40 char ..

IS there any way to find out all such usage on the ALL Procedures in the Database ?

View 2 Replies View Related

BlobColumn.GetBlobData() With Data Length &&> Integer Length (32767)

Mar 27, 2008

For those of you who would like to reference my exact issue, I'm dealing with the RSExecution SSIS package at the "Update Parameters" data flow task, at the Script Component.

The script tries to split parameter data into name and value. Unfortunately, I have several reports that are passing parameters that are very large. One example has over 65,000 characters all in the normal "&paramname=value&parm2=value..." format.

The code in the script works fine until it gets to one of these very large parameter sets. I have figured out what is causing the issue. Here's some code:

Dim paramBlob as Byte()
paramBlob = Row.BlobColumn.GetBlobData(0, Row.BlobColumn.Length)

The second parameter of the .GetBlobData function takes an INTEGER as its count! Therefore, no matter what kind of datatype I pass to the string that the script will later split, it will be limited to 32767 characters.

THIS IS A PROBLEM!!!

Does anyone know a workaround for this issue? I need all of the parameter data to be reported, and I would hate to have to skip over rows like this. Also, if I'm missing something, please fill me in!

Thanks for your help in advance,
LOSTlover

View 6 Replies View Related

CommandParameters.length Don't Match Parametervalues.length

Feb 24, 2008

I am trying to narrow down this problem.  Basically, I added 3 columns to my article table.  It holds the article id, article text, author and so on.  I tested my program before adding the additional field to the program.  The program works fine and I can add an article, and edit the same article even though it skips over the 3 new fields in the database.  It just puts nulls into those columns.So, now I have added one of the column names I added in the database to the code. I changed my businesslogic article.vb code and the addarticle.aspx, as well as the New article area in the addartivle.aspx.vb  page. The form now has an additional textbox field for the ShortDesc which is a short description of the article. This is the problem now:  The command parameters.length is 9 and there are 10 parameter values.  Right in the middle of the 10 values is the #4 value which I inserted into the code.  It says Nothing when I hover my mouse over the code after my program throws the exception in 17 below.  Why is  command parameters.length set to 9 instead of 10?  Why isn't it reading the information for value 4 like all the other values and placing it's value there and calculating 10 instead of 9? Where are these set in the program?  Sounds to me like they are hard coded in someplace and I need to change them to match everything else.  1 ' This method assigns an array of values to an array of SqlParameters.2 ' Parameters:3 ' -commandParameters - array of SqlParameters to be assigned values4 ' -array of objects holding the values to be assigned5 Private Overloads Shared Sub AssignParameterValues(ByVal commandParameters() As SqlParameter, ByVal parameterValues() As Object)6 7 Dim i As Integer8 Dim j As Integer9 10 If (commandParameters Is Nothing) AndAlso (parameterValues Is Nothing) Then11 ' Do nothing if we get no data12 Return13 End If14 15 ' We must have the same number of values as we pave parameters to put them in16 If commandParameters.Length <> parameterValues.Length Then17 Throw New ArgumentException("Parameter count does not match Parameter Value count.") 18 End If19 20 ' Value array21 j = commandParameters.Length - 122 For i = 0 To j23 ' If the current array value derives from IDbDataParameter, then assign its Value property24 If TypeOf parameterValues(i) Is IDbDataParameter Then25 Dim paramInstance As IDbDataParameter = CType(parameterValues(i), IDbDataParameter)26 If (paramInstance.Value Is Nothing) Then27 commandParameters(i).Value = DBNull.Value28 Else29 commandParameters(i).Value = paramInstance.Value30 End If31 ElseIf (parameterValues(i) Is Nothing) Then32 commandParameters(i).Value = DBNull.Value33 Else34 commandParameters(i).Value = parameterValues(i)35 End If36 Next37 End Sub ' AssignParameterValues38 39 40 41  

View 2 Replies View Related

Has This Been Fixed In SP1?

May 1, 2006

Can someone from MS tell me if this has been fixed in SP1?

http://blogs.conchango.com/jamiethomson/archive/2005/10/11/2261.aspx

Thanks

Jamie

View 3 Replies View Related

TOUGH INSERT: Copy Sale Record/Line Items For Duplicate Record

Jul 20, 2005

I have a client who needs to copy an existing sale. The problem isthe Sale is made up of three tables: Sale, SaleEquipment, SaleParts.Each sale can have multiple pieces of equipment with correspondingparts, or parts without equipment. My problem in copying is when I goto copy the parts, how do I get the NEW sale equipment ids updatedcorrectly on their corresponding parts?I can provide more information if necessary.Thank you!!Maria

View 6 Replies View Related

How To Create An Copy Of A Certain Record Except One Specific Column That Must Be Different &&amp; Insert The New Record In The Table

Sep 1, 2006

Hi
I have a table with a user column and other columns. User column id the primary key.

I want to create a copy of the record where the user="user1" and insert that copy in the same table in a new created record. But I want the new record to have a value of "user2" in the user column instead of "user1" since it's a primary key

Thanks.

View 6 Replies View Related







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