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 |
|
prodigy2006
Yak Posting Veteran
66 Posts |
 Posted - 2010-02-01 : 11:18:13
|
| An SSIS package is created to copy over the tables from our production database to our Reporting database every night. All the tables get updated but only one table in the reporting database doesn't. I'm not sure where do i start looking into this issue as everything seems perfect. Any ideas? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-01 : 11:50:40
|
| does ssis package give any error for step? some more info would be appreciated |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-02-01 : 13:19:19
|
| When you're setting up the SSIS package , print out every step or trace the the actual steps in Profiler , so you can see what actually runs on the target server.Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2010-02-03 : 10:38:58
|
| I didn't check the package properly. My colleague found that the table hasn't been checked to be copied over to the reporting database.I'm fairly new to SSIS. I connected to the Integration services of the server. Dropped down MSDB and stored packages and I'm not sure how to open the package and make changes and then save it. Can anybody please explain in detail how to do this. |
|
|
|
|
|
|
Table not getting updated