Ssis error: object not set to a valid object type
-
I have a for each container that is enumerating inside excel files. I have a file system task inside the container. The file system has to copy files from source to destination. User:working is the variable for destination. ArgValue is the variable for source. Both are string variables having the path name. So I execute the foreach container. Two things are wrong
1) it does not go inside and execute the file system task
2)it shows green but throws error variable not set to a valid object type. This foreach container is referring to two variables Argvalue and ArgId. This ArgId is an object variable. The Argvalue is referred in the Variable mapping section.
I am really confused why it is throwing this error when I execute the container. It does not go in the File System task. I tried executing the File system separately and it works. But it defeats the whole purpose of the container. It must execute inside the container. It has been taking a while. Please help.
-
ayazniazi (6/8/2014)
I have a for each container that is enumerating inside excel files. I have a file system task inside the container. The file system has to copy files from source to destination. User:working is the variable for destination. ArgValue is the variable for source. Both are string variables having the path name. So I execute the foreach container. Two things are wrong1) it does not go inside and execute the file system task
2)it shows green but throws error variable not set to a valid object type. This foreach container is referring to two variables Argvalue and ArgId. This ArgId is an object variable. The Argvalue is referred in the Variable mapping section.
I am really confused why it is throwing this error when I execute the container. It does not go in the File System task. I tried executing the File system separately and it works. But it defeats the whole purpose of the container. It must execute inside the container. It has been taking a while. Please help.
Quick questions, what is the collection type property for the foreach container? How do you pass the directory location?
-
It is a Foreach ADO Enumerator
In the enumerator configuration I have set the object source variable to subtaskArgs which is an Object variable.
In variable mappings I have subtaskArgValue which is a string variable having the path. Let me know if you have any more questions.
-
ayazniazi (6/9/2014)
It is a Foreach ADO EnumeratorIn the enumerator configuration I have set the object source variable to subtaskArgs which is an Object variable.
In variable mappings I have subtaskArgValue which is a string variable having the path. Let me know if you have any more questions.
Check out this article on Foreach configuration, think it has the answer to your problem.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply