SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Ssis error: object not set to a valid object type
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 06/09/2014 :  10:43:15  Show Profile  Reply with Quote

Group: General Forum Members
Last Login: Today @ 3:32:39 PM
Points: 3,Visits: 10

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.
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000