Yes, you are right!! I will ignore this request from the Client!! Kind Regards
Hi Twan, Yes, I've just realised this!! How would I return the resultset? Kind Regards
Chappy,<br />Thought I would add...<br />Yes, there is a reason for returning a string - unless you think there is a better way [<img...
Thanks Chappy, Twan. Points taken. I'll amend as necessary. Regards
Hello, I have the following SP which takes in a date input parameter and exports a string which is made up of a returndate, Action, Total and...
Hi Group, During installation of SQL 2000, one of the options was to use an existing server or create a new Server. I chose new Server (with the...
Thanks Chopeen, I was able to work something out... Thanks for all your help. The DTS is a very good tool!!
Hi All,<br />I've worked it out!! It was the data source.<br />For your reference in case you have a similar issue, I tested the Transformation that...
Hi Group,I get the following error when I run my DTS Package. The number of failing rows exceeds the maximum specified. TransformCopy...
Thanks Chopeen. I've now posted the data. There are a couple of things which I will need to amend: 1. I've got a field where the data should be...
Not to worry Chopeen - I worked out how to achieve this. Now to inspect the results!! Thanks for your help. Kind Regards
Thanks Chopeen!! That worked!! Just one more thing and I think the import will work - thanks to you!! I've got columns in the destination table...
Thanks chopeen!! I seem to be getting somewhere. However, there are some validations which I need to carry out e.g if one of the date columns is...
Yes. How do I select the fields from the Excel sheet to append to the SQL table? Regards
I've started to create a DTS Package. What task will I need to choose to achieve what I am after. I will need to do an insert into the SQL table....
Sorry, I forgot to add that the column names in the Excel Spreadsheet are different to the column names in the SQL table. Also, they are not in the...
Hi Group, I have an existing Excel spreadsheet and I need to APPEND this information to a table in SQL. I would like to do some formatting around...
Hi Group, I've just installed SQL 2000 on top of a SQL 7.0 installation(beta)!!. I got the SQL Server does not exist access denied error so I...
Thanks FrankKallis, Satya!!
Hi Group, I've installed SQL 2000 on my machine, however the existing SQL is version 7.0. I can connect to the version 7 database. My questions...
Separate names with a comma.
