Forget about the clumsy SubString syntax. I've found a code sample for getting the file name any way you want. Tested it and it worked like a chime. I'd never figure out such a simple way to use the REVERSE function. Here is the link in case someone needs it...
Never mind. I could get the fully qualified file name including the path. (I just dragged and dropped the other variable instead.) I'm now struggling with the SUBSTRING syntax over the expression so that I can just take the file name without the path.
Thanks.
Actually, I'm using exactly the same process to pass the file name to the table but since I set the file name in the Script Task as "abc_date*.dat" so after I drag and drop the User::FileName in the Derived Column's expression, that's what I currently got into the table. I think I need to do...
One more question on this.
I also need to capture the file name and write it to the table, right now I can only write out something like "abc_20081110*.dat" because the variable "WildCard" is set that way. How can I capture the real file name with the timestamp such as "abc_20081110_032015.dat"?
I now tried to use script task to update the FileName variable and it worked the way I wanted but the wildcard still not working with the following VB.Net code. I hope someone can point the syntax mistake I made.
FilePart = Format(Now, "yyyy")& Format(Now, "mm") & Format(Now,"dd"...
Thanks for responding to my question.
I finally got it. The systax was fine but I got unexpected carriage returns in the middle of the string so it failed. After re-typing the whole expression again, it worked.
I have a task to run a package to check a flat file existence daily and if it exists then import the file into the database.
Since the file names look like this "abc_20081021_123456.dat", I can set a file name variable to find the file name with current date info and I used a wildcard for the...
I have a flat file trailer row that looks like this: T|3|2007120713:39:59
I'm able to extract the row using conditional split but I want to convert the datatime string into datatimestamp so I can insert it into a table. I built the derived column expression as following but got errors such as...
I had a very similar problem with CRXI and Oracle SP with date parameters. I couldn't create the report because CR's default parameter automatically set the data type to "datetime" and it's not updatable to "date" which is what Oracle sp's parameters' data type so the Crystal just threw out...
Thanks, what you said makes sense. I tried your suggested method but still couldn't isolate the problem. When I clicked the browse button for the addins that were original checked but there were no files. The addin folder is empty. Do I need to try repairing the installation?
When I opened the application while holding the shift key, got another error msg "cannot open MS Excel Add-In for editing. Please edit the source document instead."
Then I did as what you asked to open the VB code windows but nothing was there under both general and workbook.
I'm using Windows XP Pro and just upgraded my MS Office from 97 to 2003. Everything else seems to work fine except Excel.
Every time I open the program or a .xls file I got multiple occurance (about 12 times each) of 2 error messages before I can open the program or the file. One error is...
Thanks, guys. I didn't want to got rid of the subreport in the beginning but that was the only option I had so I did. Now the report runs fine without the overhead of running the subreport for each record on the main report.
I have a report that has a one-to-many relationship between the main report and the subreport. Since it is pulling a full month long data and the subreport's main table is left-outer-joined with three other tables so it takes an hour to run. I have isolated the problem being on the report side...
I couldn't figure out what was wrong or how to fix the problem with incompatibility after spending too much time on it, e.g. between finding similar posts online, checking the s/w updates, reference library and VBA codes, etc. I finally gave up and just worked around the issues I encountered...
I just thought of a very simple workaround of my problem after checked my VBA reference library, tried some other workarouds then it just came to me that I only needed to use REPLACE method to modify the value of my filter to something like 'abc%xyz.com' and passed it to a SQL string for...
Hi,
I just migrated from A2K project to A2K3. A2K3 has a new reserved word '@' that causes a problem issue for my application. I have a text field with email addresses, if I try to filter using this field on the form, Access would just take something like 'abc@xyz.com' and translates it into...
I have an Access adp file developed on Access 2000, now one of my clients upgraded herself to Office 2003 and she downloaded the db's UI and is getting all kinds of error messages while her other old PC still running Access 2000 doesn't have any problem.
I'm very sure that the problem is with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.