Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
im1dermike
Posting Yak Master
222 Posts |
 Posted - 2008-04-11 : 14:33:47
|
Hi. I've created a number of packages in SSIS which just make temp tables out of views. I did them with the "Optimize for many tables" and "Run in transaction" boxes checked.Now I'm trying to port them over to another database on another server. I'm first going through the Package Configuration Wizard. When I try to finish the wizard I get a error with the following message:quote:
===================================Could not complete wizard actions. (Microsoft Visual Studio)===================================Could not generate the configuration file. (Microsoft.DataTransformationServices.Wizards)------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Wizards.ConfigurationWizardPages.ConfigurationWizardSR&EvtID=CouldNotGenerateConfigurationFile&LinkId=20476------------------------------Program Location: at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration) at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.OnFinish(CancelEventArgs e)===================================Failure exporting configuration file. (ENRLMNT_UniqueRecords_temp)------------------------------Program Location: at Microsoft.SqlServer.Dts.Runtime.Package.ExportConfigurationFile(String str) at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
I don't know how to resolve it. Anyone?One way to deal with this particular issue would be just to recreate the SSIS package on the other server. The issue with this is I want to be positive which view I'm making a copy of and I'm not currently. Since the Import/Export has the transaction setting checked, I can't seem to determine what the source was. Help? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-11 : 14:52:21
|
| How are you passing configuration information?Using xml file or table? Refer the article too:-http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx |
 |
|
|
im1dermike
Posting Yak Master
222 Posts |
|
|
|
|
|
Package Configuration Wizard Error