How to FTP a Dynamically Named Flat File

  • 2Tall

    SSChampion

    Points: 14590

    Comments posted to this topic are about the item How to FTP a Dynamically Named Flat File

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • g.britton

    SSChampion

    Points: 13686

    Why not just use an Expression Task (I see you are on SQL Server 2012) to generate the file name? I'm not sure that the script task is necessary for that. You could have also just used a variable defined with an expression, I believe.

    Gerald Britton, MCSE-DP, MVPToronto PASS Chapter[/url]

  • jpkothapalli09

    SSC Rookie

    Points: 39

    This could have easily done in the file connection manager expression., the dynamic creation of file. no need to have the script task in place to solve that requirement.

    No need to have the expression task also. we could easily do in the flat file destination it self.

  • g.britton

    SSChampion

    Points: 13686

    No need to use the expression task its true, but the task makes it more visible than buried in the connector properties.

    Gerald Britton, MCSE-DP, MVPToronto PASS Chapter[/url]

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the insights on this one.

  • Darryl Wilson

    Mr or Mrs. 500

    Points: 511

    Hi this isnt working me for me. Can you help me please

    Its currently Causing a DTS Script Task: Runtime Error:

    SSIS package "\\staffhome\staff_home0\xxxxxxx\Documents\Visual Studio 2015\Projects\Simple FTP Task\Simple FTP Task\Package.dtsx" starting.

    Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.

    Error: 0x1 at Script Task: Exception has been thrown by the target of an invocation.

    Task failed: Script Task

    Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

    SSIS package "\\staffhome\staff_home0\xxxxxxx\Documents\Visual Studio 2015\Projects\Simple FTP Task\Simple FTP Task\Package.dtsx" finished: Failure.

    The program '[3780] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).

     

    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

    at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

    at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)

    at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()

    Darryl Wilson
    darrylw99@hotmail.com

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply