SQLServerCentral / Discuss Content Posted by Brian Knight / Article Discussions / Article Discussions by Author / Executing a Package from Visual Basic / Latest Posts

RE: Executing a Package from Visual Basic

jbg1978 — Fri, 09 Jan 2009 16:19:53 GMT

I have .NET 2008, but not sure about the Client Components. How can I confirm installation/install that?

RE: Executing a Package from Visual Basic

Matt Miller (#4) — Fri, 09 Jan 2009 15:16:09 GMT

My first thought would be - what version of VB? in 2005 and 2008, MS got picky as to what feature you could get to depending on the version. I don't think you can get to it unless you have the SQL client components installed AND you have VB.NET pro or better.

RE: Executing a Package from Visual Basic

jbg1978 — Fri, 09 Jan 2009 15:14:22 GMT

Anyone have any thoughts as to why the Microsoft DTS reference wouldn't be available in VB?Thanks

RE: Executing a Package from Visual Basic

Alan MacNeill-274841 — Mon, 21 Aug 2006 08:38:00 GMT

This is a good example of calling a 2000 DTS package.

What is the logical equivalent for a 2005 Integration Services package? Since they aren't necessarily stored on the server, is there a trick?

RE: Executing a Package from Visual Basic

janusz pazgier — Mon, 21 Aug 2006 05:27:00 GMT

Create your DTS package and save it as VB script, next open it in VS2003 or VS2005 and allow VS to convert it. After that you will have all you need to run package from .Net language. You will have some error to fix because the conversion is not fully valid but they are very easy to fix. You can use this created code to not only run package from your application but you can also create it from your application.

Thanks

RE: Executing a Package from Visual Basic

bruce spinner-349795 — Fri, 18 Aug 2006 09:24:00 GMT

This is just a general question. This example may work if you are using VB6 but what about us that use c# and the .NET 2.0 framework? If there is a way to execute an SQL 2000 DTS Package in .NET 2.0 I have yet to figure it out.

RE: Executing a Package from Visual Basic

janusz pazgier — Fri, 18 Aug 2006 07:29:00 GMT

If your process is long time running process maybe you can send email to client when it is done. DTS package has this possibility or you can use SQL command inside DTS package to send e-mail from SQL server

Thanks

Janusz

RE: Executing a Package from Visual Basic

Mohd Haneef — Sun, 23 Jan 2005 12:00:00 GMT

Hi Brian,Example is really great to get kick off with DTS package stuff.Can you explain further, [Global Input Paramerter in DTS] which we set ,,,,,, instead of passing it through VB application can i make it pass through SQL itself (lookup from another table) so tat i can use specified DTS package at schedule. instead of making an exe and running it as service.

RE: Executing a Package from Visual Basic

Mark Wismar — Mon, 07 Jun 2004 08:57:00 GMT

Hi Brian,

I have many long running dts packages and need a way to notify the client of how many rows have been read. I have played with the On Progress event but my package just freezes up when I check this event.

Another nice feature that I want to add is the ability to cancel a package once it starts.

Any ideas.....

Thanks for your help

RE: Executing a Package from Visual Basic

tinawx — Mon, 26 Jan 2004 19:17:00 GMT

Hi Brian,

Thanks for the great website.

I have a Vb program which needs to call a DTS to load some data into SQL server from a text file. I managed to execute the DTS, but I couldn't get any return from DTS, so don't know if my data is loaded correctly unless I check from SQL server. Could you please explain how to solve this problem? Thank you very much!

Tina from Singapore

RE: Executing a Package from Visual Basic

amitsanatshah — Sat, 24 Jan 2004 02:18:00 GMT

Excellent !!!

Good job to describe in few lines

Can I use this variables as a parameter to my SQL server Query for downloading the data

Thanks again

AMIT

RE: Executing a Package from Visual Basic

alexx — Fri, 23 Jan 2004 06:08:00 GMT

good for start, but if I have more complex dts...may be I can create a job and after execute it from vb.exe with

"sp_start_job @job_name = 'My Job'"

using and ADO connection and execute it.

RE: Executing a Package from Visual Basic

rmills80 — Fri, 18 Jul 2003 10:59:00 GMT

This article is a good start for my project..I am transforming data from a query to a .csv file and I need to programatically change the name of the results filename. I feel that I can utilize the Global Variable function to do this...I need to control the name of the textfile via ASP.

Executing a Package from Visual Basic

Brian Knight — Sun, 20 Jan 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/executingpackagefromvisualbasic.asp