September 4, 2008 at 7:46 am
If you are running your package in visiual studio, after you execute it, there should now be a "Execution Results" tab next to all the other tabs (Control flow, data flow...).
That will give you all the details of the execution, including the errors.
k
September 4, 2008 at 8:17 am
Thanks for that, I've found the errors and I wander if you could help me.
The first error was in the Preparation SQL task. This used a create table sql statement and I noticed the sql statement below had spaces between the last column name (PRE-POST-HOTEL) and the closing bracket ].
I corrected this by deleting the spaces and it created the table correctly.
1st Error
CREATE TABLE [cruiseDirect].[dbo].[newflatgbr-test] (
[CRUISE-ID] NVARCHAR(50),
[SHIP-CD] NVARCHAR(50),
[SAILING-PORT] NVARCHAR(50),
[TERMINATION-PORT] NVARCHAR(50),
[SHIP-NAME] NVARCHAR(50),
[SAILING-DATE] NVARCHAR(50),
[NIGHTS] NVARCHAR(50),
[ITIN-CD] NVARCHAR(50),
[ITIN-DESC] NVARCHAR(50),
[FARE-CD] NVARCHAR(50),
[CATEGORY] NVARCHAR(50),
[1A] NVARCHAR(50),
[2A] NVARCHAR(50),
[3A] NVARCHAR(50),
[4A] NVARCHAR(50),
[2A1C] NVARCHAR(50),
[2A2C] NVARCHAR(50),
[NCF-A] NVARCHAR(50),
[NCF-C] NVARCHAR(50),
[GFT-A] NVARCHAR(50),
[GFT-C] NVARCHAR(50),
[INCL-AIR] NVARCHAR(50),
[PROMO-DESC] NVARCHAR(50),
[FUEL-SURCH] NVARCHAR(50),
[AIR-STATUS] NVARCHAR(50),
[ROUTING] NVARCHAR(50),
[AIR-COST-A] NVARCHAR(50),
[AIR-COST-C] NVARCHAR(50),
[AIR-COST-I] NVARCHAR(50),
[SAIL-TIME-EMBK] NVARCHAR(50),
[SAIL-TIME-DISMBK] NVARCHAR(50),
[CRUISE-ONLY] NVARCHAR(50),
[PRE-POST-HOTEL ] NVARCHAR(50)
)
The second error is a Data Flow Task and some of the errors I am getting in progress tab are:
[Destination - newflatgbr-test [142]] Error: Column "PRE-POST-HOTEL " cannot be found at the datasource.
[DTS.Pipeline] Error: component "Destination - newflatgbr-test" (142) failed the pre-execute phase and returned error code 0xC0202025.
[DTS.Pipeline] Error: component "Destination - newflatgbr-test" (142) failed the pre-execute phase and returned error code 0xC0202025.
It seems to me it is picking up a problem with the last column (PRE-POST-HOTEL) of the .csv file.
The header row delimiter I am using is {CR}{LF}
The Row delimiter is I am using is {CR}{LF}
And the column delimiter I am using is Semicolon {;}
Hope this is enough information for you
Thanks again for your help.
September 4, 2008 at 8:28 am
It seems from the error that it is still expecting that space in the name of the last column (there is a space in the error between the name and ")
Since you created the table with no space, i think you go into your "Destination" task, and make sure it is getting the latest table definition. In the past, i sometimes had to delete and recreate the destination connection.
hope this helps!
k
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply