Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
newbie99
Starting Member
3 Posts |
 Posted - 2008-09-04 : 06:38:54
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 06:41:22
|
| go to progress tab of your ssis package and see what error message its giving. |
 |
|
|
newbie99
Starting Member
3 Posts |
Posted - 2008-09-04 : 07:00:30
|
| Thanks for that. I'm pretty new to SSIS and this .csv file is giving me some problems. I have pasted in the heading columns and first row of data from the .csv file which is failing when I'm trying to import. Would you be able to advise me where it's going wrong? I think it's got something to do with the data provided. If you could give any advice or point me in the right direction it would be greatly appreciated. Thanks for your helpCRUISE-ID;SHIP-CD;SAILING-PORT;TERMINATION-PORT;SHIP-NAME;SAILING-DATE;NIGHTS;ITIN-CD;ITIN-DESC;FARE-CD;CATEGORY;1A;2A;3A;4A;2A1C;2A2C;NCF-A;NCF-C;GFT-A;GFT-C;INCL-AIR;PROMO-DESC;FUEL-SURCH;AIR-STATUS;ROUTING;AIR-COST-A;AIR-COST-C;AIR-COST-I;SAIL-TIME-EMBK;SAIL-TIME-DISMBK;CRUISE-ONLY;PRE-POST-HOTEL AR080604DD;AR;DVR;DVR;MSC ARMONIA;04/06/08;11;A108;North Cape;RACK;01;1353;1550;2275;3000;1550;1550;26;0;0;75;NO;BROCHURE PRICING;0;N;LGW/DVR/LGW;0;0;0;1800;0900;Y;N |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 07:31:45
|
| what was the error you got? without knowing that, its pretty difficult to suggest a solution.have you clearly specified the delimiter info in your exporting task? also could you give a brief description on tasks used in package? |
|
|
|
newbie99
Starting Member
3 Posts |
Posted - 2008-09-04 : 08:15:43
|
| 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 ErrorCREATE 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 youThanks again for your help. |
|
|
|
|
|
|
|
|
Importing a .csv file and no SSIS error message??