have developed an C# windows application, which uses DTS package to import data from a text file. The DTS package will truncate the table before insert into table from text file. This works fine through sourcecode and exe in my development pc and I want to move the windows application to production and run it the DTS package only truncate table and does not insert data into table. I tried to find out but I could not.

Thanks for all your help.

Hello,

Can you verify that this error isn't permissions related on the database production environment?

Brian

As stated you may have a permission issue

The account used to process the dts package must have proper permission. Make sure it has permission on the MSDB Database.

Hey Kathytran,
              I am a beginner with DTS. I am also using C#.Net to use DTS package to import text files and convert into tables. But I do not know where to start from. Since you have already started with similar application, I thought you may be able to help me better.
PLZ reply... Awaiting reply..

Thanx.