Change a Views data types

Question

Post reply

Change a Views data types

Viewing 7 posts - 31 through 36 (of 36 total)

You must be logged in to reply to this topic. Login to reply

A Little Help Please SSCarpal Tunnel Points: 4764 More actions · Answer 1

Yes importing flatfile into Bargains table, SSIS package includes:

1. Execute Process Task (colect files) - Successful

2. Execute Import Files above into tblCheckPoint, tblHouse,tblMK, Bargains - Successful

3. Execute SP procImportAllFile - FAILS

There are also some Send MailTask along the way which run Successfuly.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 2

Step 3 - the step which fails - is this the step which transfers data from the bargains table to tblClients?

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

A Little Help Please SSCarpal Tunnel Points: 4764 More actions · Answer 3

Yes

I think iv resolved the issue, at the bottom of the SP someone had put in some error constraints:

END

--Otherwise the files should not be updated

ELSE

BEGIN

Execute procImportFailClearTables

RAISERROR('Import Updates Failed',16,1)

END

--ADD CALLS TO STORED PROC TO DELETE FILES FROM EDRIVE

I have commented out the RAISEERROR line and the SSIS Works!!!!

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 4

A Little Help Please (12/8/2008)
Yes
I think iv resolved the issue, at the bottom of the SP someone had put in some error constraints:
END
--Otherwise the files should not be updated
ELSE
BEGIN
Execute procImportFailClearTables
RAISERROR('Import Updates Failed',16,1)
END
--ADD CALLS TO STORED PROC TO DELETE FILES FROM EDRIVE
I have commented out the RAISEERROR line and the SSIS Works!!!!

This looks like a coincidence. I recommend you spend some quality time investigating what this SSIS package is doing.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

A Little Help Please SSCarpal Tunnel Points: 4764 More actions · Answer 5

Chris, THANK YOU so much for your time and patients.

You have helped my understand stand the process much better!!

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 6

A Little Help Please (12/8/2008)
Chris, THANK YOU so much for your time and patients.
You have helped my understand stand the process much better!!

I have commented out the RAISEERROR line and the SSIS Works!!!!

You're welcome. I expect you will be back soon with further questions - when you do, be sure to post the whole sp which you have referred to.

Cheers

ChrisM

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

A Little Help Please SSCarpal Tunnel Points: 4764 More actions · Answer 7

Well, im sure I can remove the error code at the bottom of the SP as the next step after this in the SSIS is to run that SP if the previous one fails.... exactly what this code is doing.

I am writing my new post as we speak.... it will be under Intergration Services Forum in 1 minute if your interested.

Once again thanks for all you time.