Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to pass a param to SSIS
0 views
Skip to first unread message
Ben
Jan 22, 2008, 11:15:02 AM1/22/08
to
Using SQL Ent 2005. I have a flat file that needs to be imported on a repeat
basis. The caveat is that this can not be scheduled because the time the
file is ready to import is known only to an external program. I have
control over this external program though.
basis. The caveat is that this can not be scheduled because the time the
file is ready to import is known only to an external program. I have
control over this external program though.
Ideally I'd like to pass the SSIS job a parameter with the file name via a
SQLEXEC call from the external program. Kind of like a stored procedure
parameter.
Can this be done? If so how?
TYIA for any help.
=B
0 new messages