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 |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2009-01-26 : 06:29:59
|
Hi guysI have VS2005 with SQL server expressi have design SSIS page which connect to express and transfer the data to CSV file. executes fine. use this tool "Code Generator for Integration Services" from http://www.ivolva.com/ssis_code_generator.html to get the code in C#.when i execute the package from C# code byMicrosoft.SqlServer.Dts.Runtime.DTSExecResult local_DTSExecResult;local_DTSExecResult = package.Execute(); if (local_DTSExecResult == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure) { foreach (Microsoft.SqlServer.Dts.Runtime.DtsError local_DtsError in package.Errors) { MessageBox.Show(local_DtsError.Description); } }it throws a error "The product level is insufficient for component \"Flat File Destination\"gone thru many link which say you need to installed SSIS component/Serveri need to run this app on client system. which will only have express installed.========================================Project Manager who loves to code.===============Ask to your self before u ask someone |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2009-01-26 : 09:44:26
|
| Thanks Visakh, which mean all my client system need this toolkit to be installed. as we had DTS earlier which can be saved as bas file and then with minor changes we were able to use it in .net. can I do the same with SSIS package. with out any installation.========================================Project Manager who loves to code.===============Ask to your self before u ask someone |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
SSIS package with c#