Then you either do not have it large enough for your largest data from the Excel file or you have the wrong column. If the sheet name varies then I...

quote:

---

Thats a lot of growth! Might try stopping service and deleting tempdb (rename the mdf is safer), let SQL create a new...

Query optimizer is stumbling somewhere. If you have an index you may have out of date statistics causing this or the index is fragmented or any of serveral other issues.

As...

If you can post to the other system you could instead write the XP to take the input directly for the new row and send to the remote system using...

Besides memory allocation is costly compared to already being owned. If something else needs and the memory is not currently in use the OS will make this determination.

Unfortubnately this snippet isn't much to go on. Try rebuilding the transaformation from scratch or build a new copy of the page and see if the problem persists.

Open each questionable package and then the package properties. Turn on logging in the package properties (varies depending on you version but look at all the tabs it is quite...

As for the 255 when the transformation is built the default value for the new column is 255 nvarchar on an import of excel. On the destination table you can...

Not sure how much trouble but you could potentially get the handle of the EM window and add your item to the context menus but I have never tried this....

Generally thou when data is submitted with an enter in the string it is both the Carriage Return (13) and Line Feed (10) characters so you may want to do...

And if you can do it in SQLPlus to access all DBs on the same instance then you can use a single connection object in your DTS package.

Can you give a bit more detail on what you will see and what it should return based on the ex. BA/10 are you meaning Basic Pay with 10...

Try this or fix as needed as I am guessing to you needs.

Use YourDBNameHere

GO

EXEC sp_change_users_login 'Update_One', 'SQLDEVELOPERS', 'SQLDEVELOPERS'

GO

No but from what I have seen on Geek.com (they apparently have some) they are supposed to be monster on speed and performance. But the cost is way out there,...

Or better to prevent the extra updates that will occurr do to the trigger wrap the logic in a Stored Procedure instead of writing to the table and get the...