471,084 Members | 856 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

How to pass parameters from Visual Basic to SQL Local Package

Good day to all,

My frontend is visual basic and my backend is SQL. I need to pass a date parameter to my DTS Package. What should be my VB syntax?
Here's how I call my DTS package:

Expand|Select|Wrap|Line Numbers
  1. Private Sub DTSAccess()
  2. Dim objPackage As New Package
  3.  
  4.     objPackage.LoadFromSQLServer "SQL2K-VBP", , , DTSSQLStgFlag_UseTrustedConnection, , , , "HRIS_DTSFromAccess"
  5.     objPackage.Execute
  6.  
  7. End Sub
Thanks a lot :)
Nov 17 '06 #1
0 1227

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

26 posts views Thread by Bruno Jouhier [MVP] | last post: by
10 posts views Thread by Robert Dailey | last post: by
2 posts views Thread by mrmwalter | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.