468,533 Members | 1,909 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,533 developers. It's quick & easy.

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 1194

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
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.