March 15, 2007 at 10:07 am
I'm working on my first SSIS package.
I've created the package in the Visual Studio tool that comes with SQL2005. I can execute the package from that tool and it works just fine.
(it just dumps a bunch of data into a .csv file and ftps it to another server)
When I import it onto the SQL box and store it in the MSDB database and try to execute it, the following error comes up: "Error: The product level is insufficient for component "Flat File Destination" (77).
I have standard edition SQL Server 2005.
The Redneck DBA
March 18, 2007 at 4:18 pm
Depending on whom you ask, this is either a bug in SSIS or an incorrect installation of same. Double check that you installed and are running the SSIS service, and make sure you have at least SP1 installed.
The following lengthy discussion on this topic might also be helpful:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1&PageID=0
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
August 31, 2007 at 2:16 am
In order for the package to run properly you need to create a job on the server and run the package from within this job.
When you try to just run the package, i think it tries to run it on your client computer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply