By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,057 Members | 1,407 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,057 IT Pros & Developers. It's quick & easy.

How to pass parameters from Visual Basic to SQL Local Package

P: 17
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
Share this question for a faster answer!
Share on Google+

Post your reply

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