Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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

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...

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...

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...

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.

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)...