dts fail

Hi y'all,

I'm facing a database data transmission problem during synchronysing. When dts fails i need a better solution instead inconsistent data.

I'm looking for data comparer for sql server where i have total control of my actions.

Any suggestions.

THanks in advance!

DTS should not be synchronizing your database because that is job of replication but the rest of your post says what you need is SQL Compare, there are third party tools and Microsoft have one so test drive it. If you think you need replication all I have to tell you is get a very good book or you can run into serious problems. Hope this helps.

http://msdn2.microsoft.com/en-us/teamsystem/aa718667.aspx

|||

so i need a database compare tool that generates a script...Thanks!

sql

DTS / DMO

I'd like to load a few huge CVS files to an MSSQL server.
I don't want to create temporary files, instead I want to read the CVS
file from the disk line by line and after transforming it I'd send it to
the database.
Formerly I used INSERTs, but they seemed very slow.
BULK INSERTs don't work either, because the file format cannot be parsed
with bcp.
Now I'm considering using DTS or DMO, but I don't know which of them
fits my needs better. And which of them is the easier to learn and work
with from C#.
I'd be greatful for any example, or comment on using these tools.
Thanks in advance,
Gabor GludovatzDTS is definatley the way to go to here. You can use it to do
transforms if the CSV format needs to be massaged in anyway. You can
also dynamically adjust the columns that might need to be imported if
you have different file formats.
Gabor Gludovatz wrote:
> I'd like to load a few huge CVS files to an MSSQL server.
> I don't want to create temporary files, instead I want to read the CVS
> file from the disk line by line and after transforming it I'd send it to
> the database.
> Formerly I used INSERTs, but they seemed very slow.
> BULK INSERTs don't work either, because the file format cannot be parsed
> with bcp.
> Now I'm considering using DTS or DMO, but I don't know which of them
> fits my needs better. And which of them is the easier to learn and work
> with from C#.
> I'd be greatful for any example, or comment on using these tools.
> Thanks in advance,
> Gabor Gludovatz
>

DTS - Send records to different text file - DTS

Hi all,

I am designing a DTS package instead of SSIS.

I have a text file and already uploaded to tableA, there is a field named NameID in tableA. The field NameID should match the NameID in tableB and update other fields of tableA, the non-match records will generate another exception text file.

How can i implatement this in DTS? Which task or tech?

thanks

Micror

You'll need to ask this in the DTS forum. http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

DTS - Execute Package Task Problem

I have five DTS packages on a server.

Instead of executing these DTS packages individually, I have decided to create a 'parent' DTS package that will fire off each of the five 'child' DTS packages using 'On Success' precedences.

This seemed like a pretty straight forward task, but when one of the child DTS packages fails, the 'parent' DTS package continues to execute the next 'child' DTS package through the 'On Success' precedence. I was expecting the 'parent' DTS to fire off an 'on failure' precendence and stop executing

Can anyone tell me why the 'parent' DTS package continues with the 'on success' precedence after one of the 'child' DTS packages has failed.

Thanks in advance.Hi Krispy

I can't answer your question directly however I tend to use the below to execute my DTSs from code. I now include about as little as possible in my DTSs (the transformation only in fact) and wrap everything else up in a sproc.
So - the long and the short of my answer would be - perhaps look at replacing your masater DTS with some T-SQL code - makes trouble shooting and execution flow much easier IMHO.
http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS

HTH|||Thanks for the swift response Pootle Flump - much appreciated.

I did a bit of digging and found this in the SQL Server 2005 books online. I probably should have said that we are running SQL Server 2000.

Alternatively, sometimes you want the parent and child packages to fail together as one unit, or you might not want to incur the additional overhead of another process. For example, if a child process fails and subsequent processing in the parent process of the package depends on success of the child process, the child package should run in the process of the parent package.

By default, the ExecuteOutOfProcess property of the Execute Package task is set to False, and the child package runs in the same process as the parent package. If you set this property to True, you can debug only packages that contain limited functionality. To debug all packages supported by your edition of SQL Server 2005, you must install Integration Services.

Does anyone know if it is possible to set the ExecuteOutOfProcess property on SQL Server 2000, or is this specific to SQL Server 2005?