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

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

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

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

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

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

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