CODEWITHSUNDEEP
sqlsql-server-2008t-sqlssis
Alex Gordon
Alex Gordon

Reputation: 60711

using SSIS to copy a file

When trying to run a task to copy a file, I'm getting this message:

TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at File System Task: Failed to lock variable "C:\Users\agordon\amtu2\DocumentTransport\production\reports\ORDER18940610353.txt" for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.".

Error at File System Task [File System Task]: An error occurred with the following error message: "Failed to lock variable "C:\Users\agordon\amtu2\DocumentTransport\production\reports\ORDER18940610353.txt" for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.".
".

Error at File System Task: There were errors during task validation.

 (Microsoft.DataTransformationServices.VsIntegration)

------------------------------
BUTTONS:

OK
------------------------------

My schema looks like this:

enter image description here

Here are the properties of the failing component:

enter image description here

Here is the expressions section of the failing componenet:

enter image description here

And finally, here are my parameters:

enter image description here

What am I doing wrong?

Should I completely eliminate this File System Task and replace it with a C# Script Task to copy the file?

Is there something obviously wrong with my process?

I apologize for the size of the images, I think stackoverflow resizes them. The originals are here:

http://screencast.com/t/PvjBHWWHQ8
http://screencast.com/t/JWfs2n2uD8mu
http://screencast.com/t/T68ttqHo
http://screencast.com/t/89KCF8B0qBd

Upvotes: 0

Views: 381

Answers (2)

phillyflats
phillyflats

Reputation: 133

Your SourceVariable property (in screenshot #2) should refer to your a variable name, not the actual value of the variable.

Upvotes: 1

barrypicker
barrypicker

Reputation: 10088

the properties page is asking for a variable name and you are providing a file path. Do you have a variable in your SSIS package that can hold the fully qualified file name?

Upvotes: 2

Related Questions