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 |
|
PanzerAttack
Yak Posting Veteran
71 Posts |
 Posted - 2011-08-08 : 11:46:15
|
| Simple q I'm sure although I can't seem to find the answer.I have a Txt file that is imported into my database via an SSIS Package. The Text file has been changed and now has an extra column. How do I change the SSIS, I can't see anything under Edit? |
|
|
PanzerAttack
Yak Posting Veteran
71 Posts |
Posted - 2011-08-08 : 12:30:19
|
| I have it:With the package being shown in the solution explorer on the right of the screen, right click and view code. Then copy one of the lines that exist and change the name of the column you require.You need to do this twice (it's in there twice).Then when you look at your columns mapped, it'll be at the bottom of the list. Done, in seconds. |
 |
|
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2011-08-18 : 07:29:22
|
| use dervied column |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-19 : 03:57:49
|
quote:
Originally posted by yadhu_cse
use dervied column
Why do you need to add derived column if its coming from source? All you need is to refresh metadata from source and add new column also to pipeline by selecting the checkbox------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSIS Edit for a new column