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 |
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
 Posted - 2010-07-21 : 16:12:10
|
| HiI tried to create a package importing a flat file wit more than 400K records.I was able to create the package succusfully but when i try to execute the package iam unable to load the entire the flat file.when I examine the data I see # symbol in one of the feilds which is causing from not loading the data.The datatype is dt_wstr |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2010-07-22 : 04:09:55
|
| Please post the error message.How many rows are loaded into the table, if any? |
 |
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2010-07-22 : 08:19:28
|
| Approximately 370000 rows were loaded into the tableAlso,I placed an order for the version Sql server 2008 Developer edition 10.0.1600.22.Will this Version have Management Studio with SQL server agent and BIDSThanksVamsi |
|
|
|
|
|
|
Import Export wizard Package fails