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.

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 :)

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.