SQL 2005 Intergration Service Q - Database版

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - SQL 2005 Intergration Service Q

相关主题
● Truncation error import csv file to SQL table	● Oracle Group and Index question
● error file或者exception file	● SQL aggregate multiple columns in ACCESS
● 想做几个SQL development的project	● SQL combine two columns from two different tables no shared (转载)
● SSIS package upgrade issue	● sql server 怎么关掉log
● Import data from excel into sql server 2000	● I HATE Micro$oft
● Re: Is there any easy way to truncate the LDF file of SQL SERVER?	● Is there any easy way to truncate the LDF file of SQL SERVER?
● 用SSIS EXPORT 到 EXCEL 2010 有2000个COLUMN,可能吗	● Access 'memo' data type
● Table Merge (SQL Server)	● which one is faster? truncate or delete?

相关话题的讨论汇总
话题: data话题: file话题: sql话题: service

进入Database版参与讨论

(共1页)

s**********e
发帖数: 860

Hi, all,
I've got a fixed width text file and I want to use SSIS read in the file.
And here's the error I got. Anybody knows the reason? I tried to use Access
to import the same data and it went well without any issue. BTW, there's a
lot of missing data in the file.
Thanks a lot!
Error: 0xC02020A1 at Data Flow Task, Flat File Source [1]: Data conversion
failed. The data conversion for column "Column 0" returned status value 4
and status text "Text was truncated or one or more characters had no m

(共1页)

进入Database版参与讨论

相关主题
● which one is faster? truncate or delete?	● Import data from excel into sql server 2000
● delete	● Re: Is there any easy way to truncate the LDF file of SQL SERVER?
● INSERT or UPDATE, which is faster?	● 用SSIS EXPORT 到 EXCEL 2010 有2000个COLUMN,可能吗
● random error for CAST( MONEY AS VARCHAR)	● Table Merge (SQL Server)
● Truncation error import csv file to SQL table	● Oracle Group and Index question
● error file或者exception file	● SQL aggregate multiple columns in ACCESS
● 想做几个SQL development的project	● SQL combine two columns from two different tables no shared (转载)
● SSIS package upgrade issue	● sql server 怎么关掉log

相关话题的讨论汇总
话题: data话题: file话题: sql话题: service

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

boards

未名新帖统计// 7月16日

历史上的今天