Member Avatar for Pareshja

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.

  • 3 Contributors
  • 2 Replies
  • 97 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by cutepinkbunnies
Member Avatar for ericstenson

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

Member Avatar for cutepinkbunnies

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.