Reply to Re: ssis EXEC command

Your name:

Reply:


Posted by gelangov on 08/24/07 12:25

On Aug 23, 5:42 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (gelan...@hotmail.com) writes:
> > I certainly will appreciate your input if you don't mind...I was
> > heistating since it looked very ugly:
>
> It could have been a little easier if you had made it as attachment.
> Maybe then it would be possible to open it in BIDS? I first tried IE,
> and it appears that there line breaks in the wrong place etc.
>
> In any case, the only query I found was this one:
>
> Exec ('select dbo.fntrim(column_name) as
> col from information_schema.columns&#xA;where table_name =''' +?+'''
> and Column_name &lt;&gt;''Clientlocid'''&#xA;
>
> which is different from the one you posted.
>
> Reviewing the thread I see that you never posted the error message you get.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

I wanted to send it as an attachment. I do not see that there is an
option to attach files through this group. This is the error message
I get:

"Syntax error, permission violation, or other nonspecific error".

Thanks.

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация