Hi MM

The error occurs when you use the proc in an OLEDB Source, within a data flow. ExecuteSQL tasks are not affected, as far as I know.

I did this, using...

Comment removed - it was wrong!

You did not answer my first question and your error message was not the exact error message which you received.

If you provide only snippets...

Munabhai (7/9/2013)

---

I have 1000 text files in one folder, text files have 2 or 3 or 4 column. Now I need to load those text file in sql server tables,...

The package failed with a registry-access error while you were performing an import?

What was the error message?

Sorry about that...

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?