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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS package missing data in import

Author  Topic 

SQLSSISUser
Starting Member

2 Posts

Posted - 2008-10-24 : 08:23:56
Hello,
I have an SSIS package that is used to load data into SQL 2005 DB from a CSV file.

The file size is large, 32MB with about 110,000 rows.
I am seeing a weird problem, in some cases the SSIS package doesn't import the first column for some of the rows.I checked for funny characters in the file and could not find any.since I am not able to reproduce the problem its become very hard to do anything.

Has anyone come across this scenario? Any help is appeciated.

Thanks!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-24 : 08:31:21
What error do you see?
Go to Top of Page

SQLSSISUser
Starting Member

2 Posts

Posted - 2008-10-24 : 08:33:55
quote:
Originally posted by sodeep

What error do you see?



Thanks for your time.

I donot see any errors. The data is missing in the import table.
Go to Top of Page
   

- Advertisement -