Simple import. not every row is inserting into tbl

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 2008 Forums

SSIS and Import/Export (2008)

Simple import. not every row is inserting into tbl

Author

Topic

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-01-28 : 09:23:58

Hello there.

I have a simple pipped delimited txt file, importing into a table.

there are 300000 or so rows. But only 162000 rows are importing.

What can be the common causes of this. I am not getting any errors.

so frustrating.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-28 : 09:30:33

Are there any transformations in between or is it a direct pull from file to table?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-01-28 : 09:34:22

no just direct

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-28 : 09:37:25

is the delimiter consistent?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-01-28 : 09:50:14

yes it is

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-28 : 10:00:49

are there any error thrown by package? check in progress tab as well as error log

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-01-28 : 10:12:49

no errors in progress tab. apart from the progress tab, where else can i see errors

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-28 : 10:42:46

in log if you've enabled logging for package.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-01-28 : 10:45:24

i have just created a new package. and replicated the import, and its working now.

how you ever come across this before.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-28 : 11:26:15

it may be that you had not set some properties within connection manager properly.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources