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 |
|
ds9
Starting Member
38 Posts |
 Posted - 2008-01-09 : 12:57:56
|
| Hi thereI am migrating all my DTSs to SSISs. One of them is a very basic DTS, that copies data from a text file and places it in a table with one extra column. That extra column is populated with the value of a global variable.In DTS mode I was creating a custom ActiveX transformation stating DTSDestination("FieldName")=DTSGlobalVariables("VariableName").Value Can any one advise me on the best way to accomplish this in the SSIS?I tried several approaches but all failing.Many thanksds9 |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2008-01-09 : 15:48:51
|
| You might want to look at using "Derived Column" ~ under Data Flow Transformations.This allows you to add an additional column to your table and default to variable. |
 |
|
|
ds9
Starting Member
38 Posts |
Posted - 2008-01-09 : 17:53:17
|
| Yes, I've tried that solution before, but then how do I link its output to the table in the database? The input for the database table is already taken for the data coming from the file, so i get an error message when trying to add the output of the Derived Column transformation to the input of the SQL table destination....Any clue how to work this out?Thanksds9 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-09 : 23:17:16
|
| In the derived column task you have 'add as a new column' option. Use it to add the newly created column to pipeline of data coming from file. and in sql table destination map this column to appropriate column of destination table. |
|
|
|
|
|
|
How to insert variable in one column