Viewing 15 posts - 2,326 through 2,340 (of 4,272 total)
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...
April 19, 2010 at 10:59 am
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...
April 19, 2010 at 10:22 am
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...
April 19, 2010 at 10:12 am
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...
April 19, 2010 at 10:08 am
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...
April 19, 2010 at 9:41 am
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...
April 19, 2010 at 9:36 am
Lowell (4/16/2010)
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...
April 18, 2010 at 10:48 pm
How do you handle the case where the package dies in process?
CEWII
April 16, 2010 at 2:53 pm
I rarely use the filesystem task myself..
CEWII
April 16, 2010 at 12:51 pm
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...
April 16, 2010 at 12:09 pm
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...
April 16, 2010 at 12:04 pm
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...
April 16, 2010 at 11:43 am
Viewing 15 posts - 2,326 through 2,340 (of 4,272 total)