I have looked into it. I need buy in from Sr. Mgmt. Also I'll need to integrated on the web via .NET? Do you have any links...

I'm talking about the final table generating about 1,000 records per day. I didn't want to describe the entire process but I pre-load to a staging table as you...

A solid way of what you are trying to accomplish is to create a SQL Script that inserts the data for all fields:

Such AS

-- Record 1

INSERT INTO [YourDB].[dbo].[YourTable]([Id], [Field2], [Field3])

VALUES(1,...

Hi All,

Thanks for you input. This is how I handle this (due to time constraints) Within the sproc that loads the new data.

I created a quick check against...

The link between the hierarchy is the id which has the invoice then the transactions for that invoice. The table structure looks something like this

A ...

I'm using a MacBook Pro so I don't have all the formatting tools. Anyway the purpose of the cursor function in this case is to:

1. Get the new Invoices...

I'm still trying to figure out the table structure myself. This is what I have so far: using the NWIND as a model

I would get the new data...

Actually you're partially right. This is an import to a financial system call Solomon (which is a MS product). I can't use XML because the import function doesn't...

The dates represent invoice date for the invoice and line item date(entry date for a line item).

I have two tables an Invoice table that looks something like this:

Invoice Table

InvoiceNo. ...

Sorry about that, my session drop. The purpose of this to export to a flat file, separated by comma delimited. However this data is coming from two data...

I'm looking to design a financial reporting database which can the accomplish some of the following:

1. Be able to distinguish the different product services that are being billed and revenue...

Thanks for the quick respond.  I also need to evaluate my design because I've been told that this file is going away and we'll be using some type of service...

First of all thanks for the code.  To answer your question, no.  I'm not using http://FTP.  The user downloads the file from this company's website and stores the...

Unfortunately I don't have a say in how this file is formatted.  The file is downloaded by the users and they manipulate the file in Excel and then create a...

Wow it's been yrs since I've done anything in VBScript(ActiveX).  You're saying within the DTS package you would load the text file then check the text file with the ActiveX...