> Hi,
>
> I am learning SSIS and trying to create a DTS package for importing
> data from Excel Source to OLE DB Destination. It works fine if I have
> all columns in the Excel Source match exactly with columns in D/B
> table. But I have few columns in the D/B table, Fkey ids which are not
> available in the Excel Source. These column values are stored as
> Global Variables. I would like to import these values of Global
> variables in addition to the columns from Excel Source to D/B table.
>
> For example
> Excel source FirstName, LastName
> DatabaseTable Id, FirstName, LastName, FKID1
>
> Global Variable v1= FKID1
>
> This import should fill FKID1 from the Global variable v1.(same value
> for all the rows imported)
>
> Any help is appreciated.
>
> Thanks
>