Can't send out mail if Outlook not open ?

Dear experts,
In my server, I have created a scheduled task that use SENDMAIL to send some
reports to my boss email ... but I find that if the mail cannot send out if
the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
we have a few days holiday) ...
So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
is closed ? if so, can someone tell me how to solve this problem (except
ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
!!!
Some versions of Outlook require keeping Outlook open for
SQL Mail to work correctly. You may also want to refer to
the following articles:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
One way around this is to not use Outlook, MAPI for mail and
just use smtp. You can download an extended stored procedure
to send mail using SMTP. You can find the download and more
information at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Sun, 3 Oct 2004 19:31:09 -0700, "Devil Garfield"
<DevilGarfield@.discussions.microsoft.com> wrote:

>Dear experts,
>In my server, I have created a scheduled task that use SENDMAIL to send some
>reports to my boss email ... but I find that if the mail cannot send out if
>the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
>and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
>we have a few days holiday) ...
>So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
>is closed ? if so, can someone tell me how to solve this problem (except
>ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
>!!!

Can't send out mail if Outlook not open ?

Dear experts,
In my server, I have created a scheduled task that use SENDMAIL to send some
reports to my boss email ... but I find that if the mail cannot send out if
the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
we have a few days holiday) ...
So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
is closed ' if so, can someone tell me how to solve this problem (except
ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
!!!Some versions of Outlook require keeping Outlook open for
SQL Mail to work correctly. You may also want to refer to
the following articles:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
One way around this is to not use Outlook, MAPI for mail and
just use smtp. You can download an extended stored procedure
to send mail using SMTP. You can find the download and more
information at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Sun, 3 Oct 2004 19:31:09 -0700, "Devil Garfield"
<DevilGarfield@.discussions.microsoft.com> wrote:
>Dear experts,
>In my server, I have created a scheduled task that use SENDMAIL to send some
>reports to my boss email ... but I find that if the mail cannot send out if
>the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
>and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
>we have a few days holiday) ...
>So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
>is closed ' if so, can someone tell me how to solve this problem (except
>ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
>!!!

Can't run Stored Procedure

I am trying to run a stored procedure from an SQL task:

First, here is the proc (execs fine in : SSMS query)

CREATE PROC [dbo].[sp_Hist_Max_Dates]

@.Interval varchar(8),

@.Name1 varchar(32),

@.Max_Date datetime OUTPUT

AS

IF @.Interval = 'd'

BEGIN

SELECT @.Max_Date = MAX(Max_Daily_Date) FROM SiteTable WHERE Site_Name = @.Name1

END

ELSE IF @.Interval = 'm'

BEGIN

SELECT @.Max_Date = MAX(Max_Monthly_Date) FROM SIteTable WHERE SIte_Name = @.Name1

END

Here is the call from the Execute SQL Task:

EXEC sp_Hist_Max_Dates ?, ?, ? OUTPUT

Here are how the parameters are defined in the Execute SQL Task:

gv_VarInterval INPUT varchar 0

gv_Name1 INPUT varchar 1

gv_MaxDate OUTPUT datetime 2

(Variables used as input parameters defined as strings with package scope)

Here is the error I am getting:

[Execute SQL Task] Error: Executing the query "EXEC dbo.sp_Hist_Max_Dates ?, ?, ? OUTPUT" failed with the following error: "Error HRESULT E_FAIL has been returned from a call to a COM component.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

The connection is just OLEDB to SQL Server 2005. Any ideas why is this not working?

Thanks!

Kayda

Try adding the parameter name (as declared in the SP) and the '=' sign to the SQL command:

EXEC sp_Hist_Max_Dates @.Parametername1 = ?,@.Parametername2= ?, @.Parametername3 = ? OUTPUT

|||another cryptic error message? hardly surprising... check if the account under which a package is run, has rights to execute the stored procedure|||On your SQL Task, set the "BypassPrepare" to TRUE. Otherwise the validation tries to validate the ?'s, and can't.

Can''t run integration services package as a sql server agent task

Hi guys, I 've been trying to run an integration services package as server agent scheduled task so that I dont have to manually execute the package every 2 hours. I was following how to guide in msdn to set up a server agant task for integration services package but I'm kind a lost. First of all when I ran the Management Studio and connected to the integration services the server agent does not show up it only shows me runing and stored packages. I can access to the server agent when I connect to the database engine but when I create a task and try to add a step to open a integration services package it does not give me the choice in type box. I couldn't figure out the problem. Is there a way to enable server agent to run under integration services too (not just under database engine) if databse engine is the only place server agents works , why dont I see the option to open a ssis package at adding a step to tasks? or is there a way to automate the process to run the package automatically without using the server agent at all?

Thanks,

Burak

PS I was following the http://msdn2.microsoft.com/en-us/library/ms139805.aspx article

You will find SQL Server Agent only under the relational DB and that is fine.; You should be able to create a job with an step to run the package you want to.

You have 2 option for the step type; you can use a SSIS package type or a command line (CmdExc) type.

This is a KB article with the most common problems when scheduling a package and their workarounds:

http://support.microsoft.com/kb/918760

BTW, Where is the package stored?

|||

The server agent is part of the database engine.

You will need to set up the proxy / credential / etc...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703968&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1322146&SiteID=1

|||

package is stored in the same file system as the sql server.

By the way when I chose the type as CmdExec it gives me sql error #14250 and it says my command is longer than 3200 chars as it tries to run the whole xml file as a command line prompt I guess. I believe if I can find a way to activate SSIS package option at the package type field I might be able to get pass this problem I'm going to try the solution with the proxy account maybe that will help.

|||

Ok I tried to follow the tutorials about how to create proxies and credentials unfortunatly when I expand the security tab of the database engine it just shows me logins and server roles no credentials. I do wonder wouldn't be easier if Microsoft just added the functionality to schedule the packages through Business Intelligence. I'm just frusturated following through all those how to's and at the end of the day still having the same problem.

|||

You tried the security folder of the overall server, and not the database that you are using? Are you using SQL Server Management Studio? It should be there....

Can''t run integration services package as a sql server agent task

Hi guys, I 've been trying to run an integration services package as server agent scheduled task so that I dont have to manually execute the package every 2 hours. I was following how to guide in msdn to set up a server agant task for integration services package but I'm kind a lost. First of all when I ran the Management Studio and connected to the integration services the server agent does not show up it only shows me runing and stored packages. I can access to the server agent when I connect to the database engine but when I create a task and try to add a step to open a integration services package it does not give me the choice in type box. I couldn't figure out the problem. Is there a way to enable server agent to run under integration services too (not just under database engine) if databse engine is the only place server agents works , why dont I see the option to open a ssis package at adding a step to tasks? or is there a way to automate the process to run the package automatically without using the server agent at all?

Thanks,

Burak

PS I was following the http://msdn2.microsoft.com/en-us/library/ms139805.aspx article

You will find SQL Server Agent only under the relational DB and that is fine.; You should be able to create a job with an step to run the package you want to.

You have 2 option for the step type; you can use a SSIS package type or a command line (CmdExc) type.

This is a KB article with the most common problems when scheduling a package and their workarounds:

http://support.microsoft.com/kb/918760

BTW, Where is the package stored?

|||

The server agent is part of the database engine.

You will need to set up the proxy / credential / etc...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703968&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1322146&SiteID=1

|||

package is stored in the same file system as the sql server.

By the way when I chose the type as CmdExec it gives me sql error #14250 and it says my command is longer than 3200 chars as it tries to run the whole xml file as a command line prompt I guess. I believe if I can find a way to activate SSIS package option at the package type field I might be able to get pass this problem I'm going to try the solution with the proxy account maybe that will help.

|||

Ok I tried to follow the tutorials about how to create proxies and credentials unfortunatly when I expand the security tab of the database engine it just shows me logins and server roles no credentials. I do wonder wouldn't be easier if Microsoft just added the functionality to schedule the packages through Business Intelligence. I'm just frusturated following through all those how to's and at the end of the day still having the same problem.

|||

You tried the security folder of the overall server, and not the database that you are using? Are you using SQL Server Management Studio? It should be there....

Can''t run integration services package as a sql server agent task

Hi guys, I 've been trying to run an integration services package as server agent scheduled task so that I dont have to manually execute the package every 2 hours. I was following how to guide in msdn to set up a server agant task for integration services package but I'm kind a lost. First of all when I ran the Management Studio and connected to the integration services the server agent does not show up it only shows me runing and stored packages. I can access to the server agent when I connect to the database engine but when I create a task and try to add a step to open a integration services package it does not give me the choice in type box. I couldn't figure out the problem. Is there a way to enable server agent to run under integration services too (not just under database engine) if databse engine is the only place server agents works , why dont I see the option to open a ssis package at adding a step to tasks? or is there a way to automate the process to run the package automatically without using the server agent at all?

Thanks,

Burak

PS I was following the http://msdn2.microsoft.com/en-us/library/ms139805.aspx article

You will find SQL Server Agent only under the relational DB and that is fine.; You should be able to create a job with an step to run the package you want to.

You have 2 option for the step type; you can use a SSIS package type or a command line (CmdExc) type.

This is a KB article with the most common problems when scheduling a package and their workarounds:

http://support.microsoft.com/kb/918760

BTW, Where is the package stored?

|||

The server agent is part of the database engine.

You will need to set up the proxy / credential / etc...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703968&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1322146&SiteID=1

|||

package is stored in the same file system as the sql server.

By the way when I chose the type as CmdExec it gives me sql error #14250 and it says my command is longer than 3200 chars as it tries to run the whole xml file as a command line prompt I guess. I believe if I can find a way to activate SSIS package option at the package type field I might be able to get pass this problem I'm going to try the solution with the proxy account maybe that will help.

|||

Ok I tried to follow the tutorials about how to create proxies and credentials unfortunatly when I expand the security tab of the database engine it just shows me logins and server roles no credentials. I do wonder wouldn't be easier if Microsoft just added the functionality to schedule the packages through Business Intelligence. I'm just frusturated following through all those how to's and at the end of the day still having the same problem.

|||

You tried the security folder of the overall server, and not the database that you are using? Are you using SQL Server Management Studio? It should be there....

Can''t run integration services package as a sql server agent task

Hi guys, I 've been trying to run an integration services package as server agent scheduled task so that I dont have to manually execute the package every 2 hours. I was following how to guide in msdn to set up a server agant task for integration services package but I'm kind a lost. First of all when I ran the Management Studio and connected to the integration services the server agent does not show up it only shows me runing and stored packages. I can access to the server agent when I connect to the database engine but when I create a task and try to add a step to open a integration services package it does not give me the choice in type box. I couldn't figure out the problem. Is there a way to enable server agent to run under integration services too (not just under database engine) if databse engine is the only place server agents works , why dont I see the option to open a ssis package at adding a step to tasks? or is there a way to automate the process to run the package automatically without using the server agent at all?

Thanks,

Burak

PS I was following the http://msdn2.microsoft.com/en-us/library/ms139805.aspx article

You will find SQL Server Agent only under the relational DB and that is fine.; You should be able to create a job with an step to run the package you want to.

You have 2 option for the step type; you can use a SSIS package type or a command line (CmdExc) type.

This is a KB article with the most common problems when scheduling a package and their workarounds:

http://support.microsoft.com/kb/918760

BTW, Where is the package stored?

|||

The server agent is part of the database engine.

You will need to set up the proxy / credential / etc...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703968&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1322146&SiteID=1

|||

package is stored in the same file system as the sql server.

By the way when I chose the type as CmdExec it gives me sql error #14250 and it says my command is longer than 3200 chars as it tries to run the whole xml file as a command line prompt I guess. I believe if I can find a way to activate SSIS package option at the package type field I might be able to get pass this problem I'm going to try the solution with the proxy account maybe that will help.

|||

Ok I tried to follow the tutorials about how to create proxies and credentials unfortunatly when I expand the security tab of the database engine it just shows me logins and server roles no credentials. I do wonder wouldn't be easier if Microsoft just added the functionality to schedule the packages through Business Intelligence. I'm just frusturated following through all those how to's and at the end of the day still having the same problem.

|||

You tried the security folder of the overall server, and not the database that you are using? Are you using SQL Server Management Studio? It should be there....

Can''t run integration services package as a sql server agent task

Hi guys, I 've been trying to run an integration services package as server agent scheduled task so that I dont have to manually execute the package every 2 hours. I was following how to guide in msdn to set up a server agant task for integration services package but I'm kind a lost. First of all when I ran the Management Studio and connected to the integration services the server agent does not show up it only shows me runing and stored packages. I can access to the server agent when I connect to the database engine but when I create a task and try to add a step to open a integration services package it does not give me the choice in type box. I couldn't figure out the problem. Is there a way to enable server agent to run under integration services too (not just under database engine) if databse engine is the only place server agents works , why dont I see the option to open a ssis package at adding a step to tasks? or is there a way to automate the process to run the package automatically without using the server agent at all?

Thanks,

Burak

PS I was following the http://msdn2.microsoft.com/en-us/library/ms139805.aspx article

You will find SQL Server Agent only under the relational DB and that is fine.; You should be able to create a job with an step to run the package you want to.

You have 2 option for the step type; you can use a SSIS package type or a command line (CmdExc) type.

This is a KB article with the most common problems when scheduling a package and their workarounds:

http://support.microsoft.com/kb/918760

BTW, Where is the package stored?

|||

The server agent is part of the database engine.

You will need to set up the proxy / credential / etc...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703968&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1322146&SiteID=1

|||

package is stored in the same file system as the sql server.

By the way when I chose the type as CmdExec it gives me sql error #14250 and it says my command is longer than 3200 chars as it tries to run the whole xml file as a command line prompt I guess. I believe if I can find a way to activate SSIS package option at the package type field I might be able to get pass this problem I'm going to try the solution with the proxy account maybe that will help.

|||

Ok I tried to follow the tutorials about how to create proxies and credentials unfortunatly when I expand the security tab of the database engine it just shows me logins and server roles no credentials. I do wonder wouldn't be easier if Microsoft just added the functionality to schedule the packages through Business Intelligence. I'm just frusturated following through all those how to's and at the end of the day still having the same problem.

|||

You tried the security folder of the overall server, and not the database that you are using? Are you using SQL Server Management Studio? It should be there....

Can''t run integration services package as a sql server agent task

Hi guys, I 've been trying to run an integration services package as server agent scheduled task so that I dont have to manually execute the package every 2 hours. I was following how to guide in msdn to set up a server agant task for integration services package but I'm kind a lost. First of all when I ran the Management Studio and connected to the integration services the server agent does not show up it only shows me runing and stored packages. I can access to the server agent when I connect to the database engine but when I create a task and try to add a step to open a integration services package it does not give me the choice in type box. I couldn't figure out the problem. Is there a way to enable server agent to run under integration services too (not just under database engine) if databse engine is the only place server agents works , why dont I see the option to open a ssis package at adding a step to tasks? or is there a way to automate the process to run the package automatically without using the server agent at all?

Thanks,

Burak

PS I was following the http://msdn2.microsoft.com/en-us/library/ms139805.aspx article

You will find SQL Server Agent only under the relational DB and that is fine.; You should be able to create a job with an step to run the package you want to.

You have 2 option for the step type; you can use a SSIS package type or a command line (CmdExc) type.

This is a KB article with the most common problems when scheduling a package and their workarounds:

http://support.microsoft.com/kb/918760

BTW, Where is the package stored?

|||

The server agent is part of the database engine.

You will need to set up the proxy / credential / etc...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703968&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1322146&SiteID=1

|||

package is stored in the same file system as the sql server.

By the way when I chose the type as CmdExec it gives me sql error #14250 and it says my command is longer than 3200 chars as it tries to run the whole xml file as a command line prompt I guess. I believe if I can find a way to activate SSIS package option at the package type field I might be able to get pass this problem I'm going to try the solution with the proxy account maybe that will help.

|||

Ok I tried to follow the tutorials about how to create proxies and credentials unfortunatly when I expand the security tab of the database engine it just shows me logins and server roles no credentials. I do wonder wouldn't be easier if Microsoft just added the functionality to schedule the packages through Business Intelligence. I'm just frusturated following through all those how to's and at the end of the day still having the same problem.

|||

You tried the security folder of the overall server, and not the database that you are using? Are you using SQL Server Management Studio? It should be there....

Can''t precompile script

Hi,

with a script task I get an error "This task is configured to pre-compile the script but the binary code is not found. Please visit the IDE in Script Task editor by clicking Desing Script button to cause binary code to be generated".

Well, if I do so the error doesn't disappear. The only chance I have is to switch of precopilation, which is quite a performance issue...

I have no idea where this error is comming from... The script is quite easy, just some string and file operations (find out file change date using system.io)...

Any idea?

I can only think that there is an error in compilation because this should of course work!

-Jamie

|||...any idea where to look? If I switch of precompile everything works, so there shouldn't be any error in the script...|||

Hmmm...bizarre.

Sorry Thomas, can't help you there!

|||This is an old one, but I just had the same problem and just noticed that my script had a syntax error. Once I fixed the syntax error, the problem was resolved.|||im facing the same problem....for the first time....simply cant keep precompile option to true as binary code is not getting generated....the issue is my env may change to 64 bit....evn keepin the option precompile false wont help then( which is workin fine now)
...just as im writin this....was this a issue bfr SP1... i havent checked if i have run it in new installation...
will check n post back if success....
ne suggestions welcome in the meanwhile...|||This is just wrong - when I set property precompile = false for the Script Task everything works fine.

SSIS works in odd ways sometimes (or perhaps it is just me)

Actually I now noticed that whatever package's script i open up - they dont compile anymore - I wonder what causes all of a sudden all the scripts on my workstation not to compile?|||as i guessed...SP1 solves this problem...worked for me... i had a new local server installation n missed out on the service packs....so install SP1 and 2 and ur done.....but ya ull have to then change all precompilei otions to true and open n close the script once to get the binary code........

sorry for the delay in reply!!

Can''t precompile script

Hi,

with a script task I get an error "This task is configured to pre-compile the script but the binary code is not found. Please visit the IDE in Script Task editor by clicking Desing Script button to cause binary code to be generated".

Well, if I do so the error doesn't disappear. The only chance I have is to switch of precopilation, which is quite a performance issue...

I have no idea where this error is comming from... The script is quite easy, just some string and file operations (find out file change date using system.io)...

Any idea?

I can only think that there is an error in compilation because this should of course work!

-Jamie

|||...any idea where to look? If I switch of precompile everything works, so there shouldn't be any error in the script...|||

Hmmm...bizarre.

Sorry Thomas, can't help you there!

|||This is an old one, but I just had the same problem and just noticed that my script had a syntax error. Once I fixed the syntax error, the problem was resolved.|||im facing the same problem....for the first time....simply cant keep precompile option to true as binary code is not getting generated....the issue is my env may change to 64 bit....evn keepin the option precompile false wont help then( which is workin fine now)
...just as im writin this....was this a issue bfr SP1... i havent checked if i have run it in new installation...
will check n post back if success....
ne suggestions welcome in the meanwhile...|||This is just wrong - when I set property precompile = false for the Script Task everything works fine.

SSIS works in odd ways sometimes (or perhaps it is just me)

Actually I now noticed that whatever package's script i open up - they dont compile anymore - I wonder what causes all of a sudden all the scripts on my workstation not to compile?|||as i guessed...SP1 solves this problem...worked for me... i had a new local server installation n missed out on the service packs....so install SP1 and 2 and ur done.....but ya ull have to then change all precompilei otions to true and open n close the script once to get the binary code........

sorry for the delay in reply!!

Can't precompile script

Hi,

with a script task I get an error "This task is configured to pre-compile the script but the binary code is not found. Please visit the IDE in Script Task editor by clicking Desing Script button to cause binary code to be generated".

Well, if I do so the error doesn't disappear. The only chance I have is to switch of precopilation, which is quite a performance issue...

I have no idea where this error is comming from... The script is quite easy, just some string and file operations (find out file change date using system.io)...

Any idea?

I can only think that there is an error in compilation because this should of course work!

-Jamie

|||...any idea where to look? If I switch of precompile everything works, so there shouldn't be any error in the script...|||

Hmmm...bizarre.

Sorry Thomas, can't help you there!

|||This is an old one, but I just had the same problem and just noticed that my script had a syntax error. Once I fixed the syntax error, the problem was resolved.|||im facing the same problem....for the first time....simply cant keep precompile option to true as binary code is not getting generated....the issue is my env may change to 64 bit....evn keepin the option precompile false wont help then( which is workin fine now)
...just as im writin this....was this a issue bfr SP1... i havent checked if i have run it in new installation...
will check n post back if success....
ne suggestions welcome in the meanwhile...|||This is just wrong - when I set property precompile = false for the Script Task everything works fine.

SSIS works in odd ways sometimes (or perhaps it is just me)

Actually I now noticed that whatever package's script i open up - they dont compile anymore - I wonder what causes all of a sudden all the scripts on my workstation not to compile?|||as i guessed...SP1 solves this problem...worked for me... i had a new local server installation n missed out on the service packs....so install SP1 and 2 and ur done.....but ya ull have to then change all precompilei otions to true and open n close the script once to get the binary code........

sorry for the delay in reply!!

Can't precompile script

Hi,

with a script task I get an error "This task is configured to pre-compile the script but the binary code is not found. Please visit the IDE in Script Task editor by clicking Desing Script button to cause binary code to be generated".

Well, if I do so the error doesn't disappear. The only chance I have is to switch of precopilation, which is quite a performance issue...

I have no idea where this error is comming from... The script is quite easy, just some string and file operations (find out file change date using system.io)...

Any idea?

I can only think that there is an error in compilation because this should of course work!

-Jamie

|||...any idea where to look? If I switch of precompile everything works, so there shouldn't be any error in the script...|||

Hmmm...bizarre.

Sorry Thomas, can't help you there!

|||This is an old one, but I just had the same problem and just noticed that my script had a syntax error. Once I fixed the syntax error, the problem was resolved.|||im facing the same problem....for the first time....simply cant keep precompile option to true as binary code is not getting generated....the issue is my env may change to 64 bit....evn keepin the option precompile false wont help then( which is workin fine now)
...just as im writin this....was this a issue bfr SP1... i havent checked if i have run it in new installation...
will check n post back if success....
ne suggestions welcome in the meanwhile...|||This is just wrong - when I set property precompile = false for the Script Task everything works fine.

SSIS works in odd ways sometimes (or perhaps it is just me)

Actually I now noticed that whatever package's script i open up - they dont compile anymore - I wonder what causes all of a sudden all the scripts on my workstation not to compile?|||as i guessed...SP1 solves this problem...worked for me... i had a new local server installation n missed out on the service packs....so install SP1 and 2 and ur done.....but ya ull have to then change all precompilei otions to true and open n close the script once to get the binary code........

sorry for the delay in reply!!

Can't Login to Sql Server 2005

HELP! I was working on a SSIS package trying to execute a SQL Transfer
Object task when it errored out saying it didn't have permission to
access the database. So I tried to manually scipt the Create Database
option and it gave me the same message. Then I was kicked out
completely and it won't let me back into the server not matter what
login I use. I'm using Windows Authentication mode only. So I'm at a
total loss. Any ideas? Thanks
EdHi
Have you checked the server itself? Can you connect with Management Studio?
John
"ed.brunet@.gmail.com" wrote:
> HELP! I was working on a SSIS package trying to execute a SQL Transfer
> Object task when it errored out saying it didn't have permission to
> access the database. So I tried to manually scipt the Create Database
> option and it gave me the same message. Then I was kicked out
> completely and it won't let me back into the server not matter what
> login I use. I'm using Windows Authentication mode only. So I'm at a
> total loss. Any ideas? Thanks
> Ed
>

Can't Login to Sql Server 2005

HELP! I was working on a SSIS package trying to execute a SQL Transfer
Object task when it errored out saying it didn't have permission to
access the database. So I tried to manually scipt the Create Database
option and it gave me the same message. Then I was kicked out
completely and it won't let me back into the server not matter what
login I use. I'm using Windows Authentication mode only. So I'm at a
total loss. Any ideas? Thanks
EdHi
Have you checked the server itself? Can you connect with Management Studio?
John
"ed.brunet@.gmail.com" wrote:

> HELP! I was working on a SSIS package trying to execute a SQL Transfer
> Object task when it errored out saying it didn't have permission to
> access the database. So I tried to manually scipt the Create Database
> option and it gave me the same message. Then I was kicked out
> completely and it won't let me back into the server not matter what
> login I use. I'm using Windows Authentication mode only. So I'm at a
> total loss. Any ideas? Thanks
> Ed
>

Can't import data in Sql 2005

I use the Import Data task form Management Studio,
but it show up a error message: System can't find file!
How can I do?Check if you have proper path to file from which you would like to import
--
Best Regards
Krystian Zieja / mob
"ad" wrote:
> I use the Import Data task form Management Studio,
> but it show up a error message: System can't find file!
> How can I do?
>
>

Can't import data in Sql 2005

I use the Import Data task form Management Studio,
but it show up a error message: System can't find file!
How can I do?
Check if you have proper path to file from which you would like to import
Best Regards
Krystian Zieja / mob
"ad" wrote:

> I use the Import Data task form Management Studio,
> but it show up a error message: System can't find file!
> How can I do?
>
>

Can't import data in Sql 2005

I use the Import Data task form Management Studio,
but it show up a error message: System can't find file!
How can I do?Check if you have proper path to file from which you would like to import
--
Best Regards
Krystian Zieja / mob
"ad" wrote:

> I use the Import Data task form Management Studio,
> but it show up a error message: System can't find file!
> How can I do?
>
>