Here is how to set variables in the package from code – using Microsoft.SqlServer.Dts.Runtime; private void Execute_Package() { string pkgLocation = @”c:\test.dtsx”; Package pkg; Application app; DTSExecResult pkgResults; Variables vars; app = new Application(); pkg = app.LoadPackage(pkgLocation, null); vars = pkg.Variables; vars[“A_Variable”].Value = “Some value”; pkgResults = pkg.Execute(null, vars, null, null, null); if (pkgResults == … Read more
I use SSIS every day to maintain and manage a large data warehouse and cube. I have been 100% business intelligence and data warehousing for two years. Before that I was a .NET application developer for 10. The value of SSIS is as a workflow engine to move data from one spot to another with … Read more
For anyone that is still stuck on this issue after trying the above. If you are right-clicking on the database and going to tasks->import, then here is the issue. Go to your start menu and under sql server, find the x64 bit import export wizard and try that. Worked like a charm for me, but … Read more