CSV import

Topics: Developer Forum
Jul 23, 2013 at 7:28 AM
I used DtLoggedExce on sql 2008 evnironment. For certain packages I used to have problems with import of csv files. I realized that the problem is configuration of bulk insert data format file. Last four columns (PackgeExecutionLogs - message, variables, expressions,..) that are configured with default size 0. Probably that doesn't work (I think that default size is lower that needed in my scenario at least). When I increased size from 0 to 100 000, I was able to import those files. Maybe someone has the same problem.

CSVlog.fmt:
9.0
14
1 SQLCHAR 0 100 ";;" 1 EventType ""
2 SQLCHAR 0 100 ";;" 2 TaskName ""
3 SQLCHAR 0 100 ";;" 3 PackageName ""
4 SQLCHAR 0 100 ";;" 4 TaskType ""
5 SQLCHAR 0 100 ";;" 5 Description ""
6 SQLCHAR 0 100 ";;" 6 ObjectId ""
7 SQLCHAR 0 100 ";;" 7 ContainerName ""
8 SQLCHAR 0 100 ";;" 8 ContainerId ""
9 SQLCHAR 0 100 ";;" 9 StartTime ""
10 SQLCHAR 0 100 ";;" 10 EndTime ""
11 SQLCHAR 0 100000 ";;" 11 Message ""
12 SQLCHAR 0 100000 ";;" 12 Variables ""
13 SQLCHAR 0 100000 ";;" 13 Expressions ""
14 SQLCHAR 0 100000 "\r\n" 14 Properties ""