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 |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2010-10-09 : 20:58:04
|
| I want to create a SSIS Package that will convert data from the excel spreadsheets/ mapping and imported into SQL tables. Sounds easy! Data Flow Task -> Source(Flat File) - > Transformation(Data Conversion) -> Destination (OLEDB DB). Please TELL me where i m wrong.Note:- The problem i am facing to convert excel/text files (Error " can't convert Bolean to non-Bolean") and other package i want to populate data from 4 different OLEDB Tables and populate into one OLEDB TABLES. I am using TASK "SQL TASK" giving me problem. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-09 : 21:16:05
|
| assign the data types in the mapping tab of the transformation task |
 |
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2010-10-09 : 22:50:41
|
| Russell thanx for your reply. Could you please direct me other Errors that i m facing " Can't Convert Bolean to non-bolean" and how i can grab a data from 4 different table (as a source) and populate ONE OLEDB TABLE (as a destination)? Thanks |
|
|
|
|
|
|
SSIS Package Help