Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JCAD1
  • Order by date
  1. JCAD1

    Very urgent help required

    I have over 100 child packages, each designed to load a specific flat file into its own table due to differences in the structures of the data. I am trying to call each child package from the parent package by pointing the latter to the former in the File System using Execute Package Task that...
  2. JCAD1

    Urgent help on importing XML data using T-SQL

    May I take this opportunity to say thank you once again to gmmastros for his solution to the above problem. I am now applying it to a real situation in which I receive large XML files and am required to import them into SQL server 2005. I have written a script (similar to the above) to import...
  3. JCAD1

    Urgent help on importing XML data using T-SQL

    I am testing a script I have just written to import some sample xml data into a SQL table. The import is done in two stages: the first stage imports the xml file into a sql table and the second, parses out the file into a relational format and then imports it into a second table. The imported...
  4. JCAD1

    Very urgent help with BCP required

    I am completely new to SSIS and am using BCP to import some text data into SQL Server 2005. It works fine but when you look at the imported data in the table, you will see that some records are not correctly imported. The problem is that the data includes commas which are being interpreted in...
  5. JCAD1

    Urgent help on SSIS package

    Ousoonerjoe, Thanks for your reply. I did alter the existing source and run the package a few times without success before resorting to creating the new source. Three other things to point out: (a) the location of the data file has not changed – only the name of the file has changed, (b) I am...
  6. JCAD1

    Urgent help on SSIS package

    I am new to SQL Server Integration Services and having problems loading some data into the warehouse using an SSIS package which was created by someone who has now left the organisation. When I run it, the following error occurs: [Flat File Source [215]] Warning: The system cannot find the path...
  7. JCAD1

    Interpreting a dynamic SQL code

    Thank you nickdel and gmmastros for pointing me in the right direction. I am now manually running the stored procedure (usp_DM_Stream_Process ) that is being called by the code I posted earlier. If it fails or can't make sense of it, I will send you the code for the procedure. Once again...
  8. JCAD1

    Interpreting a dynamic SQL code

    Hi there, I am new to dynamic SQL but have an urgent problem concerning a job that was created by someone who has since left the organisation. The job is scheduled to run every night but has been failing since the beginning of October. It consists of the script given below and I have no clue as...
  9. JCAD1

    Challenging SQL problem

    Terry After amending the code and indexing attdate and id as suggested, I ran the query and this time it took just one minute to complete. Excellent! Thank you so much for your help. I also want to thank Karl for his contribution. Jcad1
  10. JCAD1

    Challenging SQL problem

    tlbroadbent I tried to apply the code you have provided to the table and it ran for over 1 hr. I stopped it and created a new table with a few records to test the solution. It worked brillantly, 'doing more than what it says on the tin!' My problem is sorted! However, the orginal table has over...
  11. JCAD1

    Challenging SQL problem

    I have a table (op) with the following fields: id, attdate, refdate and attend. If I want to see many occurences of id records, I can use the following: select id, count(*) from op group by id having count(*)>1 Now if I want to see the details of just one record, I can use id and order by...
  12. JCAD1

    Very challenging delete SQL statement

    Having applied the suggested solution by vongrunt to remove duplicate primary key values (which has worked fine), we still have some more duplicate records in the table. This time, we have two types of duplicate records: (i) In addition to the primary key, most of the other fields have...
  13. JCAD1

    Very challenging delete SQL statement

    Vongrunt & Skuhlman I have tested both solutions you have given and they work brilliantly. Thank you so much for your help. JCAD1
  14. JCAD1

    Very challenging delete SQL statement

    We have a table into which data is loaded from an external source. The problem is that it contains duplicate, triplicate, etc primary key values, of which we want to delete invalid records and leave just one valid record, i.e with a unique primary key (id). We cannot do this while the data is...
  15. JCAD1

    VERY URGENT SQL 2000 PROBLEM!

    I have got two tables. Table1 is a temporary table where data is gathered, manipulated and used to update table2 (i.e. after data is manipulated, it is copied across to table2 where it’s stored permanently). Here is the code for creating table1: create table table1 ( newid varchar (50), id...
  16. JCAD1

    Very urgent SQL problem!

    Thanks for your help. I have been busy with another project but am now turning to the SQL problem you're helping me to solve. I am trying to modify and test your code on real data. So far so good! I am getting the idea and would be most grateful if you could finish off the remaining bits...
  17. JCAD1

    Very urgent SQL problem!

    No one has responded yet. I would be very grateful if you could code step 2 for me please. I am testing the one you have coded so far (Step 1) with real data and it is spot on. Thank you for your time.
  18. JCAD1

    Very urgent SQL problem!

    I am really struggling to write a T-SQL program to update a table in SQL server 2000, using two other tables. I have been trying for one week now but to no avail. The code for creating the table being updated is as follows: create table acIPLeicsUpdate (NewNHSNumber varchar(10)...

Part and Inventory Search

Back
Top