Problem with flat file connection manager
-
Hi,
I have a problem with creating a flat file connection to a CSV file. My file is good - I've tried several files, created new files, recreated the connection, restarted BIDs, however, whatever I do I get all options greyed out other than Browse and the message "a valid file must be specified".
I can only find one difference between this example and others I have which work & that is file permissions - on all of my working examples I have rights to each step in my file path (EG \\file server\folder\sub folder - I have rights to the file server, the folder and the sub folder).
However in my non working example I have full control at the lowest point in the tree (eg with \\server\folder\sub-folder I have full control on sub-folder) but no direct rights to the folders above. Is there a way to stop SSIS checking each level of the folder structure? I've tried delaying validation to no avail. My only workaround is to map a drive letter via a dos prompt which works perfectly, unfortunately I cannot figure out how to script mapping a drive.
So can anyone either tell me how to script mapping a drive in SSIS (I'm using a variable for the path) or clarify if there is a way to stop SSIS checking permissions along the path?
Thanks
-
Is it possible to copy the file to a local drive and then process it from there?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Yes it is, in fact that is what I've now started to do - the only "problem" with that is ensuring another drive location I know that will be available for production run - it's just another one of those extra things to check and an annoying extra step.
Still it works which is better than not working so I'm as happy as I get for now!
Thanks
-
Looks like, the file gets archived or moved from there...Try setting delay validation = true...This may help...
VG
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply