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 |
|
gila_it
Starting Member
2 Posts |
 Posted - 2011-03-30 : 08:30:42
|
| Hello everybody, I am not new in SSIS tool, but I bump into a strange problem.I have a complete SSIS package, that schedule daily.Now I wanted to do a minor change - by adding new column that will kept only 0/1 data.I managed to create bit data type column. I created the mapping in the destination OLE DB component. the package run without any problem. but this specific column does not updated, getting only NULL.Following that I change the data type to "smallint". but still does not work for me, still getting NULL.It is strange, I checked the data in the pipe by using data-viewer before "destination" component. this column have 0/1 data (smallint datatype (DT_I2))I don't have any idea what cause this problem.Please help here...thanks youGila |
|
|
Sqlraider
Yak Posting Veteran
65 Posts |
Posted - 2011-03-30 : 15:04:15
|
| After mapping did you make sure the destination knows to use the new column?If not:In the OLE DB Destination EditorSelect MappingsClick on the new column in - Avaliable Input Columns and drag it to the corresponding column in the Avaliable Destination Columns |
 |
|
|
gila_it
Starting Member
2 Posts |
Posted - 2011-03-31 : 01:41:56
|
| Yes, I did it.That's why it is strange.. |
|
|
|
Sqlraider
Yak Posting Veteran
65 Posts |
Posted - 2011-03-31 : 11:21:50
|
| I am not that experienced with SSIS but have had a similar problem when adding columns. I am Importing tables from another server & I have noticed that SSIS changes (could just be how I created it the first time) some of the Properties. I have successfully Imported bit data type columns.FYI - because I want data refreshed from the Source I drop & create my destination tables for each Import.Try this:In the Preparation SQL Task - in create table put: [column name] bit not nullThen in the Data Flow Task - in the Properties of BOTH the Source & Destination: make sure the OpenRowset has: [dbo].[tablename]Hope this helps. |
|
|
|
|
|
|
SSIS Destination mapping not work compitly