I think you have a larger problem.

The users you don't want to have access to the data should be at LEAST not granted EXEC rights on the sproc, and perhaps...

You are very welcome.

CEWII

Access denied is usually just that. Where is the file in relation to the SQL Server trying to run it, what I mean is whether the file is on...

I'm willing to bet that the output field from the source is configured for 255 characters. Use the Advanced Editor to see how that field is defined. You...

You could use an EXEC sql task to fill a variable of type Object and use the "Foreach ADO Enumerator" instead. Then you could control what ends up in...

Package has to be running already to see the file dropped.

You could build a windows service to watch for the drop then start a package or you could poll the...

1. SSIS can be installed seperately from SQL Server. You basically ONL choose SSIS when you do the install.

2. Licensing is STEEP, SSIS is NOT licensed seperately, you are...

Lowell (4/16/2010)

---

i must have tunnel vision this morning;

i didn't see any BULK insert scripts for the files; after downloading the csv files, i see they are UNIX style(slash r for...

Wonderful, glad to hear it..

CEWII

How do you handle the case where the package dies in process?

CEWII

I rarely use the filesystem task myself..

CEWII

No there isn't.

But I would make this point. Good code control requires that msdb be where deployed code goes not where it is edited directly. What...

A derived column is the right path. What are you using to loop through the directory? A For-Each-Loop?

Also, why don't you add a data-viewer to see...

What do you mean by "The dummy script task is created to redirect the flow to the foreach loop container" I don't see you needing to redirect it.

Look at...

Nadrek,

I largely agree with you. However, I am a fan of the right tool for the right job, and let me be clear, .net or almost all procedural language...