Viewing 15 posts - 1 through 15 (of 171 total)
TheSQLGuru (10/22/2013)
That you asked that question has me a bit concerned. Implementing ANY form of...
October 23, 2013 at 3:49 am
TheSQLGuru (10/22/2013)
Griffster (10/22/2013)
October 22, 2013 at 11:37 am
Yes, we will be buying the Enterprise Edition. Looks like it would be worthwhile then so long as it's not too long a wait. If the release will be in...
October 22, 2013 at 8:49 am
We're at an embryonic stage with a big BI project really, and are planning on re-working all our internally developed web applications utilising SharePoint (especially SharePoint workflow designer for case...
October 22, 2013 at 5:20 am
Steven.Howes (8/16/2013)
August 19, 2013 at 4:49 am
That's great. THanks for your help here. Think I'll leave it in there to create the initial configuration file so it creates one that I can copy and amend to...
July 23, 2012 at 5:24 am
Sorry, disable package configurations? If I did this the package won't pick up any configurations I put in the configurations tab of the SQL Agent Job will it? Or do...
July 23, 2012 at 2:35 am
Mmm. Well the purpose of my configuration file is to import certain types of information throughout the day. In my SSIS package I have many sequence containers with dummy scripts...
July 23, 2012 at 2:06 am
Oh lordee! That's a nightmare! Why would they do that?!
So, the best thing to do is, in BIDS, create an environment variable package configuration to point to an xml...
July 20, 2012 at 7:34 am
OMG! That's worked! Is it best practice then to remove the configuration file when you're happy with the package? Really strange that. We've recently upgraded to SQL 2008 from 2005...
July 20, 2012 at 7:06 am
So back in to BIDS, select SSIS > Package Configurations. Leave Enable Package configurations ticked. Then select the configuration file in the list of configurations and press Remove, close it....
July 20, 2012 at 6:52 am
Sorry, probably didn't explain myself too well there. I created a configuration file (conf 1) when I built the original package. When you set CreateDeploymentUtility to True it adds that...
July 20, 2012 at 5:42 am
When I created the package I selected Package Configurations from the SSIS drop-down at the top, ticked enable package configurations, added an xml configuration file with the configuration string set...
July 20, 2012 at 3:55 am
It's populating the sysssislog table and stating it's running the original config file not my new one so no clue there unfortunately. The package was set to write to this...
July 20, 2012 at 3:43 am
That's great advice Martin. I'll experiment and see how I get on.
February 23, 2012 at 2:43 am
Viewing 15 posts - 1 through 15 (of 171 total)