I got

CREATE TABLE #AAAAAAAAAAAAAAAA

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '#AAAAAAAAAAAAAAAA'.

Hello Keon,

I open the view code from the solution explorer and reviewed the XML code. I have 5 different variables that I am using to store long T-SQL code with...

Lynn,

Thank you again for your time, I greatly appreciate it.

Tim

Lynn,

I appreciate the information. The packages that you have with this informational message, are they not affected but scheduling the package for automation, like Zeke or SQL Server Agent? I...

sp_columns TableName is less typing then select * from table name, which I do agree Alt + F1 would be easiest. 🙂

Hello Kenneth, Nice Post/Question.

I like using CHAR(39), help prevent injection. I know there isn't any concern in the answer but I thought I would share it.

DECLARE @topsql NVARCHAR(2000);

SET @topsql =...

Okay, Well I am sorry I was unable to help. Maybe next time. I wish you the best of luck with the Google-Fu, maybe roll the dice on Bing-Fu? 😛

I am sorry to hear the problem has reared it ugly head. Can you provide an error message(s) you are getting from SSMS when the query fails, please?

Could this be...

I also develop databases across multiple servers, via linked server and open query. So I read any articles that involve linked servers (this is my favorite as well). So if...

This expression will work with spaces in the folder location.

"-min -m -en " + "\"" + @[User::UnZipFileName] + ".ZIP \"" + "\"" + @[User::UnZipFileName] + "\""

Thanks for the link, I have downloaded it but how did you use this with SSIS to import the 834 files into SQL Server database?

Hello,

Yes, any help would be great. I would like to do the samething. I would like to use SSIS to import EDI 834 files into a database. Any assistance...

@logitestus,

Due to your help and ideas, we have a solution and here is the winning expression that is working for me.

"-min -m -en " + "\"" + @[User::UnZipFileName] ...

I greatly appreciate your time and no worries I understand being busy. So I want to know that first. I have not tested this but I will reply once I...

Do you have access to Microsoft Expression Test tool? It can be downloaded at

http://expressioneditor.codeplex.com/

But this expression does not evaluate, it geives an error message