Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can an SSIS package pass the Network ID during an import into SQL table

Status
Not open for further replies.

03Explorer

Technical User
Sep 13, 2005
304
US
I have a package setup to import an EXCEL file into a SQL server table. Currently, it derives the date/time of the import into a table field. I am hoping to also derive who is performing the import by their network ID.

Is it possible?
Thanks
 
SOLVED

I found when in the Data Flow section using "Derived Column". In the Derived Column Transformation Editor window, the left section (Visual Studio 2015 Standalone- Free version) has an expansion area labeled "Variables and Parameters". See attached image showing the field I identified.

Rob
 
 https://files.engineering.com/getfile.aspx?folder=81893c73-3474-4ee8-8ea7-6c98913ee3ce&file=Derived_Column_Transformation_Editor.png
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top