November 29, 2007 at 7:11 am
Dear guys,
I am trying to achieve the following task in SSIS:
1) get the list of the databases placed on a server (the server is stored in a variable and it's fix)
(I managed to load the names of the DB-s into an array)
2) now I want to display it to the user. I was thinking of a standard form as in VBA but in the Script task off SSIS so far I haven't been able to do.
Maybe there is another way for this, just I haven't figured it out.
Any help would be greatly appreciated!
Thanks,
MartinIsti
November 29, 2007 at 9:55 am
You are way off track for what SSIS is designed to do.
If you need to collect information from a user to run an SSIS package, collect it before you start the package (put it in a table or pass it into the package when it starts). You could even create an application that runs one package and then when the package completes, run another package after collecting some input, but don't try to put a modal dialog in the middle of an SSIS package.
SSIS is not designed to break for user input and then continue. Even if you manage to get it to happen, you are pretty likely to create something that is going to be troublesome and difficult to maintain.
If you need something that will do this, look at a workflow product like BizTalk.
November 30, 2007 at 1:10 am
Thanks for the answer Michael, you're right. Since I began dealing with this question I received the same answers not to create interactive SSIS packages. So I decided to create a normal VB application that uses DTEXEC with properly configured variables.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply