Viewing 15 posts - 646 through 660 (of 4,272 total)
You are developing in 32-bit and running in 64, the 64-bit drivers are not installed on the server and therefore the class is not registered.
Either install 64-bit drivers or force...
January 13, 2012 at 8:20 am
Execution of a package from SQL is already painful so this is even more complex.
You can probably disable some components by changing parameters on the command line. But I...
January 11, 2012 at 9:54 pm
True, but since a password in a variable would generally not be considered sensitive it is probably in the SSIS package code in clear text..
CEWII
January 10, 2012 at 2:31 pm
That is really quite odd.. If the permissions at the folder and share levels are good all I can think of is file permissions and thats a stretch. ...
January 10, 2012 at 12:35 pm
Depends on what you are trying to comply with.. And you might switch to EncryptAllWithPassword then you'd have to have the PW to even open the package.
CEWII
January 10, 2012 at 12:17 pm
I have a better idea, why don't you add a script component that takes the rows and builds an XML fragment which can be written into a common table, then...
January 10, 2012 at 12:09 pm
jck.locke (1/10/2012)
Nimesh_Parikh (1/10/2012)
can you please check your Package Owner and Execution Owner both are same? Both of them should have permission on your all folders.
I have not deployed my package...
January 10, 2012 at 8:37 am
jck.locke (1/9/2012)
January 9, 2012 at 12:44 pm
SSIS runs in the context it is started in. ie: the proxy account. You said the usre has full access on the folders, but did you check the...
January 9, 2012 at 9:56 am
Thought we were talking about production runs not development... However, I am generally willing to take the performance hit to test locally.. Maybe its just me..
CEWII
January 5, 2012 at 3:35 pm
You can accomplish this RIGHT NOW, its called an SSIS Server..
CEWII
January 5, 2012 at 11:40 am
Sorry, but I'm going to be kind of rigid on this topic. While I understand wanting to be as customer focused and flexible as possible BUT if you want...
January 5, 2012 at 9:29 am
So you are running all the packages manually and you aren't using all the processor you'd like to be..
Why are you not using an SSIS service?
CEWII
January 4, 2012 at 12:14 pm
I'd probably put a Row Count component in the flow and then use the value as part of the contraints to fail the package.
CEWII
January 3, 2012 at 6:30 pm
Viewing 15 posts - 646 through 660 (of 4,272 total)