June 24, 2002 at 4:51 am
i am creating DTS packages to export data from Sql server to .csv files.
during runtime i want to change the query used. how can i change it in visual basic.i am not quite familiar with the DTs object.
i tried changing the query but it does not execute.
Is it necessary the packages to be created in Sql server before using it in VB?
Please anyone with information will be very helpfull
thanks in advance
roopa
June 24, 2002 at 10:13 am
You should be able to change it in VB. Are you running this in VB after changing it, or attempting to "save it"?
Steve Jones
June 24, 2002 at 6:52 pm
i tried changing it in Vb, but it does not give any error or even execute it.
Is there a way to use globl variables in the Sql task. whenever i use it i get an error.
so that i can just change the filter to execute it
with regards
roopa
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply