May 14, 2009 at 5:44 am
Hi All....
I have a requirement where in i should allow the user to select source and destination sources at runtime, and also map the columns at run time, can i achieve this using SSIS ?? if so how ???
by the by i came to know about the Import and Export wizard in SSIS which would provide the user to select source and destination at run time along with mapping concept.
my thinking is if i can call the wizard at run time from my application, lots and lots of complexity will be reduced....
any help on this would be greatly appreciated....
*He that is good with hammer tends to think every thing is a nail*
May 14, 2009 at 6:40 am
Here is where the installation placed the file for me.
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe
It depends on you MSSQL version, this is for 2005.
Regards
Gianluca
-- Gianluca Sartori
May 15, 2009 at 1:33 am
Hi Gianluca
Thanks for your reply, i found it in the Binn folder, thanks a lot...
*He that is good with hammer tends to think every thing is a nail*
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply