We have sql server 2000.

Here is the sql server code to import the data file:

DROP TABLE dbo.SALES_IMPORT

CREATE TABLE dbo.SALES_IMPORT (

STORE int,

[DATE(yyyymmdd)] smalldatetime,

[TAXABLE SALES] decimal(19,2),

[NON TAXABLE SALES] decimal(19,2),

[GIFT CERTIFICATE SALES] decimal(19,2),

[SALES...

We have sql server 2000.

Here is the sql server code to import the data file:

DROP TABLE dbo.SALES_IMPORT

CREATE TABLE dbo.SALES_IMPORT (

STORE int,

...

I have placed the stored procedure in another reply.

You can take a look at the code and let me know if you see something out of syntax. I...

I don't really have any exceptional handling, but I should. Here is the stored procedure that is having the insert issues:

ALTER PROCEDURE [dbo].[qryAppend_to_Comparison]

-- Add the parameters for the stored procedure...

Thanks for the quick response. I'll give it a try and let you know how it turns out.

Eric

Yes they do.

No, we are not seeing any errors when running the stored procedures.

I setup this user to have full access to this database so they are able to read and...

I tried turning on the packaging logging but when I would run the package, everything would look just fine in the tool. When I had the nonsysadmin user would...

I would say no since it only allows to store some type of numeric value into it and yes this table is store in a mdb database. I was...

I'm currently have a dts package setup where I transfer data from a IBM DB2 server to our SQL Server. There are times the system recognizes both servers and...

Yes, it does fail interactively as well as during scheduled running.

No, I cannot preview the data from IBM DB2 data in the Transfer task preview window.

Any other suggestions, I can...

When utilizing the SQL Task, how can I define a query that knows how to grab these three reports inside the access adp project?

I'm a little confused on how that...

Where do these settings get changed or turned on?