January 8, 2016 at 6:57 am
Is there a script that brings up a prompt that allows user to navigate/select path of flat file connection string and assign it variable to be used in Data Flow task?
January 8, 2016 at 7:06 am
joeshu26 (1/8/2016)
Is there a script that brings up a prompt that allows user to navigate/select path of flat file connection string and assign it variable to be used in Data Flow task?
Not directly. SSIS runs on a server and is not intended to be an interactive tool. However, an indirect solution might be OK.
- Client application prompts user
- User selects path
- Path gets written to database by client app
- SSIS package gets initiated
- SSIS package picks up path from database
January 8, 2016 at 7:21 am
you can...
what version of SQL are you using ? Is the user running the SSIS package in Visual Studio or executing the package in SSMS ?
January 8, 2016 at 7:29 am
simon-hulse (1/8/2016)
you can...what version of SQL are you using ? Is the user running the SSIS package in Visual Studio or executing the package in SSMS ?
But you shouldn't. Unless the user is a developer and this is for debugging purposes.
January 8, 2016 at 7:30 am
his user may be a developer...
January 8, 2016 at 7:32 am
Yes, user would be executing from SSIS, or executing package from Window Explorer.
January 8, 2016 at 7:33 am
Using SQL Server 2012, Visual Studio 2010 shell
January 8, 2016 at 10:43 am
+1 (well, really +1000) on Phils comments. this is very poor form, like when you used to use modal dialogs in VB6, or flashing & scrolling text in the browser status bar... :-D:hehe:
Steve.
January 8, 2016 at 11:06 am
stevefromOZ (1/8/2016)
+1 (well, really +1000) on Phils comments. this is very poor form, like when you used to use modal dialogs in VB6, or flashing & scrolling text in the browser status bar... :-D:hehe:
Just because something can be done if you try hard enough, it doesn't mean it should be done.
If someone needs a user to select a file to be processed by SSIS, then it would be better to have a non-SSIS application that would perform the first part and then execute the SSIS package, passing the file path to SSIS as a parameter.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply