September 4, 2008 at 3:43 am
Hi,
I am importing a .csv file using the SSIS import wizard. When I run the package I have created, the Data Flow task box which imports the data into the newly created table goes red , which means it isn't working.
Does anyone know how to actually find what the error is with SSIS or the .csv file? there is nothing appearing in the error box below.
Any help would be greatly appreciated.
Thanks
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply