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 |
|
lcchs
Starting Member
4 Posts |
 Posted - 2011-08-04 : 11:03:22
|
| HiI am trying to create a package using MS SQL Visual Studio SSIS 2008.On the "Select Source Tables and Views" screen there are source tables and desitantion so when I select table from the source column, the table name automatically populate to the destination column as well.For example I am selecting a table KNA1 from the source which also appears in destination column but I need to change the table name into .dbo format in the destination, but I dont see .dbo[KNA1] in the destination column drop down menu.Does that mean there is no data available in the source side as yet or Is there another reason.I would appreciate if you guys can help.Regards |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-04 : 13:04:12
|
| that means you dont have dbo.[KNA1] table in destination. just give dbo.[KNA1] and if not there it will create a new table on its own and populate the data.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS Extraction