Open File - Security Warning

I have a SQL job that calls a command file that executes a vbscript. I am getting "Open File - Security Warning" whenever the command file calls the vbs as it goes through a loop. Is there a way to suppress the warning dialog box?

Thanks!!

This is a SQL Server Integration Services forum. Are you using SSIS in this issue?

If not, you might want to try the SQL Server Database Engine or Transact-SQL forums.

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

Open Connection

Hi to all,
I know that we should close sql connection when it's complete its job for
performance and sql server's resources. But i can't find article or text
for
this subject on the internet. Or i know not true?
Could you share with me if you have like this article ?For internet applications you should use connection pooling, and close your
connection as soon as you are finished. The provider (or driver) will
automatically keep the connection open for you and re-use it if you open
another connection using the same connection string within the connection
pool timeout period. Just search for "SQL Server connection pooling" and
I'm sure you will find more information
"Erencan SAIROLU" <erencans@.hotmail.com> wrote in message
news:uaeY1jc%23GHA.5092@.TK2MSFTNGP04.phx.gbl...
> Hi to all,
> I know that we should close sql connection when it's complete its job for
> performance and sql server's resources. But i can't find article or text
> for
> this subject on the internet. Or i know not true?
> Could you share with me if you have like this article ?
>|||Thank you Brain
"Brian Pursley" <bp@.cinlogic.com> wrote in message
news:eS5EPNj%23GHA.4800@.TK2MSFTNGP05.phx.gbl...
> For internet applications you should use connection pooling, and close
> your connection as soon as you are finished. The provider (or driver)
> will automatically keep the connection open for you and re-use it if you
> open another connection using the same connection string within the
> connection pool timeout period. Just search for "SQL Server connection
> pooling" and I'm sure you will find more information
> "Erencan SAIROLU" <erencans@.hotmail.com> wrote in message
> news:uaeY1jc%23GHA.5092@.TK2MSFTNGP04.phx.gbl...
>

Open Connection

Hi to all,
I know that we should close sql connection when it's complete its job for
performance and sql server's resources. But i can't find article or text
for
this subject on the internet. Or i know not true?
Could you share with me if you have like this article ?For internet applications you should use connection pooling, and close your
connection as soon as you are finished. The provider (or driver) will
automatically keep the connection open for you and re-use it if you open
another connection using the same connection string within the connection
pool timeout period. Just search for "SQL Server connection pooling" and
I'm sure you will find more information
"Erencan SAÐIROÐLU" <erencans@.hotmail.com> wrote in message
news:uaeY1jc%23GHA.5092@.TK2MSFTNGP04.phx.gbl...
> Hi to all,
> I know that we should close sql connection when it's complete its job for
> performance and sql server's resources. But i can't find article or text
> for
> this subject on the internet. Or i know not true?
> Could you share with me if you have like this article ?
>|||Thank you Brain
"Brian Pursley" <bp@.cinlogic.com> wrote in message
news:eS5EPNj%23GHA.4800@.TK2MSFTNGP05.phx.gbl...
> For internet applications you should use connection pooling, and close
> your connection as soon as you are finished. The provider (or driver)
> will automatically keep the connection open for you and re-use it if you
> open another connection using the same connection string within the
> connection pool timeout period. Just search for "SQL Server connection
> pooling" and I'm sure you will find more information
> "Erencan SAÐIROÐLU" <erencans@.hotmail.com> wrote in message
> news:uaeY1jc%23GHA.5092@.TK2MSFTNGP04.phx.gbl...
>> Hi to all,
>> I know that we should close sql connection when it's complete its job for
>> performance and sql server's resources. But i can't find article or text
>> for
>> this subject on the internet. Or i know not true?
>> Could you share with me if you have like this article ?
>

open a web page through SQL SQL job

Hi all,

now, i create a job to open a page on timely basis. The job's Vb script is like that:

Dim WshShell
Set WshShell =CreateObject("WScript.Shell")
WshShell.Run ("http://www.google.com")
Set WsShell = Nothing

when i run that job, i got that error:

The job succeeded. The Job was invoked by User host\username. The last step to run was step 1 (Step 1).

how can i solve it? i still don't know whether that script will open a webpage or not

The following script opens a webpage in a VBS Script:

Dim WshShell
Set WshShell = CreateObject("WScript.Shell")
WshShell.Run "iexplore.exe http://www.google.com"
Set WsShell = Nothing

|||

I think that one will work in web page. But, now i m trying in SQL job. I have tried with that code. But, nothing happen.

regards,

|||It seems to be impossible to open a website through SQL Server, neither using SQL Agent Job (ActiveX script task), nor using xp_cmdshell. I tried both, and the IEXPLORER process can be started (you can check in Task Manager) and then hung, waiting for some response. I guess this is becausexp_cmdshell operates synchronously. Control is not returned until the command shell command completes. And the SQL Server can't proceed with reponse from IEXPLORER process so both IEXPLORER and SQL Server hangs.|||so, how abt calling a bat file. And then, through bat file, call the web page. is it the possible way?

Only One SSIS Job Runs...

Hi,

Currently I have two SSIS jobs on my machine. The problem I'm having is, only one of the jobs executes succesfully, the other one fails for incorrect user login. Both jobs use the same configuration database and all the packages on both jobs have the protection level set to "DontSaveSensitive". Both jobs have been deployed in the exact same manner, yet only one succeceeds and the other fails.

Can anybody tell me why this is going on?

J.Suazo wrote:

Hi,

Currently I have two SSIS jobs on my machine. The problem I'm having is, only one of the jobs executes succesfully, the other one fails for incorrect user login. Both jobs use the same configuration database and all the packages on both jobs have the protection level set to "DontSaveSensitive". Both jobs have been deployed in the exact same manner, yet only one succeceeds and the other fails.

Can anybody tell me why this is going on?

I would suggest to double check....take close look wehre the error is happening. Are the 2 jobs calling the same package?

|||

Hi Rafael,

Thanks for your reply.

1. The packages fail when acquiring my sql server connection. The error I'm getting says that the connection is not configured correctly or I may not have the right permissions. That is bogus, the packages on my other job have the same connections and the same permissions and they don't fail.

2. Both jobs call completely different packages.