Can anyone help?

Thanks

I have sorted this.

I had to put a waitfor delay before I ran the next stored proc which sends the file to the FTP site

Thanks, sorted it

SELECT

CAST('ALT' AS CHAR(3)) AS RecordType,

CAST('' AS CHAR(14)) AS MainProduct,

CAST('1' AS CHAR(1)) AS ShowAlternative,

CAST('' AS CHAR(5)) AS SequenceNumber,

CAST('' AS CHAR(14))...

Execellent!! Thanks very much

Thanks for your response. The SSIS packages look good. I need to look at these further.

For the moment I created the below which seems to work

DECLARE @cmdmove as...

I am thinking of using the following. Could you show me what you would do to look at the required files.

USE HBSLIVE

GO

CREATE TABLE CSVTest

(ID INT,

FirstName VARCHAR(40),

LastName VARCHAR(40),

BirthDate SMALLDATETIME)

GO

BULK

INSERT CSVTest

FROM...

Thanks for the guidance.

How would you use the Bcp to put specific fields into specific fields in the API table?

Does it work with XML documents?

Thanks for that Todd. Will make the adjustment

Sorry I have not created a package yet.

Below is what I am trying to do.

1. The website sends a file to the ftp site (say tab delimited) This...

I faced now issues regards exporting a view to a flat file and sending it to the FTP site. Thanks for your clear instructions it worked first time!!

I currently...

Thanks. I will get started!!

Thanks. I have been having a look at it. Never realised there was this tool.

Do you have an example of what you have done similar to what I...

Is this using the Export and Import Tool?

Soz, Will do!