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 |
|
Sqlraider
Yak Posting Veteran
65 Posts |
 Posted - 2010-11-03 : 11:04:08
|
I'm new to SQL Server.I created/deployed a SSIS Package that Imports the tables I need from a SQL Server 2000 database (I have READONLY access) to a SQL Server 2008 R2. I set up a job in SQL Server Agent to execute the SSIS Import package.My question(s) are:#1) How do I know ALL the rows in each table have been imported over (do I assume that if the job is Successful ALL rows have been Imported?)?#2) If I need another form of verification for #1, what is the best practice way to verify?Thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-11-03 : 11:20:51
|
Look for MaximumErrorCount in your dataflow.If you have not changed it is set to 1.That means if at least one error occurs then the the task will fail and you will notice.If there isn't an error then all rows are imported.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Sqlraider
Yak Posting Veteran
65 Posts |
Posted - 2010-11-03 : 14:49:00
|
| Thank You for your quick reply.Since I am new I needed time (using BOL) to locate the MaximumErrorCount for all of my dataflow(s).For each dataflow I have MaximumErrorCount is set to 1.Thanks again for your help. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-11-03 : 15:21:43
|
welcome 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Import Verification