Alex Friedman (7/9/2013)

---

SSMSBoost comes with a toolbar, and one of the buttons...

Alex Friedman (7/9/2013)

---

Phil Parkin (7/8/2013)

I have SSMSBoost (very useful) but had not, until today, tried to create custom macros.

I spent some time looking through all of the available commands and...

Thank you, MM, for taking the time to read and answer my post.

The solution you propose works fine if the SQL Server database engine is 2008R2 or below.

But it fails...

SQL Muscle (7/8/2013)

---

Phil Parkin (7/8/2013)

---

This is exactly the technique I use in long 'utility' scripts and it works very well. I generally leave everything commented out until I need it,...

Alex Friedman (7/8/2013)

---

lshanahan (7/8/2013)

---

Neat trick.

There is one additional thing I would like to be able to do though: select a block of text and then use a keyboard shortcut (like...

This is exactly the technique I use in long 'utility' scripts and it works very well. I generally leave everything commented out until I need it, in case someone drops...

Can you convert the .xls to a .csv? It would make your life easier.

Not sure, but this may be a 32/64-bit issue. Can you try running the package in 32-bit mode and see whether that helps?

Where are you executing the package?

I think you'll need to write some code. Here[/url] is a starter - you'll have to expand on it to get it doing what you want.

Although it looks like this will work, SSIS is not...

If you can enforce a common column-naming / data-typing format on all of the Excel files, you have a chance of using SSIS and looping to...

Sri8143 (7/5/2013)

---

Implement a function with below logic in an efficient way ...Pass @var1 and return @var2 ...How can it be done as it does table scan now ??

DECLARE @Var1 VARCHAR(10)

DECLARE...

No problem.

Within the SSIS data pipeline, there is not really a concept of table names. The source data values are copied to in-memory variables which then flow through the pipeline...

(clutching at straws...)

One thing worth checking: try changing the tilde (~) to something else (eg 'x'), just in case it is being interpreted as a special character. It does have...