Viewing 15 posts - 346 through 360 (of 1,315 total)
I don't know any reason why it would just ignore the /CONFIGFILE parameter, my guess is that an error is occurring that you're overlooking (or is not being reported to...
June 23, 2009 at 5:33 am
Using /CONFIGFILE on the dtexec command line does not turn off the configuration files set up in the package. All configuration items set up in the package (files, tables,...
June 22, 2009 at 9:45 am
If you can't configure all packages on all servers from the same source for any reason (multiple domains, security policies, etc), but want to write packages so they can be...
June 22, 2009 at 5:26 am
Nikos Miliotis (6/10/2009)
As i check the SSIS_Config view, it doesn't support both environments (Development and UAT) to coexist on the same machine. Is there any solution to support this?
You want...
June 10, 2009 at 9:00 am
Nikos Miliotis (6/9/2009)
In which database, do i have to store the SSIS_Config table?
SQL configuration should have its own connection manager, so all packages (in all environments) get configuration settings from...
June 10, 2009 at 8:35 am
whug (6/9/2009)
Would you be willing to share your SSIS template?
There's nothing special in my template, and you would have to rewrite most of it to suit your environment anyway. ...
June 10, 2009 at 8:35 am
That's an interesting idea. I think I would have it script out the command with the current values:
DECLARE @filter NVARCHAR(100)
SET @filter = N'InsertYourConfigurationFilterHere'
SELECT REPLACE(
N'EXEC dbo.SSIS_Config_SetValues N''' + ConfigurationFilter +...
June 9, 2009 at 3:33 pm
sqlJunkies2 (6/9/2009)
they will inadvertently reset all the production value to development value settings from the package
This is a good argument for using a lot of small configuration sets, to limit...
June 9, 2009 at 12:04 pm
Leo Hesen (6/9/2009)
So we have to check every word I guess 🙂
When I first saw the question, I knew it had "Trick Question" written all over it.
June 9, 2009 at 11:49 am
You're not getting any simple answers because "ER Diagram" is a vague term. For some people, the Database Diagram feature in Management Studio meets their requirements for ER diagrams....
June 9, 2009 at 9:06 am
Because if the spec says you need a variable to hold one character of data, then a solution that fails with the majority of available characters cannot be the best....
June 8, 2009 at 7:18 am
You can run this query on the SQL 2000 server to create commands to set the passwords on the SQL 2005 server.
SELECT 'ALTER LOGIN [' + l.[name] + '] WITH...
June 5, 2009 at 8:21 am
You can debate whether it should be CHAR(1) or NCHAR(1), but VARCHAR(1) is insane. If I had my way, I'd put a DDL trigger on every database that would...
June 5, 2009 at 7:15 am
If your diagrams are on a SQL 2000 server, I seem to recall that the trick was not adding database roles for the user but to grant public execute rights...
June 4, 2009 at 12:02 pm
John Rowan (6/3/2009)
Just curious, what are you using for your Package Protection Level, server storage?
I prefer to use the DontSaveSensitive setting, because I may want to deploy packages to a...
June 3, 2009 at 11:55 am
Viewing 15 posts - 346 through 360 (of 1,315 total)