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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2009-10-05 : 07:49:46
|
| When i want to import a customers file through FTP using ssis. IS there a way of checking the data integrity with code, or does it do this by itself?RegardsRobMCTS certified |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-07 : 05:00:45
|
| What do you mean by data integrity?We import into staging tables, then run a store procedure to clean and format the data into the destination table.If any errors occur, the process stops and we can look at the data in the staging table.You can use SSIS to transform the data on load (e.g. data type mapping). |
 |
|
|
|
|
|
Importing flat file, with data integrity