Post reply

SSIS Package Execution for a non BIDS installed user

  • September 17, 2011 at 12:50 pm

    #390425

    Is is possible to build an SSIS package that a person who does not have BIDS installed on their local machine can execute.

    I have a project where a person who does not have BIDS installed needs to be able to execute a package for file validation.

  • September 19, 2011 at 8:37 am

    #1383323

    Brandon Carl Goodman (9/17/2011)

    Is is possible to build an SSIS package that a person who does not have BIDS installed on their local machine can execute.

    I have a project where a person who does not have BIDS installed needs to be able to execute a package for file validation.

    hmm

    how about the task kicks off when a certain folder has a file in it?

    you turn the task into a SQL Server Agent job that checks the directory every 5 minutes

  • September 19, 2011 at 9:42 am

    #1383365

    How about installing SSMS?

    You can call it via command line also. Here is the info:

    http://msdn.microsoft.com/en-us/library/ms162810.aspx

    The first line of code starts with coffee. The last line ends with alcohol.

  • September 19, 2011 at 12:13 pm

    #1383429

    Thanks everybody, but maybe I did not explain this very well. The user in this case will not have BIDS nor SQL Server installed on their machine. I just wanted to know if I provided them a SSIS package if they would be able to execute it without having the said above installed. Just needed for a file validation test.

  • September 19, 2011 at 12:26 pm

    #1383436

    Brandon Carl Goodman (9/19/2011)

    Thanks everybody, but maybe I did not explain this very well. The user in this case will not have BIDS nor SQL Server installed on their machine. I just wanted to know if I provided them a SSIS package if they would be able to execute it without having the said above installed. Just needed for a file validation test.

    No, they will not. DTSX is not a self-encapsulated compiled software, it's a map for other software to use, in particular, IS server.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • September 19, 2011 at 12:34 pm

    #1383438

    Thank you for the reply.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply