Prasad Boppana (11/20/2009)

---

I should be able to run multiple SQL statements in one EXECUTE SQL task right? I need to populate multiple staging tables. I'm planning to use stored procedures...

You don't need to create 2 packages for this, you can have both of them in a single package.

At this point, there is not much I can help on the...

MTY-1082557 (11/20/2009)

---

I read some articles where they mentioned I can upgrade the version with:

/wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

I didn’t find any advice regarding a database in production...

AVB (11/20/2009)

---

I was reviewing activity thru the activity monitor trying to determin why my CPU is @ 99%....anyways I noticed a process with a large wait time. This process shows...

Open the package in the BIDS, right click anywhere in the background of the control flow and select the first menu option is logging. Configure SSIS Logs window appears and...

There can be some other reasons for this strange behavior, so I would suggest you enable logging of the package (if not done already) and look for some information that...

Look in the Job Activity Monitor under SQL Server Agent node. That must show you the jobs that are running and that may help you.

Please post some sample data as mentioned in the below article

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

It would help us to understand the data in the underlying table and also start working on solving the query...

pdevadiga (11/20/2009)

---

Hi,

I have a client who is running a production DB ABC around 250 GB and I found that

the DB has 3 datafiles. This is a database on SQL...

I still can't open the attachment, as soon as I click on that IE browser opens with...

Can you explain how are you doing it currently?

I guess you must be using SSIS, if so, have you used multicast transformation???

Could not open the sqlplan attached...

Hi,

I think the connection properties from Access to SQL Server have to be set, I found this steps in Microsoft office web site. Give a try and let's see if...

I am with Jason, to help better the performance of the query, somemore info is needed about the underlying tables and so on....

Before you get back with the underlying table...

Glad I could help 🙂