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 |
|
ctoledo
Starting Member
4 Posts |
 Posted - 2007-07-31 : 11:05:01
|
| I finally put together a SSIS package that takes a Text File and successfully imports its data into the right table. My question is, where in the package's properties can I find the option to Delete all rows from Destination Columns prior to Importing. I have looked everywhere in the Package Explorer for this setting. Thanx in advance. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-31 : 11:09:24
|
| moved from New to Sql Server forum_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
ctoledo
Starting Member
4 Posts |
Posted - 2007-07-31 : 12:18:01
|
| Thanx. Thought since this is a noob question I keep it away from the more advanced forums. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-31 : 12:33:27
|
| can't you just use Truncate Table?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
SSIS - Delete Rows before Flat File Import