emily-1119612
SSCarpal Tunnel
Points: 4166
More actions
February 26, 2010 at 3:37 pm
#1125859
Can you base your package on a view and then change your view through VBA.
DoCmd.RunSQL "ALTER VIEW...
February 26, 2010 at 3:47 pm
#1125861
Other possibilities include package configurations http://www.sqlis.com/post/Easy-Package-Configuration.aspx or maybe calling DTEXEC and using the SET parameter to dynamically set a variable http://consultingblogs.emc.com/jamiethomson/archive/2005/02/28/1085.aspx
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply