I completely agree. I always have SQL Search open. I use it to get to any objects I need to in the db. Love it!

JohnItech, thanks for the link but that logs me into SSMS with the same permissions as my regular account. I need to have additional permissions granted to me under...

Both accounts are local admins...we had already checked that. It doesn't even get to the point of generating the list of drives I am mapped to. ...

That's it! Works great.

Thanks a ton!

The Domain Name and SPID are in both places. I love it in the bottom info bar but would like to remove it from the tab name.

Thanks for the reply. I checked some of my old SSIS packages to see if I had used DECIMAL and I had not. I used CURRENCY (not...

Did you ever find a resolution to this problem? I would like to do a similar task where I have a wide flat file that does NOT have column...

Sorry. No I do not.

Thank you! This is a huge help. I am posting the little script I wrote (for SQL2005) for anyone's additional reference.

--To view all the packages and their...

This works beautifully! It's just what I needed.

Thank you!

I bring data from a Flat File directly into a Staging table (no changes or validation done on the data at all). I want the staging table to have...

You're absolutely right that I'm using a Script Component in Data Flow, not a Script Task in Control Flow. Sorry about not noticing the difference in the thread.

Does...

Thanks for the quick response!

I added "Imports Microsoft.SqlServer.Dts.Runtime" and when that didn't fix the problem I also added "Imports Microsoft.SqlServer.Dts.Pipeline" to see if that would fix it....

I am totally new to VB.NET. I have stolen the code in this string to execute a stored proc from a Script Component, but I'm there are...

That worked perfectly! Just what I wanted. I just needed to think outside the box I was in.

Thanks for your help!