Thanks for your patience and help!

I have changed RETURN to RETURN @MyDir, and have added RETURN @MyDir before END, but get this error:

Msg 178, Level 15, State 1, Procedure Dir,...

I have tried a view different options, but I keep getting errors.

Where in this code should I add your line of SQL:

--and insert the properties into a table

INSERT INTO @MyDir...

Thanks. Yes I copied it from the web but tried to fix it best possble.

I now get this error:

Msg 455, Level 16, State 2, Procedure Dir, Line 145

The last statement...

Can you perhaps see what the problem with my second error is:

Level 15, State 1, Procedure Dir, Line 144

Incorrect syntax near the keyword 'INSERT'.

It is in this part at...

Thanks!

Hi Andy,

Thanks for getting back to me. I am really excited to do your lessons!

Corné

Once again; thanks for all your assistance!

Thanks! Does SSIS only come with the full server packages, i.e. SQL Server 2008 etc.? or would I be able to run it off SQL Server Management Studio 2008?

Appologies for...

Hi there. I have had a look at the Stairways articles about SSIS, and I am sure this will work. However, I am having great difficulties finding out what software...

Hi Andy,

Thanks for the informative articles!

One quick question: what software application do you use? I have googled and googled, and googled some more. I am using SQL Server Management...

Hi Andy,

Thanks for the informative articles!

One quick question: what software application do you use? I have googled and googled, and googled some more. I am using SQL Server Management...

Great! Thanks for your help!

Thanks for the responce. I unfortunately have no idea what you are saying!

My SQL knowledge is limited to writing basic queries, or to update and replace data etc.

Could you...