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'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.
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.