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!

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

Connection Manager - Excel

Status
Not open for further replies.
BFT1303

BFT1303

Programmer
Jan 26, 2007
29
US
I am trying to give the user the ability to tell the SSIS the name of the Excel sheet to import. I have been unable to find a way to set the ExcelFilePAth to a variable name.
Has anyone been able to do this, if so how?

Thanks in advance,
-Brad
 
Sort by date Sort by votes
your best option is going to be a script task as a data source within your dataflow. Remember that SSIS dataflows are con figured when you define them for a specified column name and datatype. so if you give the user the ability to specify information you need to make sure that the format of the file is always the same.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Excel Import Maps 255 Char Max
Replies
0
Views
296
grnzbra
grnzbra
stahorse1
  • Locked
  • Question
Flat File Connection Manager
Replies
1
Views
165
micang
micang
Suru_07
  • Locked
  • Question
SSIS Excel Import Columns with More or Less than 255 Characters
Replies
1
Views
243
fredericofonseca
fredericofonseca
flobird
  • Locked
  • Question
ssis dynamic file name and sheet name excel
Replies
1
Views
254
Motlatjo
Motlatjo
awaria
  • Locked
  • Question
SSIS Pckg FTP Task FTP Connection Manager will not store or save password 1
Replies
6
Views
190
mekohler
mekohler

Part and Inventory Search

Sponsor

Back
Top