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 |
|
Chinni
Yak Posting Veteran
95 Posts |
 Posted - 2008-09-02 : 16:28:35
|
| Hi can any one help me out in this......OLEDB source is connect to flat file in data flow task..........flat file is retreving only 10 columns but the stored procedure in OLEDB souce has 11 columns as output.I tried recreating connection manager but did not workthanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-02 : 16:30:12
|
| What error did you get? see in Package Logging. |
 |
|
|
Chinni
Yak Posting Veteran
95 Posts |
Posted - 2008-09-02 : 17:05:24
|
| thanks for youe responseIt is not showing any error.........Its only showing 10 columns in mapping........initially i have only 10 columns i updated SP to 11 columns recreated connection manager ,i placed new txt file destination...but no use |
|
|
|
|
|
|
oledb source - flat file - columns missing