As a different tack, is there any reason they have to be seperate packages? I have found that the superior structure of SSIS with sequence containers allows multiple sql 2000...

"If I just join these five views together I can select the three colums I want."

which leads to

"Why does this application run so slowly?"

Never mind that they are complex, many...

If you have joins in your data selection query you may be producing duplicates that way, so check by running the query in management studio and note the number of...

One added DBA area for praise is rescuing a bought-in supplier-installed system that you haven't been allowed to touch because "it's been set up by the supplier so it's fine"....

I don't do social networking at all. The nearest I get is regular use of a forum for my sailing hobby and the joy of that is we meet in...

I'm also an oldie who likes a good book - I found books on MS Word for Windows version 1 and DBASE 3 recently in my garage!

I prefer to look...

I just script my stored procs off the two servers to text file and use WinDiff to compare side by side. No cost. No hassle.

Compulsory flexitime would be a great benefit to all - you clock in and out, but when you work over you are credited with the time and can take it...

Is it groundhog day? 😀 If so I'll repeat last week's post and call for stored proc to be organised into folders within the database.

Purging of stored procedures is usually because there are so many it is difficult to see the wood for the trees! If they could be divided into sub-directories in the...

Coincidentally we had something similar yesterday - we have a desk re-arrange and move planned to make space for works and the debate on when to do it ended up...

Divide your registered servers up into groups (right click in registered server and add new server group) so they group together eg Dev, test and live groups.

Then repeat the registration...

Today I'm delighted to see that the article which annoyed me with bad grammar and lack of spell checking has been pulled for plagiarism.

The original was written in good...

Just bear in mind that not everyone posting here has English as a first language, or even maybe as a second language. How good's your Spanish spelling and grammar? (as...

jmohan_it (12/23/2008)

--------------------------------------------------------------------------------

Any one can tell. what ia a breakpoint in ssis? How is it setup? How do you disable?

Have you looked through Books Online, specifically the sections on SSIS?

--------------------------------------------------------------------------------

Gail...