JDBC Driver issue: step

Showing posts with label step. Show all posts

Friday, March 30, 2012

Job: Export to File: no headers/trailers

Hi,
I tryed to Export a query to a Fiel with a Job.
What I found in my file was this:
"
Job 'ExportToSiclid' : Step 1, 'ExportFile' : Began Executing 2004-06-22
13:16:07
tdprNFoy tdprNCCD CallDate TEL Choice
tdprNSocFin Agent
-- -- -- -- -- --
-- --
4240001034 9100 2004-06-22-13.13.48.71700 0478385115 Informatie 110
Van den Hel, Heidi
4276454891 9100 2004-06-22-13.13.57.23300 0 FIDI 104
Tanghe, Wendy
(2 rows(s) affected)
"
What I actually expected and wanted was this:
"
42400010349100 2004-06-22-13.13.48.717000478385115 Informatie110
Van den Hel, Heidi
42764548919100 2004-06-22-13.13.57.233000 FIDI 104
Tanghe, Wendy
"
So without the header, without the trailer, without the names of the
columns, and without a space between the columns.
Is this possible or not, and if so: how?
Thanks a lot in advance,
PieterHi
This looks like you are starting a command prompt and running osql/isql? You
may want to look at adding SET NOCOUNT ON to the SQL and using the -h flag
to osql/isql. Alternatively try the
DTS Export wizard or BCP utility. Mor information on all of these can be
found in Books Online.
John
"DraguVaso" <pietercoucke@.hotmail.com> wrote in message
news:OqhPeoEWEHA.208@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I tryed to Export a query to a Fiel with a Job.
> What I found in my file was this:
> "
> Job 'ExportToSiclid' : Step 1, 'ExportFile' : Began Executing 2004-06-22
> 13:16:07
> tdprNFoy tdprNCCD CallDate TEL Choice
> tdprNSocFin Agent
> -- -- -- -- -- -
--
> -- --
> 4240001034 9100 2004-06-22-13.13.48.71700 0478385115 Informatie
110
> Van den Hel, Heidi
> 4276454891 9100 2004-06-22-13.13.57.23300 0 FIDI
104
> Tanghe, Wendy
> (2 rows(s) affected)
> "
> What I actually expected and wanted was this:
> "
> 42400010349100 2004-06-22-13.13.48.717000478385115 Informatie110
> Van den Hel, Heidi
> 42764548919100 2004-06-22-13.13.57.233000 FIDI 104
> Tanghe, Wendy
> "
> So without the header, without the trailer, without the names of the
> columns, and without a space between the columns.
> Is this possible or not, and if so: how?
> Thanks a lot in advance,
> Pieter
>|||Thanks,
And how do you put a DTS or BCP in a job so it is executed every day
automaticly?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uvJvr2EWEHA.556@.tk2msftngp13.phx.gbl...
> Hi
> This looks like you are starting a command prompt and running osql/isql?
You
> may want to look at adding SET NOCOUNT ON to the SQL and using the -h flag
> to osql/isql. Alternatively try the
> DTS Export wizard or BCP utility. Mor information on all of these can be
> found in Books Online.
> John
> "DraguVaso" <pietercoucke@.hotmail.com> wrote in message
> news:OqhPeoEWEHA.208@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > I tryed to Export a query to a Fiel with a Job.
> >
> > What I found in my file was this:
> >
> > "
> > Job 'ExportToSiclid' : Step 1, 'ExportFile' : Began Executing 2004-06-22
> > 13:16:07
> >
> > tdprNFoy tdprNCCD CallDate TEL Choice
> > tdprNSocFin Agent
> -- -- -- -- -- -
> --
> > -- --
> > 4240001034 9100 2004-06-22-13.13.48.71700 0478385115 Informatie
> 110
> > Van den Hel, Heidi
> > 4276454891 9100 2004-06-22-13.13.57.23300 0 FIDI
> 104
> > Tanghe, Wendy
> >
> > (2 rows(s) affected)
> > "
> >
> > What I actually expected and wanted was this:
> > "
> > 42400010349100 2004-06-22-13.13.48.717000478385115 Informatie110
> > Van den Hel, Heidi
> > 42764548919100 2004-06-22-13.13.57.233000 FIDI 104
> > Tanghe, Wendy
> > "
> >
> > So without the header, without the trailer, without the names of the
> > columns, and without a space between the columns.
> >
> > Is this possible or not, and if so: how?
> >
> > Thanks a lot in advance,
> >
> > Pieter
> >
> >
>|||Hi
If you run the DTS export wizard that will give you the option to schedule
the DTS job. This can also be changed in the created job. If you are already
running osql from your batch job, you can change the command to run BCP
instead.
John
"DraguVaso" <pietercoucke@.hotmail.com> wrote in message
news:eygYb4FWEHA.1048@.tk2msftngp13.phx.gbl...
> Thanks,
> And how do you put a DTS or BCP in a job so it is executed every day
> automaticly?
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uvJvr2EWEHA.556@.tk2msftngp13.phx.gbl...
> > Hi
> >
> > This looks like you are starting a command prompt and running osql/isql?
> You
> > may want to look at adding SET NOCOUNT ON to the SQL and using the -h
flag
> > to osql/isql. Alternatively try the
> > DTS Export wizard or BCP utility. Mor information on all of these can be
> > found in Books Online.
> >
> > John
> >
> > "DraguVaso" <pietercoucke@.hotmail.com> wrote in message
> > news:OqhPeoEWEHA.208@.TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > >
> > > I tryed to Export a query to a Fiel with a Job.
> > >
> > > What I found in my file was this:
> > >
> > > "
> > > Job 'ExportToSiclid' : Step 1, 'ExportFile' : Began Executing
2004-06-22
> > > 13:16:07
> > >
> > > tdprNFoy tdprNCCD CallDate TEL Choice
> > > tdprNSocFin Agent
> >
> -- -- -- -- -- -
> > --
> > > -- --
> > > 4240001034 9100 2004-06-22-13.13.48.71700 0478385115
Informatie
> > 110
> > > Van den Hel, Heidi
> > > 4276454891 9100 2004-06-22-13.13.57.23300 0 FIDI
> > 104
> > > Tanghe, Wendy
> > >
> > > (2 rows(s) affected)
> > > "
> > >
> > > What I actually expected and wanted was this:
> > > "
> > > 42400010349100 2004-06-22-13.13.48.717000478385115
Informatie110
> > > Van den Hel, Heidi
> > > 42764548919100 2004-06-22-13.13.57.233000 FIDI
104
> > > Tanghe, Wendy
> > > "
> > >
> > > So without the header, without the trailer, without the names of the
> > > columns, and without a space between the columns.
> > >
> > > Is this possible or not, and if so: how?
> > >
> > > Thanks a lot in advance,
> > >
> > > Pieter
> > >
> > >
> >
> >
>|||Thanks!!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OCSgETGWEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi
> If you run the DTS export wizard that will give you the option to schedule
> the DTS job. This can also be changed in the created job. If you are
already
> running osql from your batch job, you can change the command to run BCP
> instead.
> John
> "DraguVaso" <pietercoucke@.hotmail.com> wrote in message
> news:eygYb4FWEHA.1048@.tk2msftngp13.phx.gbl...
> > Thanks,
> >
> > And how do you put a DTS or BCP in a job so it is executed every day
> > automaticly?
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:uvJvr2EWEHA.556@.tk2msftngp13.phx.gbl...
> > > Hi
> > >
> > > This looks like you are starting a command prompt and running
osql/isql?
> > You
> > > may want to look at adding SET NOCOUNT ON to the SQL and using the -h
> flag
> > > to osql/isql. Alternatively try the
> > > DTS Export wizard or BCP utility. Mor information on all of these can
be
> > > found in Books Online.
> > >
> > > John
> > >
> > > "DraguVaso" <pietercoucke@.hotmail.com> wrote in message
> > > news:OqhPeoEWEHA.208@.TK2MSFTNGP10.phx.gbl...
> > > > Hi,
> > > >
> > > > I tryed to Export a query to a Fiel with a Job.
> > > >
> > > > What I found in my file was this:
> > > >
> > > > "
> > > > Job 'ExportToSiclid' : Step 1, 'ExportFile' : Began Executing
> 2004-06-22
> > > > 13:16:07
> > > >
> > > > tdprNFoy tdprNCCD CallDate TEL Choice
> > > > tdprNSocFin Agent
> > >
> >
> -- -- -- -- -- -
> > > --
> > > > -- --
> > > > 4240001034 9100 2004-06-22-13.13.48.71700 0478385115
> Informatie
> > > 110
> > > > Van den Hel, Heidi
> > > > 4276454891 9100 2004-06-22-13.13.57.23300 0 FIDI
> > > 104
> > > > Tanghe, Wendy
> > > >
> > > > (2 rows(s) affected)
> > > > "
> > > >
> > > > What I actually expected and wanted was this:
> > > > "
> > > > 42400010349100 2004-06-22-13.13.48.717000478385115
> Informatie110
> > > > Van den Hel, Heidi
> > > > 42764548919100 2004-06-22-13.13.57.233000 FIDI
> 104
> > > > Tanghe, Wendy
> > > > "
> > > >
> > > > So without the header, without the trailer, without the names of the
> > > > columns, and without a space between the columns.
> > > >
> > > > Is this possible or not, and if so: how?
> > > >
> > > > Thanks a lot in advance,
> > > >
> > > > Pieter
> > > >
> > > >
> > >
> > >
> >
> >
>

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

|||hey - did you ever get this to work? Im having the same issue - its a SSIS pkg that ran on one box and I moved to another box (64 bit if that makes a diff) - any info is greatly apprecaited - thanks.|||

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

|||After settings Precompile to True, you need to open and close script editor(s) to actually precompile the script in the task. Then re-deploy the pockage to target system.|||Also remove all the break points in the code, having break points prevents from recompilation. I guess this issue would be fixed by SP2|||Just an FYI I had all my scripts set to PrecompileScriptIntoBinaryCode=True however when developing in 32bit and deploying to 64bit seemingly randomly I will get the "script failed to load" error. I just open the script and compile it again and save and that usually does the trick.|||

Also if the problem still persists and you keep getting the same error I am sure you are not taking the dtsx file from bin folder to execute. The file created by designer (Business Intelligence Development Studio) is only useful for debug and development mode. After building the solution one should use dtsx created in bin folder. This solution worked for me.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:
If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

|||

I too have similar doubt as that of Paulino. I've 50+ packages with 60+ script tasks. Is there any way, I can compile using a command in command prompt? Any help would be highly appreciated.

My Regards

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

sql

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:
If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:
If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:
If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

sql

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:
If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

Wednesday, March 28, 2012

job stuck at perform completion action step

Hi,
I have a job on sql 7 server that stuck at 'perform
completion action' step after we stopped the job.
Is reboot the server the only choice to fix it?
many thanks.
JJYou can try sp_stop_job 'jobname'
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:12ea201c4436b$95204c20$a301280a@.phx.gbl...
> Hi,
> I have a job on sql 7 server that stuck at 'perform
> completion action' step after we stopped the job.
> Is reboot the server the only choice to fix it?
> many thanks.
> JJ|||thanks oj.
I did that, and it returned successful of stopping job
result, yet, the job is still showing as 'performing
complete step'.
JJ
>--Original Message--
>You can try sp_stop_job 'jobname'
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
>news:12ea201c4436b$95204c20$a301280a@.phx.gbl...
>> Hi,
>> I have a job on sql 7 server that stuck at 'perform
>> completion action' step after we stopped the job.
>> Is reboot the server the only choice to fix it?
>> many thanks.
>> JJ
>
>.
>|||If the step is doing a rollback of a transaction, you'll have to wait for
it. Perhaps, you want to fire up profiler and see what's going on. If need
to, send 'kill <spid>'.
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:131f101c4437a$86d28070$a501280a@.phx.gbl...
> thanks oj.
> I did that, and it returned successful of stopping job
> result, yet, the job is still showing as 'performing
> complete step'.
> JJ
> >--Original Message--
> >You can try sp_stop_job 'jobname'
> >
> >
> >"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:12ea201c4436b$95204c20$a301280a@.phx.gbl...
> >> Hi,
> >>
> >> I have a job on sql 7 server that stuck at 'perform
> >> completion action' step after we stopped the job.
> >>
> >> Is reboot the server the only choice to fix it?
> >>
> >> many thanks.
> >>
> >> JJ
> >
> >
> >.
> >|||this is simply a tranl-log bu job which usually run for
few seconds. I can't even see its spid in the process,
hence can't kill it.
I heard that this is a bug of sql server and only reboot
will fix it. Just want to see whether anyone has other
more graceful methods to solve it.
JJ
>--Original Message--
>If the step is doing a rollback of a transaction, you'll
have to wait for
>it. Perhaps, you want to fire up profiler and see what's
going on. If need
>to, send 'kill <spid>'.
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
>news:131f101c4437a$86d28070$a501280a@.phx.gbl...
>> thanks oj.
>> I did that, and it returned successful of stopping job
>> result, yet, the job is still showing as 'performing
>> complete step'.
>> JJ
>> >--Original Message--
>> >You can try sp_stop_job 'jobname'
>> >
>> >
>> >"JJ Wang" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:12ea201c4436b$95204c20$a301280a@.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a job on sql 7 server that stuck at 'perform
>> >> completion action' step after we stopped the job.
>> >>
>> >> Is reboot the server the only choice to fix it?
>> >>
>> >> many thanks.
>> >>
>> >> JJ
>> >
>> >
>> >.
>> >
>
>.
>|||this is simply a tranl-log bu job which usually run for
few seconds. I can't even see its spid in the process,
hence can't kill it.
I heard that this is a bug of sql server and only reboot
will fix it. Just want to see whether anyone has other
more graceful methods to solve it.
JJ
>--Original Message--
>If the step is doing a rollback of a transaction, you'll
have to wait for
>it. Perhaps, you want to fire up profiler and see what's
going on. If need
>to, send 'kill <spid>'.
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
>news:131f101c4437a$86d28070$a501280a@.phx.gbl...
>> thanks oj.
>> I did that, and it returned successful of stopping job
>> result, yet, the job is still showing as 'performing
>> complete step'.
>> JJ
>> >--Original Message--
>> >You can try sp_stop_job 'jobname'
>> >
>> >
>> >"JJ Wang" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:12ea201c4436b$95204c20$a301280a@.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a job on sql 7 server that stuck at 'perform
>> >> completion action' step after we stopped the job.
>> >>
>> >> Is reboot the server the only choice to fix it?
>> >>
>> >> many thanks.
>> >>
>> >> JJ
>> >
>> >
>> >.
>> >
>
>.
>|||JJ,
Have you refreshed the display in Enterprise Manager? i.e. you could go
as far as closing EM and reloading it, does that clear it?
Are you using Exchange Server? Perhaps this article will help:
Microsoft Knowledge Base Article - 328197
BUG: SQL Server Agent Job with E-Mail Notification Option Stops
Responding When Microsoft Exchange Server is Not Available
http://support.microsoft.com/?id=328197
Also, some articles from the newsgroups that might help:
http://tinyurl.com/3aulj
Finally, please don't cross-post, it is usually not necessary as the
traffic volume to most sqlserver groups is very high. ;-)
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
JJ Wang wrote:
> this is simply a tranl-log bu job which usually run for
> few seconds. I can't even see its spid in the process,
> hence can't kill it.
> I heard that this is a bug of sql server and only reboot
> will fix it. Just want to see whether anyone has other
> more graceful methods to solve it.
> JJ
>>--Original Message--
>>If the step is doing a rollback of a transaction, you'll
> have to wait for
>>it. Perhaps, you want to fire up profiler and see what's
> going on. If need
>>to, send 'kill <spid>'.
>>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:131f101c4437a$86d28070$a501280a@.phx.gbl...
>>thanks oj.
>>I did that, and it returned successful of stopping job
>>result, yet, the job is still showing as 'performing
>>complete step'.
>>JJ
>>--Original Message--
>>You can try sp_stop_job 'jobname'
>>
>>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote
> in
>>message
>>news:12ea201c4436b$95204c20$a301280a@.phx.gbl...
>>Hi,
>>I have a job on sql 7 server that stuck at 'perform
>>completion action' step after we stopped the job.
>>Is reboot the server the only choice to fix it?
>>many thanks.
>>JJ
>>
>>.
>>
>>.|||thanks Mark. I do have an email notification to operator
set up for this hang job. the article is hitting right on
the target. yet, I have difficulty to follow the
instructions:
'As a workaround,
1. remove the reference to the Contacts folder from the
Outlook Address Book service in the SQLAgent mail profile,
or
2. remove the complete Outlook Address Book service from
this profile.'
where should I locate this 'SQLAgent mail profile'?
btw, I will try not to cross send message, but a lot of
time it's just too time-consuming to go through the groups
response one by one, because a lot of them only visit a
particular group.
many thanks.
JJ
>--Original Message--
>JJ,
>Have you refreshed the display in Enterprise Manager?
i.e. you could go
>as far as closing EM and reloading it, does that clear it?
>Are you using Exchange Server? Perhaps this article will
help:
>Microsoft Knowledge Base Article - 328197
>BUG: SQL Server Agent Job with E-Mail Notification Option
Stops
>Responding When Microsoft Exchange Server is Not Available
>http://support.microsoft.com/?id=328197
>Also, some articles from the newsgroups that might help:
>http://tinyurl.com/3aulj
>Finally, please don't cross-post, it is usually not
necessary as the
>traffic volume to most sqlserver groups is very high. ;-)
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>JJ Wang wrote:
>> this is simply a tranl-log bu job which usually run for
>> few seconds. I can't even see its spid in the process,
>> hence can't kill it.
>> I heard that this is a bug of sql server and only
reboot
>> will fix it. Just want to see whether anyone has other
>> more graceful methods to solve it.
>> JJ
>>--Original Message--
>>If the step is doing a rollback of a transaction,
you'll
>> have to wait for
>>it. Perhaps, you want to fire up profiler and see
what's
>> going on. If need
>>to, send 'kill <spid>'.
>>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>>news:131f101c4437a$86d28070$a501280a@.phx.gbl...
>>thanks oj.
>>I did that, and it returned successful of stopping job
>>result, yet, the job is still showing as 'performing
>>complete step'.
>>JJ
>>--Original Message--
>>You can try sp_stop_job 'jobname'
>>
>>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote
>> in
>>message
>>news:12ea201c4436b$95204c20$a301280a@.phx.gbl...
>>Hi,
>>I have a job on sql 7 server that stuck at 'perform
>>completion action' step after we stopped the job.
>>Is reboot the server the only choice to fix it?
>>many thanks.
>>JJ
>>
>>.
>>
>>.
>.
>

job steps synchronous?

Quick question - if I have several steps in a job are they run one after the other or can there potentially be overlap. In one step I create a file and the subsequent step copies it, so I'm concerned that the first completes before the second begins
TIA
Frank SThey are sequental.
Bojidar Alexandrov|||Frank,
My experience is that it is no overlap.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Frank Spencer" <anonymous@.discussions.microsoft.com> wrote in message
news:C2E0F3EF-331D-49CF-A77E-ECCEF0710F32@.microsoft.com...
> Quick question - if I have several steps in a job are they run one after the other or can there potentially
be overlap. In one step I create a file and the subsequent step copies it, so I'm concerned that the first
completes before the second begins.
> TIA,
> Frank S

job steps synchronous?

Quick question - if I have several steps in a job are they run one after the
other or can there potentially be overlap. In one step I create a file and
the subsequent step copies it, so I'm concerned that the first completes bef
ore the second begins.
TIA,
Frank SThey are sequental.
Bojidar Alexandrov|||Frank,
My experience is that it is no overlap.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Frank Spencer" <anonymous@.discussions.microsoft.com> wrote in message
news:C2E0F3EF-331D-49CF-A77E-ECCEF0710F32@.microsoft.com...
> Quick question - if I have several steps in a job are they run one after the other
or can there potentially
be overlap. In one step I create a file and the subsequent step copies it, s
o I'm concerned that the first
completes before the second begins.
> TIA,
> Frank Ssql

job steps synchronous?

Quick question - if I have several steps in a job are they run one after the other or can there potentially be overlap. In one step I create a file and the subsequent step copies it, so I'm concerned that the first completes before the second begins.
TIA,
Frank S
They are sequental.
Bojidar Alexandrov
|||Frank,
My experience is that it is no overlap.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Frank Spencer" <anonymous@.discussions.microsoft.com> wrote in message
news:C2E0F3EF-331D-49CF-A77E-ECCEF0710F32@.microsoft.com...
> Quick question - if I have several steps in a job are they run one after the other or can there potentially
be overlap. In one step I create a file and the subsequent step copies it, so I'm concerned that the first
completes before the second begins.
> TIA,
> Frank S

Job Steps Displayed Out of Order

When selecting to start a job manually, the job steps
appear out of order (step 3 is above steps 1 and 2 and
the like).
Any ideas what is causing this, and how to correct it?And, as I said, I don't see this and can't reproduce it. So something must
be different about *your* job, which is why I asked to see the SQL script.
We're not going to be able to guess at what's wrong unless we actually have
a script that we can use to reproduce your scenario!
"Arbiter Becker" <absql@.hotmail.com> wrote in message
news:0b7e01c356a5$12262c30$a601280a@.phx.gbl...
> Note;
> The job runs fine, if running off a schedule, and is
> displayed correctly if looking at the individual job
> steps. It is only when doing the manual start option for
> the job does it display incorrectly.
>
> >--Original Message--
> >When selecting to start a job manually, the job steps
> >appear out of order (step 3 is above steps 1 and 2 and
> >the like).
> >
> >Any ideas what is causing this, and how to correct it?
> >.
> >|||Hi Arbiter,
When you say step 3, 2, 1..., do you refer to the ID shown on Steps tab, or
the number prefix you may have added in the name of each job step?
If you click on "Move step" (up and down arrows), the ID always stays in
ascending order but the actual job steps move.
Richard
"Arbiter Becker" <absql@.hotmail.com> wrote in message
news:0da801c3569f$f4d71130$a101280a@.phx.gbl...
> When selecting to start a job manually, the job steps
> appear out of order (step 3 is above steps 1 and 2 and
> the like).
> Any ideas what is causing this, and how to correct it?

Job Step Set up

I am creating a job within Enterprise Manager on SQL 2K to backup a database called Messaging. In creating the step, on the General tab there are four fields: Step name, Type, Database, Command.
My Command is:
BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD , NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
In relation to the above command, do I select Messaging from the database drop down list?
In relation to the above command, if Master is selected from the database drop down list, what is backed up, Master or Messaging?
Message posted via http://www.sqlmonster.com
You can select messaging if you want but you do not have to. This listbox
just tells the SQL Server job agent which database to execute the T-SQL
within. Since you are telling SQL Server to backup the messaging database
("BACKUP DATABASE Messaging") you do not have to select the database.
Either way the messaging database will be backed up.
Personally I would leave the database listbox set to master.
Keith
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:0feb5d1e2fea4bc386ad965ac4d66991@.SQLMonster.c om...
> I am creating a job within Enterprise Manager on SQL 2K to backup a
database called Messaging. In creating the step, on the General tab there
are four fields: Step name, Type, Database, Command.
> My Command is:
> BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD ,
NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
> In relation to the above command, do I select Messaging from the database
drop down list?
> In relation to the above command, if Master is selected from the database
drop down list, what is backed up, Master or Messaging?
> --
> Message posted via http://www.sqlmonster.com

Job Step Set up

I am creating a job within Enterprise Manager on SQL 2K to backup a database
called Messaging. In creating the step, on the General tab there are four f
ields: Step name, Type, Database, Command.
My Command is:
BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD , NAME
= N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
In relation to the above command, do I select Messaging from the database dr
op down list?
In relation to the above command, if Master is selected from the database dr
op down list, what is backed up, Master or Messaging?
Message posted via http://www.droptable.comYou can select messaging if you want but you do not have to. This listbox
just tells the SQL Server job agent which database to execute the T-SQL
within. Since you are telling SQL Server to backup the messaging database
("BACKUP DATABASE Messaging") you do not have to select the database.
Either way the messaging database will be backed up.
Personally I would leave the database listbox set to master.
Keith
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:0feb5d1e2fea4bc386ad965ac4d66991@.SQ
droptable.com...
> I am creating a job within Enterprise Manager on SQL 2K to backup a
database called Messaging. In creating the step, on the General tab there
are four fields: Step name, Type, Database, Command.
> My Command is:
> BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD ,
NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
> In relation to the above command, do I select Messaging from the database
drop down list?
> In relation to the above command, if Master is selected from the database
drop down list, what is backed up, Master or Messaging?
> --
> Message posted via http://www.droptable.comsql

Job Step Set up

I am creating a job within Enterprise Manager on SQL 2K to backup a database called Messaging. In creating the step, on the General tab there are four fields: Step name, Type, Database, Command.
My Command is:
BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD , NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
In relation to the above command, do I select Messaging from the database drop down list?
In relation to the above command, if Master is selected from the database drop down list, what is backed up, Master or Messaging?
--
Message posted via http://www.sqlmonster.comYou can select messaging if you want but you do not have to. This listbox
just tells the SQL Server job agent which database to execute the T-SQL
within. Since you are telling SQL Server to backup the messaging database
("BACKUP DATABASE Messaging") you do not have to select the database.
Either way the messaging database will be backed up.
Personally I would leave the database listbox set to master.
--
Keith
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:0feb5d1e2fea4bc386ad965ac4d66991@.SQLMonster.com...
> I am creating a job within Enterprise Manager on SQL 2K to backup a
database called Messaging. In creating the step, on the General tab there
are four fields: Step name, Type, Database, Command.
> My Command is:
> BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD ,
NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
> In relation to the above command, do I select Messaging from the database
drop down list?
> In relation to the above command, if Master is selected from the database
drop down list, what is backed up, Master or Messaging?
> --
> Message posted via http://www.sqlmonster.com

Friday, March 30, 2012

Job: Export to File: no headers/trailers

JOB With SSIS Step Fails If Package Contains A Script Task

JOB With SSIS Step Fails If Package Contains A Script Task

JOB With SSIS Step Fails If Package Contains A Script Task

JOB With SSIS Step Fails If Package Contains A Script Task

JOB With SSIS Step Fails If Package Contains A Script Task

JOB With SSIS Step Fails If Package Contains A Script Task

JOB With SSIS Step Fails If Package Contains A Script Task

JOB With SSIS Step Fails If Package Contains A Script Task

Wednesday, March 28, 2012

job stuck at perform completion action step

job stuck at perform completion action step

job stuck at perform completion action step

job stuck at perform completion action step

job steps synchronous?

job steps synchronous?

job steps synchronous?

Job Steps Displayed Out of Order

Job Step Set up

Job Step Set up

Job Step Set up

JDBC Driver issue

Blog Archive

About Me