I have converted a package script to vb6 to vb.net and it compiles fine. But when I go to run it I get this error. I have checked the www.sqldts.com site and they stated that I need to upgrade SQL Server with service pack 2. Well mine is upgraded with service pack 3 and its still happening. I...
I have this package script generated from sql server in vb. I really need the VB.NET equivalent. I tried re-writing it for vb.net but could get around how to work the connection properties i.e. "oConnection.ConnectionProperties" as this isn't liked by .net. So really if someone...
I have this package script generated in sql server. I really need the VB.NET equivalent. I tried re-writing it for vb.net but could get around how to work the connection properties i.e. "oConnection.ConnectionProperties" as this isn't liked by .net. So really if someone could write...
Can someone please help. I wish to import a text file using DTS. I need some code to run within VB.NET where i can set a variable to the text file name and then execute the package within vb.net to import the data using DTS into sql server 2000.
Any ideas would be helpful??
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.