|
Subject:
|
DTS does not insert data into table
|
|
Posted By:
|
kathytran20022002
|
Post Date:
|
5/19/2004 1:43:23 PM
|
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.
|
|
Reply By:
|
bmains
|
Reply Date:
|
5/19/2004 5:03:11 PM
|
Hello,
Can you verify that this error isn't permissions related on the database production environment?
Brian
|
|
Reply By:
|
jemacc
|
Reply Date:
|
5/24/2004 5:20:59 PM
|
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.
|
|
Reply By:
|
juvesaurabh
|
Reply Date:
|
2/14/2006 1:59:13 PM
|
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.
|
