Fragmentation?

Didn't think it was really possible. Thanks for the suggestion

Yeah what you are saying is true.

I have manipulated the data as it comes in by converting to char and it works fine

My problem is, is that I am migrating...

Also

if i preview the data in DTS it shows the date like this 2010-01-01

When i use a dataviewer in SSIS it shows the date like this 2010/01/01 12:00:00AM

This happens for...

I Am using SSIS and DTS Respectively

When I use DTS and draw the data into the table it does not add the 00:00:00

When I use SSIS and draw the data...

steveb. (11/25/2009)

---

Do you have a clustered index on this table/heap ?

As stated above the problem with speed would most likely be due to the fact that you are...

I run a cursor through another table and then i

Insert Into Table1

Select distinct Uniq,ltrim(rtrim([Name])) from kri.dbo.SeperatedListTable(@info,@uid,' ')

SeperatedListTable is a table-valued function that spilts up a line of text...

Hi

I tried to see what the difference was between the two tables and after a while I realised that 'Table1' on 'Database1' was populated through SSIS and 'Table1' on 'Database2'...

No it's in full recovery mode

The problem with using delta operations is that I am drawing from a DB2 DB and SSIS only allows for a lookup transformation from a SQL Server source, to do...

Hi

I have just one more question, I hope

I have now implemented a complex package without using staging tables and it works prefectly.

I am now busy on another package which is...

Thanks Guys for all the replies.

I am currently currently changing one of my more complex existing packages that does use staging tables to mainly using transformations. There are times where...

Please note that you don't necessarily need to use staging tables becasue of complex queries. Moving a pacakge that uses a staging table to not need one should not change...

John Rowan (8/20/2009)

---

Rowan,

A couple of things. First, I like you name! Secondly, all of the advice given here is spot on. One thing I'd like to...

Sorry, I did not complete point 2) of my reply. Here it is

2)Could I maybe, using a linked server use the 'Lookup Transformation' and 'Conditional split' tasks in SSIS, to...