How to FTP a Dynamically Named Flat File

Question

How to FTP a Dynamically Named Flat File

2Tall

SSChampion

Points: 14644
More actions
May 3, 2015 at 7:12 am

#317913

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

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

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

g.britton SSChampion Points: 13863 More actions · Answer 1

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, Pluralsight courses

jpkothapalli09 SSC Rookie Points: 39 More actions · Answer 2

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: 13863 More actions · Answer 3

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

Gerald Britton, Pluralsight courses

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

akljfhnlaflkj

SSC Guru

Points: 76202

May 5, 2015 at 7:22 am

#1795598

Thanks for the insights on this one.

Darryl Wilson Mr or Mrs. 500 Points: 526 More actions · Answer 5

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