Re: SSIS & Script Transformation (debug vs normal)

On Mar 12, 6:18 am, jhofm...@xxxxxxxxxxxxxx wrote:
Hi Anthony,

Can you give more details about what the "transformation script" is
doing?

Usually issues where something works in debug/dev mode but not post
deployment is due to SQL Agent account permissions.

Good luck!
J

The package is pretty simple. Our ERP stores dates in a numeric field,
and we are moving this into a true date field.
In the package
- I have one data-source collecting source data, connected to derived
column (building a placeholder for the new date fields)
- Going into a script transformation the date (output is a date or
null) works is debug mode, but not when ran by sql agent.
- Final output is a SQL table.

I am running SQL Server 2005, 64 bit . I have to use 32 bit drivers to
connect to my data-source. So in SQL Agent - I run my package from the
command line, to call out the 32 bit dts package. Also, I have a proxy
setup with every possible option. I use this proxy across my whole
integration process, without problems. For some reason, this package
has a problem - the main difference - Script Transformation.

Thanks for your response.

r/ Anthony
.

Relevant Pages

  • Script Controlled Dynamic Task Execution
    ... Transformation Tasks into my SQL Server database. ... need to execute one transformation on a text file, ... I have a script that wants to take complete control of the ... Package as far as source connections and task executions, ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS - aus Space wird Null
    ... Ich habe das Package mit dem "DTS Import/Export Wizard" ... Script generiert wird. ... Welche genau machen könnte, dass da die Transformation Leere Felder in NULL Felder umwandelt, weiss ich nicht. ...
    (microsoft.public.de.sqlserver)
  • Re: Script Controlled Dynamic Task Execution
    ... > Transformation Tasks into my SQL Server database. ... > need to execute one transformation on a text file, ... I have a script that wants to take complete control of the ... > Package as far as source connections and task executions, ...
    (microsoft.public.sqlserver.dts)
  • Installation of software, and security. . .
    ... installation in Windows and various package managers. ... A setup.exe program coded by some third party such as Real Networks ... A .msi Microsoft Installer package is unpacked, and a script coded by ...
    (Bugtraq)
  • Re: goto &Package::func destroying @_?!
    ... >>script, but maybe the description will trigger something from someone.... ... code the 'Core' package uses another package as a base that has a custom ... package Foo; ... if it really is a problem with goto&. ...
    (comp.lang.perl.misc)
Quantcast