Surround the package name in double quotes

Use the xp_cmdshell with the following string:

dir \\server\share\sourcedirectory /b /a-d >\\Server\Share\targetdirectory\filelist.txt

This will create a text file of all files in \\server\share\sourcedirectory called filelist.txt in the directory \\Server\Share\targetdirectory -...

Even in MSAccess you could not rely on the recordcount unless you had accessed all records in the recordset by doing a .movelast and then a .movefirst after opening the...

It looks like your parameter mapping in the call top the stored procedure is wrong and it is trying to put the text into a parameter defined as Int -...

If you are using the stored procedure as the recordsource for a form or report, you can use the InputParameters property of the form/report to pass the data to the...

The code I posted in the first reply to this topic is a straight cut & paste from one of my systems and demonstrates passing in a date as a...

If passing a date, try passing it in dd-MMM-yyyy format - e.g. '19-AUG-2008' or '01-JAN-2000' - this works with almost every database I've tried it with - Access, SQL Server,...

In one of my previous jobs I was a one man IT team, and I had the ability to VPN in from home to sort out problems (the business was...

I've not been with Sema for over six years - I took redundancy in 2002 😀 and went to the Criminal Records Bureau for about 10 weeks, then went to...

With that surname you have to be the same Chris that worked with me for a short time at Sema in Liverpool - am I right?

If yes, how goes it?...

The M62 doesn't go up/down (except vertically) - it goes...

There is another thread in this forum with details on how to do this - to save rekeying the advice there I will just post the link!

http://www.sqlservercentral.com/Forums/Topic541274-131-1.aspx

The only way to do this sort of thing on continuous forms is by using conditional formatting - otherwise each line will have exactly the same appearence, apart from the...

Yes - I have just shown hard coded values for the sake of example - as long as the variable types match the parameter definitions in the stored procedure there...

Make sure that you have a reference to ADO set, then do it this way (this is for an Update query):

Dim cnMain as ADODB.Connection

Dim cmd As ADODB.Command

Set...