I created a DTS package in sql that exports a table into csv format. Is it possible to call this package from vb.net. Please help.
Pareshja
0
Newbie Poster
Recommended Answers
Jump to PostI don't know the answer to your question, but I do know you can easily write a table to CSV. Just pop the table in a gridview, then write each line (gridview1.rows(XXX).cells(0) & "," & gridview1.rows(XXX).cells(1) & ... ) to a text file. XXX is the number of rows - …
All 2 Replies
ericstenson
5
Posting Whiz in Training
Team Colleague
I don't know the answer to your question, but I do know you can easily write a table to CSV. Just pop the table in a gridview, then write each line (gridview1.rows(XXX).cells(0) & "," & gridview1.rows(XXX).cells(1) & ... ) to a text file. XXX is the number of rows - 1 . every time it writes a line, 1 is subtracted from XXX. If you need help writing to a text file, google :)
cutepinkbunnies
4
Junior Poster
I'm pretty sure you can. Look into executing DTS scripts from the command promt, then copy whatever you find necessary from the prompt and use it in a shell command.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.