November 7, 2011 at 6:37 am
We've got multiple customers (30+) in which we would like to provide them with a sql server table and update/reload it monthly. It's a zipcode table with 30 million rows, so it's not huge, but also not small either. We need to be able to ftp this file to them and allow a non-technical person to simple click on it and have it run -- either that or have it run by itself. Each of the of their sql servers are not set up the same, so, I can't just hardcode a path of c:\temp for a file path. Was thinking that I need something like an executable that would simply prompt them for the credentials, sqlservername, and database name and then have it run. Is this possible through an SSIS package. Also, most customers are on sql 2005.
Any ideas would be welcome. Thanks.
November 7, 2011 at 6:48 am
Yes, you can do this. Read about package configurations. You can take any property of the package (for example the location of the text file to be read from) and have it dynamically configured. In other words, you send the user the dtsx package file, and a dtsConfig file that will contain the client-specific settings for the package. They should then be able to amend the dtsConfig file for their own environment and run the package.
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply