Viewing 5 posts - 1 through 5 (of 5 total)
That's it!
I chose Fully Qualified and got it working. I previously had Name and Extension checked.
Thanks a million.
June 17, 2011 at 1:04 pm
Under Collections Tab:
Expressions:
-Directory: @[User::TRACKLOCATION] (variable that holds the folder location, but you probably already knew that)
-FileSpec: "carrtrack" +
RIGHT((DT_WSTR,2)MONTH(DATEADD("DD",-1,GETDATE())),2) + RIGHT("0" + (DT_WSTR,2)DAY(DATEADD("d",-1,GETDATE())),2) +
(DT_WSTR,4)YEAR(GETDATE())+"*.txt"
Under...
June 16, 2011 at 2:52 pm
Ah, you're right. My file DOES have a space before the .txt. I feel pretty stupid after missing that.
When I run the task, this is what I get:
SSIS package "MalvernShipmentAndDelivery.dtsx"...
June 16, 2011 at 1:48 pm
I'm still working through this and haven't figured it out yet. I wonder if because I'm using a wildcard(*) that it somehow adds a space where the wildcard sits in...
June 15, 2011 at 2:02 pm
Thanks for the reply, Kevin. I'll consider that option. Although at this point I'd like to finish in the direction that I started instead of starting a new route.
I'm very...
June 15, 2011 at 6:30 am
Viewing 5 posts - 1 through 5 (of 5 total)