See this link.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_8jfp.asp

I came across this site a while back and it helps me to script out my stored procedures in one go. This link is to the dts package script. I...

I think you will find that even though you were passing in "01" it was still treating it as 1.

If you put in an insert into a table in your...

Take a look at this link. It enables you to set source and destination properties at run time. I am guessing that you want portable dts packages. I use this...

I am almost certain it is because you are supplying single figures.

I.E in your example you get 8/1/2004.

You need to put some logic in to change this so it becomes 08/01/2004.

Whoops. Misread completely.

To execute the package from vb, use the following code. Note that the variables on the package are populted by using index in the code.

Also, the package is written using...

A starter for you.

Variables are designed to hold one value at a time, whereas temporary tables contain rows and rows of data. You could if wanted to, assign a row...

As far as I know there is no similar capability in ms access. Unfortunately, the whole db must be backed up (.mdb file).

The alternative you have are:

1. Use ms access...

Try this:

declare @inputstring as nvarchar(50) -- postcode input

declare @outputstring as nvarchar(50) -- postcode output

set @inputstring = 'WC1 2lf'

select @outputstring =

case when left(@inputstring,2) like '[a-z][a-z]%'

then left(@inputstring,2)

else

left(@inputstring,1)

end

select  @outputstring

You can do this...

I can't see how yopu hope to achieve this. How will dts know which columns to map?

You are going to have to use activex to provide the logic behind...

If you are talking about adding screens with logic behind them, then the answer is no. There are a few tools in sql server such as enterprise manager, which allow...

Sounds to me like a permissions problem. Are you scheduling these dts packages through sql server agent?

What error/s are you getting?

I don't know much about security issues with firefox, but from a user point of view I find it a lot better to use than IE. Searching on the page...

Can't see anything wrong with your coding at all.

However , 'sSecondLineHeader = sSecondLineHeader ' could be causing a problem. I have encountered problems before when trying to re-assign a local...