October 19, 2012 at 8:25 am
I'm totally boogered on this one. I followed the following link:
http://consultingblogs.emc.com/jamiethomson/archive/2008/04/17/ssis-deleting-a-group-of-files.aspx
I did everything the instructions said, but I'm getting an error that the User variable is being used as a source or destination and is empty. Not sure what to do with it.
Any help is appreciated.
October 19, 2012 at 8:57 am
On your filesystem task set delay validation to "True". This will get rid of the error or you can initialize the value of the variable to something.
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 19, 2012 at 9:01 am
chang.hahn (10/19/2012)
On your filesystem task set delay validation to "True". This will get rid of the error or you can initialize the value of the variable to something.
Ok. I did that, and it ran but it still didn't delete the files. How do I initialize the value of the variable?
October 19, 2012 at 9:10 am
Ok... it works... BUT....the red X on the File System Task is still there... container works, but says it's broken... What gives?
October 19, 2012 at 9:15 am
It's just the UI not refreshing. Just open the filesystem task edit and reselect the variable and ok out of the editor.
Select your variable from the package explorer and in the properties box type something into the Value property. Any character will do
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 19, 2012 at 12:42 pm
Just open the filesystem task edit and reselect the variable and ok out of the editor.
Did that...
Select your variable from the package explorer and in the properties box type something into the Value property. Any character will do
I don't see a "Package Explorer". Variable Explorer, Properties, Solution Explorer, Tool Box... I went to the Variable Explorer and put something in the Value column for it. (EDIT) I found the Package Explorer --tab-- and verified what I did previously. Again... no change.
Along with the first part, no change.
Crusty.
(EDIT---AGAIN)... stating that the GUI wasn't refreshing gave me an idea. I saved and closed the package, then reopened. All is good now.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply