Adding new column to Excel Source in SSIS -


i working on ssis project. source excel file. working data it, querying database, , retrieving needed records. so, question is: how add programmatically new data column in excel source file , insert in these new records?

i have question - how delete rows excel in sql task?

i would
1. create new excel file new column(s) using "execute sql task".
e.g.

 create table `walks` (     ` date` nvarchar(255),      `id` nvarchar(255),     `distance` decimal,     `max` decimal,     `flat time` nvarchar(255)      ) 
  1. process existing excel / database , populate new excel.
  2. move/copy (initially) original excel elsewhere
    perhaps delete once working!
  3. rename new excel file original.
    note:
    a) need delay validation package
    b) set data connection new excel file.
    c) provide variable hold path new exel file.
    d) need file system task precede "execute sql task" delete excel file (using variable excel path) "execute sql task" can create it!

Comments

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

html - Missing border-right in select on Firefox -

python - build a suggestions list using fuzzywuzzy -